PREVIEW / etf_1hour / 2007-02-05

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-02-05.parquet
  size:    62 KB
  rows:    2,008

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-02-05 04:00:00	SPY	ETF	144.65	144.67	144.65	144.67	29900.0
2007-02-05 06:00:00	SPY	ETF	144.63	144.65	144.62	144.62	16000.0
2007-02-05 07:00:00	SPY	ETF	144.6	144.61	144.54	144.54	55500.0
2007-02-05 08:00:00	SPY	ETF	144.55	144.68	144.51	144.68	292700.0
2007-02-05 09:00:00	SPY	ETF	144.67	144.8	144.47	144.54	7315500.0
2007-02-05 10:00:00	SPY	ETF	144.53	144.79	144.34	144.68	10259100.0
2007-02-05 11:00:00	SPY	ETF	144.68	144.74	144.57	144.66	5319200.0
2007-02-05 12:00:00	SPY	ETF	144.66	144.73	144.59	144.72	1970700.0
2007-02-05 13:00:00	SPY	ETF	144.73	144.82	144.63	144.72	4611300.0
2007-02-05 14:00:00	SPY	ETF	144.71	144.94	144.71	144.8899	4218300.0
2007-02-05 15:00:00	SPY	ETF	144.88	144.88	144.63	144.69	4912100.0
2007-02-05 16:00:00	SPY	ETF	144.68	144.9	144.68	144.84	2380400.0
2007-02-05 17:00:00	SPY	ETF	144.85	144.89	144.85	144.88	3118500.0
2007-02-05 18:00:00	SPY	ETF	144.88	144.88	144.84	144.84	41900.0
2007-02-05 19:00:00	SPY	ETF	144.82	144.82	144.82	144.82	1000.0
2007-02-05 04:00:00	QQQ	ETF	44.14	44.14	44.14	44.14	1200.0
2007-02-05 07:00:00	QQQ	ETF	44.12	44.15	44.07	44.08	34100.0
2007-02-05 08:00:00	QQQ	ETF	44.09	44.16	44.08	44.16	279546.0
2007-02-05 09:00:00	QQQ	ETF	44.17	44.36	44.1	44.15	14260351.0
2007-02-05 10:00:00	QQQ	ETF	44.15	44.24	43.96	44.13	24418000.0
2007-02-05 11:00:00	QQQ	ETF	44.13	44.19	44.06	44.16	12197900.0
2007-02-05 12:00:00	QQQ	ETF	44.17	44.21	44.14	44.21	4490500.0
2007-02-05 13:00:00	QQQ	ETF	44.21	44.24	44.12	44.17	10228500.0
2007-02-05 14:00:00	QQQ	ETF	44.17	44.27	44.15	44.24	7858200.0
2007-02-05 15:00:00	QQQ	ETF	44.24	44.25	44.12	44.13	14496500.0
2007-02-05 16:00:00	QQQ	ETF	44.12	44.18	44.1	44.13	2809836.0
2007-02-05 17:00:00	QQQ	ETF	44.13	44.15	44.13	44.13	80438.0
2007-02-05 18:00:00	QQQ	ETF	44.13	44.13	44.1	44.1	34452.0
2007-02-05 19:00:00	QQQ	ETF	44.14	44.14	44.14	44.14	2500.0
2007-02-05 08:00:00	IWM	ETF	80.17	80.2	80.15	80.18	49500.0
2007-02-05 09:00:00	IWM	ETF	80.23	80.47	80.05	80.1	4774600.0
2007-02-05 10:00:00	IWM	ETF	80.1	80.25	79.87	80.13	7862400.0
2007-02-05 11:00:00	IWM	ETF	80.13	80.22	79.97	80.0299	3547600.0
2007-02-05 12:00:00	IWM	ETF	80.03	80.15	79.94	80.15	2000700.0
2007-02-05 13:00:00	IWM	ETF	80.15	80.16	79.94	80.0	4533300.0
2007-02-05 14:00:00	IWM	ETF	80.0	80.29	79.99	80.2	2629100.0
2007-02-05 15:00:00	IWM	ETF	80.2	80.2	79.89	79.98	3480100.0
2007-02-05 16:00:00	IWM	ETF	79.96	80.38	79.96	80.24	397500.0
2007-02-05 17:00:00	IWM	ETF	80.22	80.23	80.22	80.23	800.0
2007-02-05 18:00:00	IWM	ETF	80.28	80.29	80.26	80.26	17700.0
2007-02-05 08:00:00	DIA	ETF	126.42	126.42	126.42	126.42	1400.0
2007-02-05 09:00:00	DIA	ETF	126.45	126.54	126.3	126.38	405500.0
2007-02-05 10:00:00	DIA	ETF	126.39	126.66	126.25	126.53	1290300.0
2007-02-05 11:00:00	DIA	ETF	126.54	126.59	126.43	126.51	604200.0
2007-02-05 12:00:00	DIA	ETF	126.51	126.6	126.47	126.6	166500.0
2007-02-05 13:00:00	DIA	ETF	126.6	126.71	126.55	126.61	523400.0
2007-02-05 14:00:00	DIA	ETF	126.6	126.74	126.6	126.69	497800.0
2007-02-05 15:00:00	DIA	ETF	126.69	126.69	126.48	126.54	990200.0
2007-02-05 16:00:00	DIA	ETF	126.53	126.69	126.51	126.63	57900.0
2007-02-05 17:00:00	DIA	ETF	126.56	126.57	126.56	126.56	500.0

> showing 50 of 2,008 rows — these rows as CSV

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