PREVIEW / etf_1hour / 2007-12-20

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-12-20.parquet
  size:    95 KB
  rows:    3,163

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
2007-12-20 04:00:00	SPY	ETF	146.17	146.2	146.14	146.14	7000.0
2007-12-20 05:00:00	SPY	ETF	146.21	146.21	146.21	146.21	100.0
2007-12-20 06:00:00	SPY	ETF	146.15	146.25	145.98	146.25	87600.0
2007-12-20 07:00:00	SPY	ETF	146.21	146.28	145.8	146.05	317200.0
2007-12-20 08:00:00	SPY	ETF	146.0	146.65	146.0	146.54	6814600.0
2007-12-20 09:00:00	SPY	ETF	146.54	146.88	146.01	146.02	18101914.0
2007-12-20 10:00:00	SPY	ETF	146.02	146.78	145.5	145.71	35968560.0
2007-12-20 11:00:00	SPY	ETF	145.71	146.15	145.31	145.5	21595698.0
2007-12-20 12:00:00	SPY	ETF	145.51	145.67	145.18	145.41	15376282.0
2007-12-20 13:00:00	SPY	ETF	145.42	146.84	145.41	145.98	17364957.0
2007-12-20 14:00:00	SPY	ETF	145.98	146.58	145.77	146.33	30872109.0
2007-12-20 15:00:00	SPY	ETF	146.33	146.59	145.93	146.53	37627535.0
2007-12-20 16:00:00	SPY	ETF	146.5101	146.9	146.048	146.79	25073500.0
2007-12-20 17:00:00	SPY	ETF	146.77	146.79	146.58	146.76	81700.0
2007-12-20 18:00:00	SPY	ETF	146.77	146.91	146.72	146.89	109800.0
2007-12-20 19:00:00	SPY	ETF	146.89	146.89	146.73	146.83	29900.0
2007-12-20 07:00:00	QQQ	ETF	50.29	50.31	50.17	50.28	743377.0
2007-12-20 08:00:00	QQQ	ETF	50.26	50.48	50.24	50.46	3524521.0
2007-12-20 09:00:00	QQQ	ETF	50.46	50.67	50.36	50.3614	13716128.0
2007-12-20 10:00:00	QQQ	ETF	50.3601	50.55	50.22	50.36	18478225.0
2007-12-20 11:00:00	QQQ	ETF	50.36	50.39	50.23	50.31	14387737.0
2007-12-20 12:00:00	QQQ	ETF	50.31	50.43	50.2	50.3	16697050.0
2007-12-20 13:00:00	QQQ	ETF	50.29	50.59	50.28	50.58	17238199.0
2007-12-20 14:00:00	QQQ	ETF	50.58	50.93	50.51	50.83	33776489.0
2007-12-20 15:00:00	QQQ	ETF	50.8201	50.96	50.68	50.92	41036502.0
2007-12-20 16:00:00	QQQ	ETF	50.93	51.2	50.86	51.12	8751915.0
2007-12-20 17:00:00	QQQ	ETF	51.15	51.2	51.12	51.19	861462.0
2007-12-20 18:00:00	QQQ	ETF	51.18	51.21	51.15	51.16	447049.0
2007-12-20 19:00:00	QQQ	ETF	51.17	51.17	51.11	51.17	183629.0
2007-12-20 06:00:00	IWM	ETF	75.93	75.95	75.93	75.95	10000.0
2007-12-20 07:00:00	IWM	ETF	75.93	75.96	75.78	75.78	107500.0
2007-12-20 08:00:00	IWM	ETF	75.89	76.11	75.79	76.03	1918900.0
2007-12-20 09:00:00	IWM	ETF	76.04	76.29	75.76	75.78	7713313.0
2007-12-20 10:00:00	IWM	ETF	75.77	75.85	75.34	75.57	14370868.0
2007-12-20 11:00:00	IWM	ETF	75.58	75.58	74.93	74.97	15243592.0
2007-12-20 12:00:00	IWM	ETF	74.97	75.95	74.82	74.99	19971230.0
2007-12-20 13:00:00	IWM	ETF	74.99	75.5	74.98	75.49	17851479.0
2007-12-20 14:00:00	IWM	ETF	75.49	76.2	75.33	75.92	12265611.0
2007-12-20 15:00:00	IWM	ETF	75.92	76.63	75.0	76.63	20856763.0
2007-12-20 16:00:00	IWM	ETF	76.63	76.99	75.35	76.88	10776905.0
2007-12-20 17:00:00	IWM	ETF	75.44	76.9	75.44	76.89	2682400.0
2007-12-20 18:00:00	IWM	ETF	76.89	76.93	76.84	76.84	8700.0
2007-12-20 19:00:00	IWM	ETF	76.95	76.95	76.95	76.95	100.0
2007-12-20 07:00:00	DIA	ETF	132.45	132.46	132.14	132.35	6300.0
2007-12-20 08:00:00	DIA	ETF	132.39	132.73	132.35	132.7	20400.0
2007-12-20 09:00:00	DIA	ETF	132.73	132.91	132.38	132.38	1382197.0
2007-12-20 10:00:00	DIA	ETF	132.39	132.47	131.99	132.12	2023978.0
2007-12-20 11:00:00	DIA	ETF	132.11	132.2	131.79	131.99	1550082.0
2007-12-20 12:00:00	DIA	ETF	131.97	132.05	131.66	131.86	987200.0
2007-12-20 13:00:00	DIA	ETF	131.86	132.34	131.85	132.31	788300.0

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

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