PREVIEW / etf_1hour / 2009-01-06

all etf 1-hour files

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

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-06 04:00:00	SPY	ETF	93.08	93.55	93.06	93.52	13860.0
2009-01-06 05:00:00	SPY	ETF	93.45	93.66	93.43	93.64	2110.0
2009-01-06 06:00:00	SPY	ETF	93.73	93.75	93.58	93.58	25550.0
2009-01-06 07:00:00	SPY	ETF	93.65	93.85	93.45	93.77	715118.0
2009-01-06 08:00:00	SPY	ETF	93.76	93.85	93.62	93.75	1547814.0
2009-01-06 09:00:00	SPY	ETF	93.74	94.35	93.45	94.21	34687259.0
2009-01-06 10:00:00	SPY	ETF	94.2	94.45	92.85	93.08	54846479.0
2009-01-06 11:00:00	SPY	ETF	93.07	93.31	92.68	93.15	27691320.0
2009-01-06 12:00:00	SPY	ETF	93.16	93.71	92.9	93.6	22111720.0
2009-01-06 13:00:00	SPY	ETF	93.59	93.6	92.89	93.23	31955602.0
2009-01-06 14:00:00	SPY	ETF	93.24	94.18	92.7105	94.15	50150664.0
2009-01-06 15:00:00	SPY	ETF	94.16	94.21	92.88	93.44	71336781.0
2009-01-06 16:00:00	SPY	ETF	93.48	93.6	92.9	93.03	14010972.0
2009-01-06 17:00:00	SPY	ETF	93.04	93.17	92.85	93.08	157291.0
2009-01-06 18:00:00	SPY	ETF	93.08	93.1	92.96	93.02	236682.0
2009-01-06 19:00:00	SPY	ETF	93.03	93.39	93.01	93.39	123501.0
2009-01-06 04:00:00	QQQ	ETF	31.13	31.25	31.13	31.25	10100.0
2009-01-06 05:00:00	QQQ	ETF	31.28	31.35	31.28	31.35	1200.0
2009-01-06 06:00:00	QQQ	ETF	31.36	31.38	31.35	31.35	26826.0
2009-01-06 07:00:00	QQQ	ETF	31.37	31.39	31.28	31.35	282089.0
2009-01-06 08:00:00	QQQ	ETF	31.35	31.48	31.29	31.42	1211067.0
2009-01-06 09:00:00	QQQ	ETF	31.42	31.57	31.2	31.5	17659585.0
2009-01-06 10:00:00	QQQ	ETF	31.5	31.58	31.17	31.24	26480545.0
2009-01-06 11:00:00	QQQ	ETF	31.24	31.32	31.11	31.27	12277317.0
2009-01-06 12:00:00	QQQ	ETF	31.2701	31.55	31.24	31.52	8528932.0
2009-01-06 13:00:00	QQQ	ETF	31.52	31.52	31.25	31.34	15288845.0
2009-01-06 14:00:00	QQQ	ETF	31.33	31.63	31.24	31.6	17754423.0
2009-01-06 15:00:00	QQQ	ETF	31.6	31.61	31.185	31.31	31648175.0
2009-01-06 16:00:00	QQQ	ETF	31.3	31.47	31.15	31.19	4395118.0
2009-01-06 17:00:00	QQQ	ETF	31.18	31.2	31.15	31.18	32436.0
2009-01-06 18:00:00	QQQ	ETF	31.19	31.2	31.17	31.19	13165.0
2009-01-06 19:00:00	QQQ	ETF	31.17	31.27	31.17	31.27	18170.0
2009-01-06 06:00:00	IWM	ETF	50.8	50.8	50.8	50.8	180.0
2009-01-06 07:00:00	IWM	ETF	50.79	50.96	50.77	50.92	13400.0
2009-01-06 08:00:00	IWM	ETF	50.96	51.06	50.91	50.98	72924.0
2009-01-06 09:00:00	IWM	ETF	50.96	51.36	50.8	51.3	7207528.0
2009-01-06 10:00:00	IWM	ETF	51.3	51.45	50.51	50.86	13503413.0
2009-01-06 11:00:00	IWM	ETF	50.86	51.06	50.62	50.91	4817838.0
2009-01-06 12:00:00	IWM	ETF	50.92	51.27	50.3825	51.19	6394474.0
2009-01-06 13:00:00	IWM	ETF	51.199	51.22	50.82	51.05	4773400.0
2009-01-06 14:00:00	IWM	ETF	51.06	51.91	50.89	51.8	11608468.0
2009-01-06 15:00:00	IWM	ETF	51.81	51.85	51.04	51.22	11940778.0
2009-01-06 16:00:00	IWM	ETF	51.27	51.42	50.3825	50.9	8564633.0
2009-01-06 17:00:00	IWM	ETF	51.01	51.01	50.3825	50.95	1855941.0
2009-01-06 18:00:00	IWM	ETF	50.99	51.13	50.98	51.13	2500.0
2009-01-06 19:00:00	IWM	ETF	50.91	50.91	50.36	50.36	470.0
2009-01-06 06:00:00	DIA	ETF	90.27	90.27	90.18	90.27	300.0
2009-01-06 07:00:00	DIA	ETF	90.19	90.35	90.11	90.35	13143.0
2009-01-06 08:00:00	DIA	ETF	90.34	90.43	90.19	90.27	52792.0
2009-01-06 09:00:00	DIA	ETF	90.26	90.7	89.99	90.62	3362061.0

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

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