PREVIEW / etf_1hour / 2007-12-11

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-12-11.parquet
  size:    98 KB
  rows:    3,252

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-11 04:00:00	SPY	ETF	152.46	152.46	152.32	152.32	800.0
2007-12-11 05:00:00	SPY	ETF	152.31	152.31	152.12	152.12	1000.0
2007-12-11 06:00:00	SPY	ETF	151.98	152.37	151.98	152.37	31500.0
2007-12-11 07:00:00	SPY	ETF	152.29	152.52	152.08	152.31	158800.0
2007-12-11 08:00:00	SPY	ETF	152.29	152.43	152.15	152.2	469300.0
2007-12-11 09:00:00	SPY	ETF	152.2	152.3	151.97	152.09	8809410.0
2007-12-11 10:00:00	SPY	ETF	152.1	152.19	151.68	151.705	11929146.0
2007-12-11 11:00:00	SPY	ETF	151.7	151.89	151.6	151.82	10492446.0
2007-12-11 12:00:00	SPY	ETF	151.82	152.2	151.74	152.18	6804400.0
2007-12-11 13:00:00	SPY	ETF	152.18	152.58	152.07	152.5526	19892947.0
2007-12-11 14:00:00	SPY	ETF	152.56	152.89	149.11	149.65	98228974.0
2007-12-11 15:00:00	SPY	ETF	149.65	149.65	147.96	148.23	68688402.0
2007-12-11 16:00:00	SPY	ETF	148.11	151.9836	147.78	147.85	17344900.0
2007-12-11 17:00:00	SPY	ETF	147.83	151.98	147.78	147.96	1737300.0
2007-12-11 18:00:00	SPY	ETF	147.96	148.36	147.96	148.3	258600.0
2007-12-11 19:00:00	SPY	ETF	148.27	148.48	148.27	148.47	71500.0
2007-12-11 05:00:00	QQQ	ETF	52.57	52.57	52.57	52.57	400.0
2007-12-11 06:00:00	QQQ	ETF	52.61	52.65	52.57	52.65	12000.0
2007-12-11 07:00:00	QQQ	ETF	52.65	52.76	52.59	52.72	156954.0
2007-12-11 08:00:00	QQQ	ETF	52.7	52.72	52.64	52.67	733771.0
2007-12-11 09:00:00	QQQ	ETF	52.66	52.69	52.56	52.63	8483922.0
2007-12-11 10:00:00	QQQ	ETF	52.64	52.7	52.58	52.58	7002019.0
2007-12-11 11:00:00	QQQ	ETF	52.59	52.65	52.54	52.635	6525824.0
2007-12-11 12:00:00	QQQ	ETF	52.63	52.74	52.6	52.73	6554926.0
2007-12-11 13:00:00	QQQ	ETF	52.7319	52.84	52.7	52.84	8560789.0
2007-12-11 14:00:00	QQQ	ETF	52.84	52.84	51.52	51.82	80583659.0
2007-12-11 15:00:00	QQQ	ETF	51.82	51.82	51.21	51.31	45539992.0
2007-12-11 16:00:00	QQQ	ETF	51.32	51.41	51.23	51.23	4514408.0
2007-12-11 17:00:00	QQQ	ETF	51.25	51.29	51.24	51.29	68550.0
2007-12-11 18:00:00	QQQ	ETF	51.29	51.47	51.29	51.47	173233.0
2007-12-11 19:00:00	QQQ	ETF	51.43	51.52	51.42	51.52	54217.0
2007-12-11 07:00:00	IWM	ETF	79.3	79.33	79.3	79.32	34100.0
2007-12-11 08:00:00	IWM	ETF	79.22	79.29	79.2	79.26	251900.0
2007-12-11 09:00:00	IWM	ETF	79.26	79.33	79.04	79.15	5735600.0
2007-12-11 10:00:00	IWM	ETF	79.16	79.3	78.94	78.96	12662600.0
2007-12-11 11:00:00	IWM	ETF	78.95	79.0	78.77	78.89	7163700.0
2007-12-11 12:00:00	IWM	ETF	78.89	79.04	78.85	79.02	3514600.0
2007-12-11 13:00:00	IWM	ETF	79.02	79.36	78.97	79.28	8370600.0
2007-12-11 14:00:00	IWM	ETF	79.29	79.58	77.14	77.44	38419208.0
2007-12-11 15:00:00	IWM	ETF	77.44	77.44	76.25	76.27	31985200.0
2007-12-11 16:00:00	IWM	ETF	76.27	78.89	76.18	78.89	3653600.0
2007-12-11 17:00:00	IWM	ETF	78.89	78.89	76.14	76.25	9013200.0
2007-12-11 18:00:00	IWM	ETF	76.27	76.3	76.21	76.3	3600.0
2007-12-11 19:00:00	IWM	ETF	76.56	76.56	76.54	76.54	5300.0
2007-12-11 07:00:00	DIA	ETF	137.67	137.69	137.67	137.69	400.0
2007-12-11 08:00:00	DIA	ETF	137.7	137.76	137.55	137.6	8600.0
2007-12-11 09:00:00	DIA	ETF	137.6	137.66	137.39	137.43	2602804.0
2007-12-11 10:00:00	DIA	ETF	137.43	137.5	137.02	137.03	1150900.0
2007-12-11 11:00:00	DIA	ETF	137.03	137.26	136.95	137.23	809900.0
2007-12-11 12:00:00	DIA	ETF	137.22	137.52	137.17	137.51	1180600.0

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

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