PREVIEW / etf_1hour / 2012-01-20

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-01-20.parquet
  size:    181 KB
  rows:    5,592

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
2012-01-20 04:00:00	SPY	ETF	131.18	131.18	131.07	131.07	1100.0
2012-01-20 05:00:00	SPY	ETF	131.06	131.36	131.01	131.18	17100.0
2012-01-20 06:00:00	SPY	ETF	131.18	131.28	131.1	131.14	201690.0
2012-01-20 07:00:00	SPY	ETF	131.11	131.4	131.05	131.24	530508.0
2012-01-20 08:00:00	SPY	ETF	131.25	131.34	131.03	131.17	4401616.0
2012-01-20 09:00:00	SPY	ETF	131.16	131.4036	131.07	131.27	21231507.0
2012-01-20 10:00:00	SPY	ETF	131.28	131.32	131.0	131.11	18749555.0
2012-01-20 11:00:00	SPY	ETF	131.11	131.15	130.92	131.073	11358876.0
2012-01-20 12:00:00	SPY	ETF	131.075	131.28	131.04	131.22	9238037.0
2012-01-20 13:00:00	SPY	ETF	131.21	131.39	131.2	131.23	8174465.0
2012-01-20 14:00:00	SPY	ETF	131.23	131.27	131.02	131.18	10096548.0
2012-01-20 15:00:00	SPY	ETF	131.18	131.55	131.17	131.54	25282371.0
2012-01-20 16:00:00	SPY	ETF	131.53	131.61	130.985	131.46	22423083.0
2012-01-20 17:00:00	SPY	ETF	131.45	131.76	131.44	131.74	1149628.0
2012-01-20 18:00:00	SPY	ETF	131.74	131.95	131.64	131.68	86835.0
2012-01-20 19:00:00	SPY	ETF	131.7	131.74	131.66	131.71	63858.0
2012-01-20 04:00:00	QQQ	ETF	59.53	59.53	59.53	59.53	130.0
2012-01-20 05:00:00	QQQ	ETF	59.52	59.66	59.52	59.65	1210.0
2012-01-20 06:00:00	QQQ	ETF	59.64	59.66	59.61	59.62	6300.0
2012-01-20 07:00:00	QQQ	ETF	59.59	59.72	59.58	59.66	117779.0
2012-01-20 08:00:00	QQQ	ETF	59.65	59.65	59.52	59.54	2154733.0
2012-01-20 09:00:00	QQQ	ETF	59.55	59.7	59.52	59.6299	7972727.0
2012-01-20 10:00:00	QQQ	ETF	59.63	59.77	59.57	59.664	7280244.0
2012-01-20 11:00:00	QQQ	ETF	59.67	59.7	59.56	59.65	4082851.0
2012-01-20 12:00:00	QQQ	ETF	59.655	59.71	59.64	59.71	1889562.0
2012-01-20 13:00:00	QQQ	ETF	59.705	59.8	59.69	59.7	3495996.0
2012-01-20 14:00:00	QQQ	ETF	59.7	59.73	59.57	59.6472	2145622.0
2012-01-20 15:00:00	QQQ	ETF	59.648	59.77	59.59	59.77	4817389.0
2012-01-20 16:00:00	QQQ	ETF	59.77	59.85	59.75	59.78	918434.0
2012-01-20 17:00:00	QQQ	ETF	59.79	59.89	59.78	59.82	88225.0
2012-01-20 18:00:00	QQQ	ETF	59.82	59.87	59.82	59.85	3942.0
2012-01-20 19:00:00	QQQ	ETF	59.84	59.87	59.82	59.82	7517.0
2012-01-20 07:00:00	IWM	ETF	78.11	78.15	78.05	78.05	125160.0
2012-01-20 08:00:00	IWM	ETF	78.06	78.12	77.91	78.01	578194.0
2012-01-20 09:00:00	IWM	ETF	78.06	78.25	77.9	78.2	5502661.0
2012-01-20 10:00:00	IWM	ETF	78.23	78.33	77.98	78.17	5511044.0
2012-01-20 11:00:00	IWM	ETF	78.18	78.22	77.92	78.07	4549956.0
2012-01-20 12:00:00	IWM	ETF	78.08	78.11	78.03	78.07	1339292.0
2012-01-20 13:00:00	IWM	ETF	78.07	78.3	78.06	78.15	4080760.0
2012-01-20 14:00:00	IWM	ETF	78.15	78.18	77.97	78.03	1976007.0
2012-01-20 15:00:00	IWM	ETF	78.03	78.51	78.03	78.27	9668665.0
2012-01-20 16:00:00	IWM	ETF	78.27	78.38	78.15	78.35	4370154.0
2012-01-20 17:00:00	IWM	ETF	78.35	78.43	78.33	78.42	31604.0
2012-01-20 19:00:00	IWM	ETF	78.43	78.46	78.4	78.41	4200.0
2012-01-20 07:00:00	DIA	ETF	126.09	126.11	126.09	126.11	800.0
2012-01-20 08:00:00	DIA	ETF	126.05	126.05	125.9	125.95	15200.0
2012-01-20 09:00:00	DIA	ETF	125.99	126.44	125.94	126.34	762578.0
2012-01-20 10:00:00	DIA	ETF	126.3	126.66	126.2	126.52	1926043.0
2012-01-20 11:00:00	DIA	ETF	126.52	126.55	126.32	126.47	640335.0
2012-01-20 12:00:00	DIA	ETF	126.47	126.64	126.45	126.56	612590.0

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

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