PREVIEW / etf_1hour / 2007-01-23

all etf 1-hour files

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

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-23 06:00:00	SPY	ETF	142.18	142.18	142.18	142.18	19900.0
2007-01-23 07:00:00	SPY	ETF	142.17	142.22	142.15	142.16	142400.0
2007-01-23 08:00:00	SPY	ETF	142.22	142.3	142.14	142.21	429300.0
2007-01-23 09:00:00	SPY	ETF	142.22	142.52	142.06	142.41	6602600.0
2007-01-23 10:00:00	SPY	ETF	142.4	142.49	142.22	142.34	8145600.0
2007-01-23 11:00:00	SPY	ETF	142.34	142.78	142.32	142.73	9063700.0
2007-01-23 12:00:00	SPY	ETF	142.74	143.02	142.64	142.96	5696700.0
2007-01-23 13:00:00	SPY	ETF	142.97	143.08	142.9	142.95	4394000.0
2007-01-23 14:00:00	SPY	ETF	142.95	143.0	142.43	142.67	11820700.0
2007-01-23 15:00:00	SPY	ETF	142.67	142.79	142.58	142.75	5478000.0
2007-01-23 16:00:00	SPY	ETF	142.74	142.92	142.6822	142.81	642900.0
2007-01-23 17:00:00	SPY	ETF	142.84	142.97	142.8	142.97	783500.0
2007-01-23 18:00:00	SPY	ETF	142.94	142.95	142.88	142.93	13100.0
2007-01-23 19:00:00	SPY	ETF	142.96	142.96	142.9	142.93	13800.0
2007-01-23 06:00:00	QQQ	ETF	43.6	43.6	43.6	43.6	61400.0
2007-01-23 07:00:00	QQQ	ETF	43.63	43.67	43.6	43.62	117100.0
2007-01-23 08:00:00	QQQ	ETF	43.64	43.66	43.6	43.63	1805310.0
2007-01-23 09:00:00	QQQ	ETF	43.64	43.89	43.6	43.85	21219811.0
2007-01-23 10:00:00	QQQ	ETF	43.85	43.88	43.69	43.76	15005700.0
2007-01-23 11:00:00	QQQ	ETF	43.75	43.92	43.75	43.9	19303500.0
2007-01-23 12:00:00	QQQ	ETF	43.9	43.94	43.82	43.89	14636900.0
2007-01-23 13:00:00	QQQ	ETF	43.9	43.98	43.84	43.86	10368700.0
2007-01-23 14:00:00	QQQ	ETF	43.87	43.88	43.5	43.66	27803800.0
2007-01-23 15:00:00	QQQ	ETF	43.65	43.69	43.57	43.58	14360400.0
2007-01-23 16:00:00	QQQ	ETF	43.57	43.69	43.54	43.63	2763768.0
2007-01-23 17:00:00	QQQ	ETF	43.63	43.76	43.6	43.76	1894880.0
2007-01-23 18:00:00	QQQ	ETF	43.76	43.77	43.71	43.72	95960.0
2007-01-23 19:00:00	QQQ	ETF	43.71	43.75	43.71	43.75	18953.0
2007-01-23 08:00:00	IWM	ETF	77.02	77.06	76.97	77.04	389100.0
2007-01-23 09:00:00	IWM	ETF	77.02	77.48	77.0	77.39	6063700.0
2007-01-23 10:00:00	IWM	ETF	77.4	77.65	77.34	77.58	6863600.0
2007-01-23 11:00:00	IWM	ETF	77.59	78.06	77.59	77.98	7055100.0
2007-01-23 12:00:00	IWM	ETF	77.99	78.24	77.86	78.19	4798100.0
2007-01-23 13:00:00	IWM	ETF	78.19	78.28	78.09	78.12	3665900.0
2007-01-23 14:00:00	IWM	ETF	78.12	78.15	77.73	77.87	8228800.0
2007-01-23 15:00:00	IWM	ETF	77.87	78.02	77.77	77.89	5225100.0
2007-01-23 16:00:00	IWM	ETF	77.88	77.95	77.86	77.89	3201500.0
2007-01-23 17:00:00	IWM	ETF	77.87	77.93	77.1885	77.1885	1751100.0
2007-01-23 18:00:00	IWM	ETF	77.98	77.98	77.98	77.98	500.0
2007-01-23 19:00:00	IWM	ETF	77.95	77.95	77.95	77.95	600.0
2007-01-23 07:00:00	DIA	ETF	124.58	124.58	124.57	124.57	1000.0
2007-01-23 08:00:00	DIA	ETF	124.58	124.71	124.57	124.71	6100.0
2007-01-23 09:00:00	DIA	ETF	124.7	124.92	124.58	124.87	1083500.0
2007-01-23 10:00:00	DIA	ETF	124.88	124.96	124.62	124.78	1299900.0
2007-01-23 11:00:00	DIA	ETF	124.8	125.11	124.78	125.08	965100.0
2007-01-23 12:00:00	DIA	ETF	125.08	125.36	125.04	125.35	635600.0
2007-01-23 13:00:00	DIA	ETF	125.35	125.41	125.29	125.31	706700.0
2007-01-23 14:00:00	DIA	ETF	125.31	125.35	124.98	125.14	904300.0
2007-01-23 15:00:00	DIA	ETF	125.14	125.26	125.08	125.17	929500.0
2007-01-23 16:00:00	DIA	ETF	125.2	125.34	125.2	125.34	32600.0

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

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