PREVIEW / etf_1hour / 2007-01-24

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-01-24.parquet
  size:    62 KB
  rows:    1,984

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-01-24 06:00:00	SPY	ETF	143.02	143.05	143.02	143.05	6500.0
2007-01-24 07:00:00	SPY	ETF	143.06	143.09	143.0	143.0	25400.0
2007-01-24 08:00:00	SPY	ETF	143.0	143.11	142.94	143.02	673900.0
2007-01-24 09:00:00	SPY	ETF	143.01	143.2	142.91	143.08	5726300.0
2007-01-24 10:00:00	SPY	ETF	143.07	143.36	142.93	143.31	9486200.0
2007-01-24 11:00:00	SPY	ETF	143.3	143.52	143.28	143.33	8895600.0
2007-01-24 12:00:00	SPY	ETF	143.33	143.47	143.28	143.37	3011900.0
2007-01-24 13:00:00	SPY	ETF	143.37	143.71	143.27	143.62	5750800.0
2007-01-24 14:00:00	SPY	ETF	143.62	143.85	143.5	143.72	9918800.0
2007-01-24 15:00:00	SPY	ETF	143.73	143.98	143.69	143.92	9416700.0
2007-01-24 16:00:00	SPY	ETF	143.93	144.26	143.85	144.02	1041300.0
2007-01-24 17:00:00	SPY	ETF	144.02	144.07	144.0	144.07	69900.0
2007-01-24 18:00:00	SPY	ETF	144.0	144.01	142.8	143.97	632700.0
2007-01-24 19:00:00	SPY	ETF	143.99	143.99	143.99	143.99	400.0
2007-01-24 04:00:00	QQQ	ETF	43.78	43.78	43.78	43.78	200.0
2007-01-24 05:00:00	QQQ	ETF	43.8	43.83	43.8	43.83	1200.0
2007-01-24 06:00:00	QQQ	ETF	43.82	43.84	43.82	43.84	25500.0
2007-01-24 07:00:00	QQQ	ETF	43.83	43.86	43.79	43.79	364207.0
2007-01-24 08:00:00	QQQ	ETF	43.79	43.88	43.78	43.83	1547123.0
2007-01-24 09:00:00	QQQ	ETF	43.84	44.01	43.77	43.87	20502245.0
2007-01-24 10:00:00	QQQ	ETF	43.87	44.18	43.82	44.17	23680500.0
2007-01-24 11:00:00	QQQ	ETF	44.17	44.28	44.14	44.21	18791900.0
2007-01-24 12:00:00	QQQ	ETF	44.22	44.32	44.19	44.21	9493100.0
2007-01-24 13:00:00	QQQ	ETF	44.21	44.3	44.14	44.28	7075700.0
2007-01-24 14:00:00	QQQ	ETF	44.27	44.31	44.2	44.24	6851600.0
2007-01-24 15:00:00	QQQ	ETF	44.23	44.3	44.22	44.29	12166600.0
2007-01-24 16:00:00	QQQ	ETF	44.3	44.47	44.24	44.46	5549454.0
2007-01-24 17:00:00	QQQ	ETF	44.46	44.49	44.45	44.48	43326.0
2007-01-24 18:00:00	QQQ	ETF	44.48	44.49	44.45	44.47	40377.0
2007-01-24 19:00:00	QQQ	ETF	44.45	44.47	44.45	44.47	30302.0
2007-01-24 08:00:00	IWM	ETF	78.03	78.18	78.03	78.07	133000.0
2007-01-24 09:00:00	IWM	ETF	78.1	78.37	77.94	78.18	3925400.0
2007-01-24 10:00:00	IWM	ETF	78.18	78.48	78.03	78.43	3184900.0
2007-01-24 11:00:00	IWM	ETF	78.44	78.51	78.32	78.36	3323300.0
2007-01-24 12:00:00	IWM	ETF	78.3617	78.49	78.3	78.42	2138800.0
2007-01-24 13:00:00	IWM	ETF	78.43	78.74	78.37	78.7	3747500.0
2007-01-24 14:00:00	IWM	ETF	78.69	78.82	78.58	78.69	5312900.0
2007-01-24 15:00:00	IWM	ETF	78.68	78.8	78.65	78.77	5291100.0
2007-01-24 16:00:00	IWM	ETF	78.77	78.98	78.48	78.91	1644500.0
2007-01-24 17:00:00	IWM	ETF	78.77	78.95	78.77	78.9	503500.0
2007-01-24 18:00:00	IWM	ETF	78.92	78.92	78.89	78.89	2000.0
2007-01-24 19:00:00	IWM	ETF	78.91	78.91	78.9	78.9	4500.0
2007-01-24 08:00:00	DIA	ETF	125.47	125.63	125.46	125.55	10400.0
2007-01-24 09:00:00	DIA	ETF	125.54	125.64	125.4	125.55	795200.0
2007-01-24 10:00:00	DIA	ETF	125.55	125.67	125.38	125.65	1464200.0
2007-01-24 11:00:00	DIA	ETF	125.65	125.89	125.61	125.67	1146000.0
2007-01-24 12:00:00	DIA	ETF	125.67	125.77	125.64	125.69	660600.0
2007-01-24 13:00:00	DIA	ETF	125.68	125.86	125.59	125.81	1205600.0
2007-01-24 14:00:00	DIA	ETF	125.81	125.96	125.74	125.9	1827700.0
2007-01-24 15:00:00	DIA	ETF	125.9	126.12	125.9	126.11	1488700.0

> showing 50 of 1,984 rows — these rows as CSV

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