PREVIEW / etf_1hour / 2011-01-11

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-01-11.parquet
  size:    173 KB
  rows:    5,288

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-01-11 04:00:00	SPY	ETF	127.15	127.15	127.0	127.0	3600.0
2011-01-11 05:00:00	SPY	ETF	127.05	127.19	127.05	127.19	27800.0
2011-01-11 06:00:00	SPY	ETF	127.19	127.44	127.19	127.38	30023.0
2011-01-11 07:00:00	SPY	ETF	127.43	127.63	127.43	127.51	406024.0
2011-01-11 08:00:00	SPY	ETF	127.48	127.58	127.4	127.56	989402.0
2011-01-11 09:00:00	SPY	ETF	127.56	127.68	127.27	127.28	12402697.0
2011-01-11 10:00:00	SPY	ETF	127.29	127.56	127.23	127.54	12978369.0
2011-01-11 11:00:00	SPY	ETF	127.54	127.74	127.52	127.61	14160455.0
2011-01-11 12:00:00	SPY	ETF	127.61	127.71	127.53	127.69	7082812.0
2011-01-11 13:00:00	SPY	ETF	127.685	127.72	127.1	127.14	22387680.0
2011-01-11 14:00:00	SPY	ETF	127.15	127.32	126.95	127.29	15399584.0
2011-01-11 15:00:00	SPY	ETF	127.29	127.51	127.24	127.43	17609661.0
2011-01-11 16:00:00	SPY	ETF	127.43	127.735	127.18	127.37	6389345.0
2011-01-11 17:00:00	SPY	ETF	127.37	127.4	127.3	127.36	59505.0
2011-01-11 18:00:00	SPY	ETF	127.35	127.43	127.33	127.43	117160.0
2011-01-11 19:00:00	SPY	ETF	127.44	127.5	127.4	127.5	46543.0
2011-01-11 04:00:00	QQQ	ETF	56.15	56.15	56.14	56.14	400.0
2011-01-11 06:00:00	QQQ	ETF	56.23	56.3	56.23	56.3	41513.0
2011-01-11 07:00:00	QQQ	ETF	56.33	56.37	56.3	56.31	158233.0
2011-01-11 08:00:00	QQQ	ETF	56.31	56.35	56.27	56.34	114211.0
2011-01-11 09:00:00	QQQ	ETF	56.33	56.36	56.12	56.1264	5907852.0
2011-01-11 10:00:00	QQQ	ETF	56.13	56.25	56.1	56.22	5832163.0
2011-01-11 11:00:00	QQQ	ETF	56.22	56.279	56.15	56.185	12022349.0
2011-01-11 12:00:00	QQQ	ETF	56.18	56.265	56.15	56.2435	2298056.0
2011-01-11 13:00:00	QQQ	ETF	56.25	56.25	56.02	56.04	8595533.0
2011-01-11 14:00:00	QQQ	ETF	56.0499	56.14	55.95	56.129	4528660.0
2011-01-11 15:00:00	QQQ	ETF	56.13	56.2	56.08	56.16	8205512.0
2011-01-11 16:00:00	QQQ	ETF	56.15	56.225	56.1033	56.14	1709269.0
2011-01-11 17:00:00	QQQ	ETF	56.11	56.16	56.11	56.12	4932.0
2011-01-11 18:00:00	QQQ	ETF	56.14	56.14	56.12	56.14	9919.0
2011-01-11 19:00:00	QQQ	ETF	56.15	56.18	56.15	56.18	8200.0
2011-01-11 05:00:00	IWM	ETF	79.15	79.15	79.15	79.15	2000.0
2011-01-11 06:00:00	IWM	ETF	79.3	79.33	79.29	79.33	5309.0
2011-01-11 07:00:00	IWM	ETF	79.45	79.49	79.38	79.38	22835.0
2011-01-11 08:00:00	IWM	ETF	79.39	79.42	79.31	79.42	419319.0
2011-01-11 09:00:00	IWM	ETF	79.41	79.57	79.14	79.19	5181398.0
2011-01-11 10:00:00	IWM	ETF	79.19	79.34	79.07	79.29	4109137.0
2011-01-11 11:00:00	IWM	ETF	79.3	79.62	79.3	79.565	4677278.0
2011-01-11 12:00:00	IWM	ETF	79.57	79.68	79.5	79.68	1492503.0
2011-01-11 13:00:00	IWM	ETF	79.68	79.68	78.99	79.0569	7504288.0
2011-01-11 14:00:00	IWM	ETF	79.06	79.25	78.87	79.19	5872692.0
2011-01-11 15:00:00	IWM	ETF	79.19	79.34	79.095	79.3	6901243.0
2011-01-11 16:00:00	IWM	ETF	79.3	79.44	79.0711	79.4	903741.0
2011-01-11 17:00:00	IWM	ETF	79.37	79.4	79.32	79.4	46723.0
2011-01-11 18:00:00	IWM	ETF	79.33	79.33	79.28	79.3	7600.0
2011-01-11 19:00:00	IWM	ETF	79.38	79.38	79.32	79.38	1500.0
2011-01-11 07:00:00	DIA	ETF	116.74	116.74	116.74	116.74	100.0
2011-01-11 08:00:00	DIA	ETF	116.68	116.79	116.62	116.78	9900.0
2011-01-11 09:00:00	DIA	ETF	116.76	116.84	116.5701	116.5728	686685.0
2011-01-11 10:00:00	DIA	ETF	116.58	116.73	116.54	116.72	457949.0

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

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