PREVIEW / etf_1hour / 2006-03-08

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-03-08.parquet
  size:    41 KB
  rows:    1,243

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
2006-03-08 05:00:00	SPY	ETF	128.02	128.02	127.97	127.97	2300.0
2006-03-08 06:00:00	SPY	ETF	127.63	127.68	127.62	127.68	27600.0
2006-03-08 07:00:00	SPY	ETF	127.68	127.72	127.65	127.68	50000.0
2006-03-08 08:00:00	SPY	ETF	127.68	128.16	127.54	127.65	1289000.0
2006-03-08 09:00:00	SPY	ETF	127.64	128.0	127.49	127.99	5795500.0
2006-03-08 10:00:00	SPY	ETF	127.99	128.06	127.68	127.81	9419500.0
2006-03-08 11:00:00	SPY	ETF	127.82	127.82	127.18	127.32	9270000.0
2006-03-08 12:00:00	SPY	ETF	127.32	127.96	127.31	127.84	9068100.0
2006-03-08 13:00:00	SPY	ETF	127.84	127.97	127.58	127.69	5817800.0
2006-03-08 14:00:00	SPY	ETF	127.68	128.44	127.63	128.3	13461800.0
2006-03-08 15:00:00	SPY	ETF	128.29	128.44	128.17	128.17	7526100.0
2006-03-08 16:00:00	SPY	ETF	128.17	128.3	127.65	128.23	2443500.0
2006-03-08 17:00:00	SPY	ETF	128.23	128.24	128.2	128.24	77100.0
2006-03-08 18:00:00	SPY	ETF	128.24	128.24	128.22	128.22	12600.0
2006-03-08 19:00:00	SPY	ETF	128.25	128.26	128.25	128.25	21700.0
2006-03-08 09:00:00	QQQ	ETF	40.77	40.94	40.69	40.92	9986700.0
2006-03-08 10:00:00	QQQ	ETF	40.92	40.97	40.66	40.74	22438600.0
2006-03-08 11:00:00	QQQ	ETF	40.74	40.77	40.5	40.57	16313500.0
2006-03-08 12:00:00	QQQ	ETF	40.58	40.86	40.57	40.79	11228500.0
2006-03-08 13:00:00	QQQ	ETF	40.79	40.85	40.69	40.73	7101000.0
2006-03-08 14:00:00	QQQ	ETF	40.73	42.02	40.71	41.0	16440600.0
2006-03-08 15:00:00	QQQ	ETF	41.0	41.03	40.85	40.85	11114600.0
2006-03-08 08:00:00	IWM	ETF	71.48	71.48	71.25	71.28	334600.0
2006-03-08 09:00:00	IWM	ETF	71.33	71.51	71.14	71.49	7147700.0
2006-03-08 10:00:00	IWM	ETF	71.49	71.6	71.15	71.35	11582300.0
2006-03-08 11:00:00	IWM	ETF	71.35	71.51	70.88	71.03	6912900.0
2006-03-08 12:00:00	IWM	ETF	71.02	71.63	71.01	71.48	5676500.0
2006-03-08 13:00:00	IWM	ETF	71.48	71.58	71.27	71.39	4578200.0
2006-03-08 14:00:00	IWM	ETF	71.39	72.0	71.36	71.89	9001200.0
2006-03-08 15:00:00	IWM	ETF	71.89	71.95	71.73	71.74	4941000.0
2006-03-08 16:00:00	IWM	ETF	71.74	71.89	71.73	71.79	571600.0
2006-03-08 17:00:00	IWM	ETF	71.82	71.84	71.82	71.84	15800.0
2006-03-08 18:00:00	IWM	ETF	71.82	71.84	71.8	71.84	4800.0
2006-03-08 19:00:00	IWM	ETF	71.85	71.85	71.85	71.85	1000.0
2006-03-08 08:00:00	DIA	ETF	109.66	109.72	109.57	109.6	16600.0
2006-03-08 09:00:00	DIA	ETF	109.64	109.94	109.54	109.93	1311000.0
2006-03-08 10:00:00	DIA	ETF	109.94	109.97	109.69	109.78	621900.0
2006-03-08 11:00:00	DIA	ETF	109.78	109.8	109.27	109.32	1152600.0
2006-03-08 12:00:00	DIA	ETF	109.33	109.88	109.33	109.812	1288400.0
2006-03-08 13:00:00	DIA	ETF	109.82	109.9	109.65	109.7	359600.0
2006-03-08 14:00:00	DIA	ETF	109.69	110.33	109.61	110.19	1046400.0
2006-03-08 15:00:00	DIA	ETF	110.18	110.3	110.08	110.11	535300.0
2006-03-08 16:00:00	DIA	ETF	110.1	110.17	110.07	110.09	7700.0
2006-03-08 17:00:00	DIA	ETF	110.14	110.14	110.14	110.14	300.0
2006-03-08 18:00:00	DIA	ETF	110.14	110.14	110.07	110.09	1800.0
2006-03-08 19:00:00	DIA	ETF	110.11	110.11	110.11	110.11	500.0
2006-03-08 07:00:00	GLD	ETF	54.76	54.76	54.25	54.25	57700.0
2006-03-08 08:00:00	GLD	ETF	54.36	54.76	53.96	54.12	105800.0
2006-03-08 09:00:00	GLD	ETF	54.12	54.27	53.95	54.21	1534800.0
2006-03-08 10:00:00	GLD	ETF	54.21	54.27	54.02	54.07	870000.0

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

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