PREVIEW / etf_1hour / 2009-01-23

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-01-23.parquet
  size:    127 KB
  rows:    3,885

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
2009-01-23 04:00:00	SPY	ETF	81.61	81.61	80.67	80.67	13431.0
2009-01-23 05:00:00	SPY	ETF	80.75	81.12	80.68	81.05	5810.0
2009-01-23 06:00:00	SPY	ETF	80.95	81.54	80.89	81.25	465506.0
2009-01-23 07:00:00	SPY	ETF	81.26	81.64	81.13	81.15	1208507.0
2009-01-23 08:00:00	SPY	ETF	81.15	81.4	80.4	80.41	6115829.0
2009-01-23 09:00:00	SPY	ETF	80.41	81.74	80.4	81.4499	42950952.0
2009-01-23 10:00:00	SPY	ETF	81.45	82.15	81.23	81.54	48139158.0
2009-01-23 11:00:00	SPY	ETF	81.54	82.91	81.53	81.98	54312214.0
2009-01-23 12:00:00	SPY	ETF	81.98	82.89	81.91	82.44	51780948.0
2009-01-23 13:00:00	SPY	ETF	82.44	83.83	82.23	83.82	52431537.0
2009-01-23 14:00:00	SPY	ETF	83.81	83.99	82.55	82.75	53823060.0
2009-01-23 15:00:00	SPY	ETF	82.75	83.54	82.5	83.11	60310279.0
2009-01-23 16:00:00	SPY	ETF	83.1	83.224	81.45	82.86	14756905.0
2009-01-23 17:00:00	SPY	ETF	82.85	82.89	82.71	82.8	97077.0
2009-01-23 18:00:00	SPY	ETF	82.82	82.9	82.78	82.85	29675.0
2009-01-23 19:00:00	SPY	ETF	82.83	82.87	82.72	82.81	18072.0
2009-01-23 04:00:00	QQQ	ETF	28.46	28.46	28.17	28.19	5704.0
2009-01-23 05:00:00	QQQ	ETF	28.21	28.31	28.21	28.31	7780.0
2009-01-23 06:00:00	QQQ	ETF	28.31	28.47	28.25	28.39	68367.0
2009-01-23 07:00:00	QQQ	ETF	28.38	28.47	28.31	28.34	90750.0
2009-01-23 08:00:00	QQQ	ETF	28.34	28.4	28.17	28.18	949138.0
2009-01-23 09:00:00	QQQ	ETF	28.19	28.56	28.14	28.46	21675451.0
2009-01-23 10:00:00	QQQ	ETF	28.46	28.69	28.39	28.441	20836805.0
2009-01-23 11:00:00	QQQ	ETF	28.45	28.93	28.45	28.68	21158057.0
2009-01-23 12:00:00	QQQ	ETF	28.67	28.98	28.65	28.83	18328704.0
2009-01-23 13:00:00	QQQ	ETF	28.82	29.28	28.74	29.28	29828206.0
2009-01-23 14:00:00	QQQ	ETF	29.28	29.35	28.83	28.89	25043499.0
2009-01-23 15:00:00	QQQ	ETF	28.89	29.05	28.76	28.89	24705410.0
2009-01-23 16:00:00	QQQ	ETF	28.9	28.9628	28.68	28.73	5874281.0
2009-01-23 17:00:00	QQQ	ETF	28.73	28.77	28.7	28.74	58802.0
2009-01-23 18:00:00	QQQ	ETF	28.73	28.77	28.71	28.76	19569.0
2009-01-23 19:00:00	QQQ	ETF	28.75	28.76	28.72	28.72	13568.0
2009-01-23 06:00:00	IWM	ETF	43.55	43.66	43.51	43.66	2100.0
2009-01-23 07:00:00	IWM	ETF	43.71	43.71	43.23	43.23	136519.0
2009-01-23 08:00:00	IWM	ETF	43.25	43.4	42.71	42.71	345732.0
2009-01-23 09:00:00	IWM	ETF	42.74	43.65	42.69	43.46	8047361.0
2009-01-23 10:00:00	IWM	ETF	43.46	44.2	43.42	43.76	9085080.0
2009-01-23 11:00:00	IWM	ETF	43.75	44.67	43.6	44.07	8334339.0
2009-01-23 12:00:00	IWM	ETF	44.06	44.49	43.6	44.16	7692934.0
2009-01-23 13:00:00	IWM	ETF	44.16	44.89	44.03	44.88	9989835.0
2009-01-23 14:00:00	IWM	ETF	44.88	45.01	43.55	44.05	11045215.0
2009-01-23 15:00:00	IWM	ETF	44.04	44.47	43.55	44.38	11427631.0
2009-01-23 16:00:00	IWM	ETF	44.39	44.51	43.6	44.209	2496754.0
2009-01-23 04:00:00	DIA	ETF	80.0	80.0	80.0	80.0	100.0
2009-01-23 05:00:00	DIA	ETF	80.0	80.0	80.0	80.0	700.0
2009-01-23 06:00:00	DIA	ETF	79.89	79.98	79.58	79.98	1719.0
2009-01-23 07:00:00	DIA	ETF	79.98	80.08	79.66	79.7	17756.0
2009-01-23 08:00:00	DIA	ETF	79.7	79.83	79.01	79.05	113142.0
2009-01-23 09:00:00	DIA	ETF	79.11	79.88	79.05	79.68	4858247.0
2009-01-23 10:00:00	DIA	ETF	79.69	80.02	79.29	79.5	5359859.0

> showing 50 of 3,885 rows — these rows as CSV

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