PREVIEW / etf_1hour / 2011-12-19

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-12-19.parquet
  size:    184 KB
  rows:    5,658

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-12-19 04:00:00	SPY	ETF	121.28	122.2	121.28	122.2	53669.0
2011-12-19 05:00:00	SPY	ETF	122.15	122.36	122.15	122.23	36430.0
2011-12-19 06:00:00	SPY	ETF	122.19	122.38	122.04	122.38	99172.0
2011-12-19 07:00:00	SPY	ETF	122.37	122.45	121.98	122.02	963660.0
2011-12-19 08:00:00	SPY	ETF	122.01	122.38	121.97	122.24	2079163.0
2011-12-19 09:00:00	SPY	ETF	122.24	122.32	121.88	122.039	19787051.0
2011-12-19 10:00:00	SPY	ETF	122.04	122.2	121.39	121.47	26999229.0
2011-12-19 11:00:00	SPY	ETF	121.46	121.51	120.71	120.85	25205375.0
2011-12-19 12:00:00	SPY	ETF	120.85	121.15	120.81	121.15	12431404.0
2011-12-19 13:00:00	SPY	ETF	121.15	121.35	120.86	121.25	16749981.0
2011-12-19 14:00:00	SPY	ETF	121.25	121.29	120.87	121.08	12334155.0
2011-12-19 15:00:00	SPY	ETF	121.08	121.7792	120.03	120.33	51382893.0
2011-12-19 16:00:00	SPY	ETF	120.33	121.7792	120.27	120.44	10945496.0
2011-12-19 17:00:00	SPY	ETF	120.44	120.45	120.32	120.45	296154.0
2011-12-19 18:00:00	SPY	ETF	120.45	120.78	120.32	120.78	618183.0
2011-12-19 19:00:00	SPY	ETF	120.78	121.0	120.76	120.98	337203.0
2011-12-19 04:00:00	QQQ	ETF	55.0	55.19	55.0	55.18	2800.0
2011-12-19 05:00:00	QQQ	ETF	55.18	55.29	55.18	55.22	9614.0
2011-12-19 06:00:00	QQQ	ETF	55.24	55.24	55.17	55.24	14193.0
2011-12-19 07:00:00	QQQ	ETF	55.25	55.3	55.09	55.09	70200.0
2011-12-19 08:00:00	QQQ	ETF	55.1	55.23	54.58	55.17	363733.0
2011-12-19 09:00:00	QQQ	ETF	55.17	55.2	54.94	55.08	3298615.0
2011-12-19 10:00:00	QQQ	ETF	55.09	55.18	54.76	54.81	6710424.0
2011-12-19 11:00:00	QQQ	ETF	54.8	54.85	54.51	54.63	5128393.0
2011-12-19 12:00:00	QQQ	ETF	54.63	54.7893	54.61	54.73	2417629.0
2011-12-19 13:00:00	QQQ	ETF	54.74	54.76	54.58	54.7099	2695337.0
2011-12-19 14:00:00	QQQ	ETF	54.7	54.878	54.53	54.635	3598025.0
2011-12-19 15:00:00	QQQ	ETF	54.63	54.64	54.17	54.33	14385167.0
2011-12-19 16:00:00	QQQ	ETF	54.33	54.44	54.2628	54.42	5297456.0
2011-12-19 17:00:00	QQQ	ETF	54.4	54.45	54.4	54.41	38896.0
2011-12-19 18:00:00	QQQ	ETF	54.44	54.56	54.42	54.55	40399.0
2011-12-19 19:00:00	QQQ	ETF	54.58	54.65	54.54	54.64	41595.0
2011-12-19 04:00:00	IWM	ETF	72.44	72.44	72.44	72.44	100.0
2011-12-19 05:00:00	IWM	ETF	73.1	73.1	73.09	73.09	300.0
2011-12-19 06:00:00	IWM	ETF	72.96	73.12	72.96	73.12	50100.0
2011-12-19 07:00:00	IWM	ETF	73.12	73.14	72.82	72.82	45625.0
2011-12-19 08:00:00	IWM	ETF	72.84	73.1	72.8	73.08	244087.0
2011-12-19 09:00:00	IWM	ETF	73.04	73.2	72.67	72.87	5145219.0
2011-12-19 10:00:00	IWM	ETF	72.87	73.1	72.37	72.46	5509547.0
2011-12-19 11:00:00	IWM	ETF	72.45	72.46	71.55	71.67	5477112.0
2011-12-19 12:00:00	IWM	ETF	71.67	72.01	71.62	72.01	1986302.0
2011-12-19 13:00:00	IWM	ETF	72.01	72.07	71.66	71.96	2171612.0
2011-12-19 14:00:00	IWM	ETF	71.9599	71.965	71.67	71.8284	1688698.0
2011-12-19 15:00:00	IWM	ETF	71.82	71.84	70.83	70.97	14371984.0
2011-12-19 16:00:00	IWM	ETF	70.98	72.9	70.73	70.94	7018907.0
2011-12-19 17:00:00	IWM	ETF	70.93	71.02	70.92	71.02	75900.0
2011-12-19 18:00:00	IWM	ETF	71.13	71.13	71.05	71.12	13817.0
2011-12-19 19:00:00	IWM	ETF	71.14	71.28	71.14	71.28	30400.0
2011-12-19 04:00:00	DIA	ETF	118.55	118.55	118.55	118.55	100.0
2011-12-19 08:00:00	DIA	ETF	118.47	118.81	118.47	118.72	7740.0

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

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