PREVIEW / etf_1hour / 2009-01-05

all etf 1-hour files

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

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-05 04:00:00	SPY	ETF	92.77	92.83	92.66	92.66	6100.0
2009-01-05 05:00:00	SPY	ETF	92.64	92.64	92.28	92.55	26870.0
2009-01-05 06:00:00	SPY	ETF	92.58	92.88	92.53	92.58	7200.0
2009-01-05 07:00:00	SPY	ETF	92.63	92.8	92.32	92.36	307928.0
2009-01-05 08:00:00	SPY	ETF	92.37	92.46	90.24	92.16	2078560.0
2009-01-05 09:00:00	SPY	ETF	92.16	92.96	91.89	92.04	24759482.0
2009-01-05 10:00:00	SPY	ETF	92.04	93.35	91.98	93.1	34014064.0
2009-01-05 11:00:00	SPY	ETF	93.11	94.5533	92.66	92.67	22943856.0
2009-01-05 12:00:00	SPY	ETF	92.67	93.31	92.65	92.94	20281144.0
2009-01-05 13:00:00	SPY	ETF	92.94	93.57	92.84	93.43	25767711.0
2009-01-05 14:00:00	SPY	ETF	93.42	93.66	92.38	92.57	33417934.0
2009-01-05 15:00:00	SPY	ETF	92.57	92.9	92.09	92.8	46609369.0
2009-01-05 16:00:00	SPY	ETF	92.82	93.15	92.59	92.84	24027551.0
2009-01-05 17:00:00	SPY	ETF	92.81	92.99	92.79	92.9	247439.0
2009-01-05 18:00:00	SPY	ETF	92.91	93.05	92.88	92.95	354489.0
2009-01-05 19:00:00	SPY	ETF	92.96	92.96	92.65	92.66	175281.0
2009-01-05 05:00:00	QQQ	ETF	30.72	30.72	30.7	30.71	500.0
2009-01-05 06:00:00	QQQ	ETF	30.83	30.85	30.79	30.85	14560.0
2009-01-05 07:00:00	QQQ	ETF	30.83	30.86	30.72	30.72	60650.0
2009-01-05 08:00:00	QQQ	ETF	30.72	30.89	30.4	30.68	1254523.0
2009-01-05 09:00:00	QQQ	ETF	30.68	30.93	30.59	30.62	12985916.0
2009-01-05 10:00:00	QQQ	ETF	30.63	31.14	30.59	31.0211	17282621.0
2009-01-05 11:00:00	QQQ	ETF	31.02	31.11	30.89	30.91	8384925.0
2009-01-05 12:00:00	QQQ	ETF	30.91	31.17	30.9	31.02	8255989.0
2009-01-05 13:00:00	QQQ	ETF	31.018	31.26	30.9901	31.23	10771015.0
2009-01-05 14:00:00	QQQ	ETF	31.23	31.33	30.85	30.93	12908579.0
2009-01-05 15:00:00	QQQ	ETF	30.94	31.07	30.81	31.01	16945119.0
2009-01-05 16:00:00	QQQ	ETF	31.02	31.12	30.9555	31.01	2031613.0
2009-01-05 17:00:00	QQQ	ETF	31.01	31.04	31.01	31.03	43525.0
2009-01-05 18:00:00	QQQ	ETF	31.04	31.07	31.03	31.03	29518.0
2009-01-05 19:00:00	QQQ	ETF	31.04	31.04	30.97	31.02	47534.0
2009-01-05 06:00:00	IWM	ETF	50.73	50.89	50.6	50.61	25300.0
2009-01-05 07:00:00	IWM	ETF	50.66	50.66	50.37	50.37	34300.0
2009-01-05 08:00:00	IWM	ETF	50.38	50.44	50.08	50.28	286716.0
2009-01-05 09:00:00	IWM	ETF	50.23	50.55	49.39	49.56	8259738.0
2009-01-05 10:00:00	IWM	ETF	49.56	50.4	49.43	50.12	8168473.0
2009-01-05 11:00:00	IWM	ETF	50.13	50.29	49.96	50.07	4294633.0
2009-01-05 12:00:00	IWM	ETF	50.07	50.57	50.02	50.38	4907357.0
2009-01-05 13:00:00	IWM	ETF	50.38	50.66	50.27	50.61	5993822.0
2009-01-05 14:00:00	IWM	ETF	50.62	50.8	50.0	50.19	8454466.0
2009-01-05 15:00:00	IWM	ETF	50.19	50.45	49.84	50.42	11594061.0
2009-01-05 16:00:00	IWM	ETF	50.4	50.66	50.1908	50.28	4113023.0
2009-01-05 17:00:00	IWM	ETF	50.3	50.4	50.28	50.33	31900.0
2009-01-05 18:00:00	IWM	ETF	50.33	50.33	50.31	50.31	600.0
2009-01-05 19:00:00	IWM	ETF	50.21	50.3	50.16	50.3	2920.0
2009-01-05 06:00:00	DIA	ETF	89.9	90.1	89.83	89.96	9568.0
2009-01-05 07:00:00	DIA	ETF	90.01	90.01	89.73	89.73	12200.0
2009-01-05 08:00:00	DIA	ETF	89.7	89.7	89.4	89.54	46230.0
2009-01-05 09:00:00	DIA	ETF	89.56	89.9	89.11	89.25	3659687.0
2009-01-05 10:00:00	DIA	ETF	89.25	90.22	89.19	89.93	3821095.0

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

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