PREVIEW / etf_1hour / 2011-11-10

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-11-10.parquet
  size:    180 KB
  rows:    5,515

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2011-11-10 04:00:00	SPY	ETF	123.5	124.77	123.5	124.56	71112.0
2011-11-10 05:00:00	SPY	ETF	124.77	124.87	123.72	124.32	105675.0
2011-11-10 06:00:00	SPY	ETF	124.1	124.61	123.9	124.61	176600.0
2011-11-10 07:00:00	SPY	ETF	124.55	125.03	124.31	124.77	1703645.0
2011-11-10 08:00:00	SPY	ETF	123.98	125.05	123.85	124.91	3968508.0
2011-11-10 09:00:00	SPY	ETF	124.91	124.94	123.19	123.96	27639831.0
2011-11-10 10:00:00	SPY	ETF	123.96	124.32	123.02	123.42	44878689.0
2011-11-10 11:00:00	SPY	ETF	123.42	124.47	123.34	124.18	32894671.0
2011-11-10 12:00:00	SPY	ETF	124.19	124.39	123.65	124.2407	19021141.0
2011-11-10 13:00:00	SPY	ETF	124.25	124.94	124.18	124.65	25134562.0
2011-11-10 14:00:00	SPY	ETF	124.65	124.72	123.79	123.797	22886608.0
2011-11-10 15:00:00	SPY	ETF	123.8	124.56	123.75	124.25	40127225.0
2011-11-10 16:00:00	SPY	ETF	124.28	124.44	123.1863	124.42	12217509.0
2011-11-10 17:00:00	SPY	ETF	124.41	124.5	124.35	124.37	166373.0
2011-11-10 18:00:00	SPY	ETF	124.35	124.46	124.18	124.28	248883.0
2011-11-10 19:00:00	SPY	ETF	124.3	124.43	123.95	124.1	306167.0
2011-11-10 20:00:00	SPY	ETF	124.1	124.12	124.1	124.12	1000.0
2011-11-10 04:00:00	QQQ	ETF	57.11	57.52	57.08	57.46	12920.0
2011-11-10 05:00:00	QQQ	ETF	57.45	57.48	57.27	57.27	7900.0
2011-11-10 06:00:00	QQQ	ETF	57.3	57.4	57.14	57.4	7900.0
2011-11-10 07:00:00	QQQ	ETF	57.41	57.62	57.33	57.51	123278.0
2011-11-10 08:00:00	QQQ	ETF	57.5	57.6	57.37	57.51	387345.0
2011-11-10 09:00:00	QQQ	ETF	57.51	57.51	56.76	56.79	6819216.0
2011-11-10 10:00:00	QQQ	ETF	56.79	56.97	56.23	56.45	15200664.0
2011-11-10 11:00:00	QQQ	ETF	56.45	56.98	56.425	56.83	11495810.0
2011-11-10 12:00:00	QQQ	ETF	56.83	56.86	56.51	56.76	4734975.0
2011-11-10 13:00:00	QQQ	ETF	56.76	57.11	56.73	57.0	5958060.0
2011-11-10 14:00:00	QQQ	ETF	57.0	57.03	56.57	56.58	5521590.0
2011-11-10 15:00:00	QQQ	ETF	56.58	56.9	56.54	56.75	9730120.0
2011-11-10 16:00:00	QQQ	ETF	56.76	56.81	56.66	56.78	2992312.0
2011-11-10 17:00:00	QQQ	ETF	56.8	56.84	56.76	56.8	87626.0
2011-11-10 18:00:00	QQQ	ETF	56.76	56.79	56.66	56.79	35130.0
2011-11-10 19:00:00	QQQ	ETF	56.78	56.78	56.6	56.66	80600.0
2011-11-10 04:00:00	IWM	ETF	72.1	72.87	72.09	72.87	3714.0
2011-11-10 05:00:00	IWM	ETF	72.73	72.73	72.1	72.49	1005.0
2011-11-10 06:00:00	IWM	ETF	72.5	72.75	72.44	72.75	2086.0
2011-11-10 07:00:00	IWM	ETF	72.7	73.06	72.68	72.92	267924.0
2011-11-10 08:00:00	IWM	ETF	72.92	73.06	72.5	73.01	595622.0
2011-11-10 09:00:00	IWM	ETF	72.99	73.23	72.1	72.13	14727422.0
2011-11-10 10:00:00	IWM	ETF	72.13	72.61	71.63	72.14	14400523.0
2011-11-10 11:00:00	IWM	ETF	72.15	72.88	72.1	72.65	11252154.0
2011-11-10 12:00:00	IWM	ETF	72.65	72.94	72.3	72.77	3924155.0
2011-11-10 13:00:00	IWM	ETF	72.77	73.149	72.49	72.72	5005808.0
2011-11-10 14:00:00	IWM	ETF	72.73	72.76	72.0	72.0	4841880.0
2011-11-10 15:00:00	IWM	ETF	72.01	72.62	71.95	72.44	10572301.0
2011-11-10 16:00:00	IWM	ETF	72.44	73.55	72.23	72.37	824565.0
2011-11-10 17:00:00	IWM	ETF	72.38	72.41	72.27	72.27	28551.0
2011-11-10 18:00:00	IWM	ETF	72.27	72.27	72.2	72.25	27167.0
2011-11-10 19:00:00	IWM	ETF	72.29	72.3	72.04	72.09	11764.0
2011-11-10 04:00:00	DIA	ETF	118.2	118.2	118.2	118.2	200.0

> showing 50 of 5,515 rows — these rows as CSV

> unlock the full archive -- $79 one-time