PREVIEW / etf_1hour / 2012-01-09

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-01-09.parquet
  size:    180 KB
  rows:    5,606

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-09 04:00:00	SPY	ETF	127.82	127.97	127.75	127.97	1050.0
2012-01-09 05:00:00	SPY	ETF	127.78	127.89	127.77	127.89	70000.0
2012-01-09 06:00:00	SPY	ETF	127.76	128.11	127.62	127.62	14300.0
2012-01-09 07:00:00	SPY	ETF	127.85	128.24	127.68	128.02	200676.0
2012-01-09 08:00:00	SPY	ETF	128.02	128.18	127.75	128.12	1157266.0
2012-01-09 09:00:00	SPY	ETF	128.13	128.15	127.66	127.799	14071717.0
2012-01-09 10:00:00	SPY	ETF	127.81	128.17	127.58	127.74	17790158.0
2012-01-09 11:00:00	SPY	ETF	127.74	127.8299	127.41	127.71	15722784.0
2012-01-09 12:00:00	SPY	ETF	127.7	127.93	127.62	127.87	8244647.0
2012-01-09 13:00:00	SPY	ETF	127.87	128.02	127.83	127.99	7687450.0
2012-01-09 14:00:00	SPY	ETF	127.985	128.18	127.94	127.98	8139795.0
2012-01-09 15:00:00	SPY	ETF	127.98	128.18	127.94	128.0	16473200.0
2012-01-09 16:00:00	SPY	ETF	128.0	128.08	127.7536	127.95	7041806.0
2012-01-09 17:00:00	SPY	ETF	127.95	128.05	127.93	128.04	47814.0
2012-01-09 18:00:00	SPY	ETF	128.02	128.17	127.98	128.17	121258.0
2012-01-09 19:00:00	SPY	ETF	128.18	128.34	128.17	128.22	183652.0
2012-01-09 04:00:00	QQQ	ETF	57.9	57.9	57.9	57.9	100.0
2012-01-09 07:00:00	QQQ	ETF	57.86	58.07	57.86	57.96	33118.0
2012-01-09 08:00:00	QQQ	ETF	57.96	58.02	57.89	58.0	235432.0
2012-01-09 09:00:00	QQQ	ETF	58.0	58.01	57.7	57.78	3718286.0
2012-01-09 10:00:00	QQQ	ETF	57.785	57.89	57.55	57.625	5247763.0
2012-01-09 11:00:00	QQQ	ETF	57.625	57.71	57.431	57.58	6948427.0
2012-01-09 12:00:00	QQQ	ETF	57.59	57.69	57.51	57.66	3773244.0
2012-01-09 13:00:00	QQQ	ETF	57.67	57.74	57.625	57.7	4179685.0
2012-01-09 14:00:00	QQQ	ETF	57.7	57.83	57.68	57.73	4075935.0
2012-01-09 15:00:00	QQQ	ETF	57.725	57.78	57.62	57.64	5455381.0
2012-01-09 16:00:00	QQQ	ETF	57.64	57.7374	57.61	57.66	1964384.0
2012-01-09 17:00:00	QQQ	ETF	57.66	57.72	57.65	57.68	17600.0
2012-01-09 18:00:00	QQQ	ETF	57.68	57.75	57.65	57.75	129405.0
2012-01-09 19:00:00	QQQ	ETF	57.78	57.83	57.78	57.8	25900.0
2012-01-09 04:00:00	IWM	ETF	74.8	74.86	74.8	74.86	1860.0
2012-01-09 07:00:00	IWM	ETF	75.05	75.08	75.05	75.08	3098.0
2012-01-09 08:00:00	IWM	ETF	75.07	75.18	75.0	75.13	174775.0
2012-01-09 09:00:00	IWM	ETF	75.14	75.17	74.65	74.95	4390370.0
2012-01-09 10:00:00	IWM	ETF	74.95	75.29	74.71	74.91	6068548.0
2012-01-09 11:00:00	IWM	ETF	74.91	75.07	74.41	74.95	7144730.0
2012-01-09 12:00:00	IWM	ETF	74.95	75.24	74.89	75.13	3693928.0
2012-01-09 13:00:00	IWM	ETF	75.13	75.21	74.98	75.14	2857575.0
2012-01-09 14:00:00	IWM	ETF	75.14	75.301	75.08	75.13	3180267.0
2012-01-09 15:00:00	IWM	ETF	75.13	75.27	75.04	75.16	5325356.0
2012-01-09 16:00:00	IWM	ETF	75.17	75.26	75.07	75.15	5962774.0
2012-01-09 17:00:00	IWM	ETF	75.16	75.19	75.14	75.19	2300.0
2012-01-09 18:00:00	IWM	ETF	75.23	75.25	75.23	75.23	25400.0
2012-01-09 19:00:00	IWM	ETF	75.26	75.33	75.26	75.33	2300.0
2012-01-09 07:00:00	DIA	ETF	123.51	123.8	123.51	123.8	1600.0
2012-01-09 08:00:00	DIA	ETF	123.74	123.74	123.63	123.63	2000.0
2012-01-09 09:00:00	DIA	ETF	123.79	123.79	123.33	123.44	719581.0
2012-01-09 10:00:00	DIA	ETF	123.45	123.86	123.27	123.4999	970126.0
2012-01-09 11:00:00	DIA	ETF	123.5	123.51	123.14	123.42	684871.0
2012-01-09 12:00:00	DIA	ETF	123.44	123.64	123.4	123.55	313086.0

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

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