PREVIEW / etf_1hour / 2009-04-08

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-04-08.parquet
  size:    130 KB
  rows:    4,007

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-04-08 04:00:00	SPY	ETF	80.95	81.15	80.92	81.15	5754.0
2009-04-08 05:00:00	SPY	ETF	81.17	81.32	80.88	80.88	16170.0
2009-04-08 06:00:00	SPY	ETF	80.84	81.49	80.8	81.4	77047.0
2009-04-08 07:00:00	SPY	ETF	81.35	81.61	81.28	81.31	872680.0
2009-04-08 08:00:00	SPY	ETF	81.3	82.26	81.26	82.13	4208423.0
2009-04-08 09:00:00	SPY	ETF	82.13	82.6	82.02	82.24	23319872.0
2009-04-08 10:00:00	SPY	ETF	82.24	82.34	81.54	81.93	39858364.0
2009-04-08 11:00:00	SPY	ETF	81.93	82.54	81.92	82.29	36271061.0
2009-04-08 12:00:00	SPY	ETF	82.3	82.94	82.13	82.8001	25009595.0
2009-04-08 13:00:00	SPY	ETF	82.81	82.83	82.51	82.5975	17916526.0
2009-04-08 14:00:00	SPY	ETF	82.6	82.63	81.84	82.01	34979890.0
2009-04-08 15:00:00	SPY	ETF	82.0	82.61	81.6	82.54	40490953.0
2009-04-08 16:00:00	SPY	ETF	82.52	82.87	82.2143	82.84	5583851.0
2009-04-08 17:00:00	SPY	ETF	82.85	83.0	82.81	82.93	662326.0
2009-04-08 18:00:00	SPY	ETF	82.91	82.93	82.76	82.78	94202.0
2009-04-08 19:00:00	SPY	ETF	82.81	82.89	82.72	82.79	137997.0
2009-04-08 04:00:00	QQQ	ETF	31.31	31.34	31.31	31.34	1750.0
2009-04-08 05:00:00	QQQ	ETF	31.39	31.42	31.35	31.35	11095.0
2009-04-08 06:00:00	QQQ	ETF	31.27	31.51	31.27	31.48	75446.0
2009-04-08 07:00:00	QQQ	ETF	31.49	31.56	31.49	31.51	524261.0
2009-04-08 08:00:00	QQQ	ETF	31.52	31.85	31.51	31.77	1724547.0
2009-04-08 09:00:00	QQQ	ETF	31.78	31.965	31.68	31.89	15668874.0
2009-04-08 10:00:00	QQQ	ETF	31.9	31.91	31.49	31.61	29447128.0
2009-04-08 11:00:00	QQQ	ETF	31.6	31.93	31.6	31.84	14385080.0
2009-04-08 12:00:00	QQQ	ETF	31.8408	32.15	31.82	32.08	12317177.0
2009-04-08 13:00:00	QQQ	ETF	32.08	32.09	31.92	31.98	7870228.0
2009-04-08 14:00:00	QQQ	ETF	31.99	31.99	31.73	31.78	12373706.0
2009-04-08 15:00:00	QQQ	ETF	31.789	31.98	31.64	31.96	21402333.0
2009-04-08 16:00:00	QQQ	ETF	31.96	32.04	31.9299	32.01	2406706.0
2009-04-08 17:00:00	QQQ	ETF	32.02	32.05	32.0	32.03	128101.0
2009-04-08 18:00:00	QQQ	ETF	32.04	32.05	32.0	32.01	33279.0
2009-04-08 19:00:00	QQQ	ETF	32.02	32.04	32.0	32.03	44650.0
2009-04-08 04:00:00	IWM	ETF	42.99	42.99	42.99	42.99	200.0
2009-04-08 06:00:00	IWM	ETF	43.12	43.12	43.12	43.12	2000.0
2009-04-08 07:00:00	IWM	ETF	43.14	43.14	43.04	43.04	16000.0
2009-04-08 08:00:00	IWM	ETF	42.7	43.67	42.7	43.63	128189.0
2009-04-08 09:00:00	IWM	ETF	43.63	44.07	43.44	43.9	5831999.0
2009-04-08 10:00:00	IWM	ETF	43.9	43.93	43.19	43.51	9951333.0
2009-04-08 11:00:00	IWM	ETF	43.52	43.9	43.515	43.73	6643965.0
2009-04-08 12:00:00	IWM	ETF	43.74	44.2	43.62	44.07	5833104.0
2009-04-08 13:00:00	IWM	ETF	44.07	44.12	43.82	43.91	3877992.0
2009-04-08 14:00:00	IWM	ETF	43.92	43.97	43.48	43.61	5930167.0
2009-04-08 15:00:00	IWM	ETF	43.6	44.23	43.35	44.19	10230068.0
2009-04-08 16:00:00	IWM	ETF	44.19	44.22	43.1569	44.15	4240844.0
2009-04-08 17:00:00	IWM	ETF	44.14	44.15	44.08	44.1	20051.0
2009-04-08 18:00:00	IWM	ETF	44.11	44.11	44.1	44.1	500.0
2009-04-08 19:00:00	IWM	ETF	44.09	44.09	44.09	44.09	900.0
2009-04-08 06:00:00	DIA	ETF	77.33	77.51	77.31	77.51	300.0
2009-04-08 07:00:00	DIA	ETF	77.71	77.85	77.6	77.6	18475.0
2009-04-08 08:00:00	DIA	ETF	77.6	78.39	77.59	78.26	85860.0

> showing 50 of 4,007 rows — these rows as CSV

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