PREVIEW / etf_1hour / 2006-02-06

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-02-06.parquet
  size:    39 KB
  rows:    1,224

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-02-06 06:00:00	SPY	ETF	126.6	126.6	126.59	126.59	2600.0
2006-02-06 07:00:00	SPY	ETF	126.6	126.65	126.45	126.51	169200.0
2006-02-06 08:00:00	SPY	ETF	126.5	126.65	126.04	126.56	940900.0
2006-02-06 09:00:00	SPY	ETF	126.54	126.74	126.41	126.53	5417600.0
2006-02-06 10:00:00	SPY	ETF	126.53	126.69	126.35	126.53	9189600.0
2006-02-06 11:00:00	SPY	ETF	126.51	126.7	126.51	126.63	3530300.0
2006-02-06 12:00:00	SPY	ETF	126.62	126.8	126.43	126.54	3872900.0
2006-02-06 13:00:00	SPY	ETF	126.56	126.68	126.38	126.48	2747600.0
2006-02-06 14:00:00	SPY	ETF	126.47	126.56	126.17	126.41	9370800.0
2006-02-06 15:00:00	SPY	ETF	126.4	126.73	126.37	126.56	8280000.0
2006-02-06 16:00:00	SPY	ETF	126.55	126.71	126.4802	126.6	1406700.0
2006-02-06 17:00:00	SPY	ETF	126.61	126.61	126.6	126.6	43500.0
2006-02-06 18:00:00	SPY	ETF	126.62	126.7	126.62	126.7	3600.0
2006-02-06 09:00:00	QQQ	ETF	40.9	41.01	40.85	40.88	7609900.0
2006-02-06 10:00:00	QQQ	ETF	40.88	40.98	40.75	40.83	11667100.0
2006-02-06 11:00:00	QQQ	ETF	40.82	40.92	40.82	40.9	5229900.0
2006-02-06 12:00:00	QQQ	ETF	40.9	40.95	40.79	40.82	4277000.0
2006-02-06 13:00:00	QQQ	ETF	40.82	40.87	40.7	40.75	4624000.0
2006-02-06 14:00:00	QQQ	ETF	40.76	40.76	40.59	40.68	9151000.0
2006-02-06 15:00:00	QQQ	ETF	40.68	40.85	40.68	40.78	12295200.0
2006-02-06 08:00:00	IWM	ETF	71.95	71.95	71.95	71.95	1300.0
2006-02-06 09:00:00	IWM	ETF	71.89	72.1	71.85	71.92	2226200.0
2006-02-06 10:00:00	IWM	ETF	71.91	71.93	71.52	71.74	6182500.0
2006-02-06 11:00:00	IWM	ETF	71.74	72.08	71.74	72.02	4128500.0
2006-02-06 12:00:00	IWM	ETF	72.02	72.17	71.88	72.03	3048000.0
2006-02-06 13:00:00	IWM	ETF	72.03	72.24	71.97	72.04	1980600.0
2006-02-06 14:00:00	IWM	ETF	72.04	72.05	71.74	71.99	2483200.0
2006-02-06 15:00:00	IWM	ETF	71.99	72.36	71.99	72.34	4007100.0
2006-02-06 16:00:00	IWM	ETF	72.34	72.47	72.3	72.47	301400.0
2006-02-06 17:00:00	IWM	ETF	72.48	72.5	72.44	72.5	14000.0
2006-02-06 18:00:00	IWM	ETF	72.59	72.61	72.5	72.5	500.0
2006-02-06 07:00:00	DIA	ETF	107.99	107.99	107.96	107.96	4500.0
2006-02-06 08:00:00	DIA	ETF	107.97	108.02	107.95	108.01	2400.0
2006-02-06 09:00:00	DIA	ETF	108.02	108.08	107.8	107.85	567200.0
2006-02-06 10:00:00	DIA	ETF	107.85	108.04	107.81	107.91	376100.0
2006-02-06 11:00:00	DIA	ETF	107.93	108.05	107.92	107.98	606100.0
2006-02-06 12:00:00	DIA	ETF	107.98	108.13	107.81	107.94	339600.0
2006-02-06 13:00:00	DIA	ETF	107.94	108.02	107.81	107.86	188900.0
2006-02-06 14:00:00	DIA	ETF	107.86	107.96	107.67	107.92	545100.0
2006-02-06 15:00:00	DIA	ETF	107.91	108.11	107.88	107.97	697100.0
2006-02-06 16:00:00	DIA	ETF	107.95	108.09	107.95	108.09	115900.0
2006-02-06 17:00:00	DIA	ETF	108.1	108.1	108.1	108.1	200.0
2006-02-06 07:00:00	GLD	ETF	56.7	56.7	56.7	56.7	3000.0
2006-02-06 08:00:00	GLD	ETF	56.79	56.79	56.63	56.66	20500.0
2006-02-06 09:00:00	GLD	ETF	56.66	56.77	56.65	56.7	600900.0
2006-02-06 10:00:00	GLD	ETF	56.71	57.11	56.693	57.09	541900.0
2006-02-06 11:00:00	GLD	ETF	57.1	57.1499	56.9	56.92	1052800.0
2006-02-06 12:00:00	GLD	ETF	56.9	56.97	56.72	56.78	399500.0
2006-02-06 13:00:00	GLD	ETF	56.78	56.84	56.68	56.75	239400.0
2006-02-06 14:00:00	GLD	ETF	56.78	56.79	56.65	56.72	369900.0

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

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