PREVIEW / etf_1hour / 2006-01-03

all etf 1-hour files

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

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-01-03 04:00:00	SPY	ETF	125.3	125.3	125.3	125.3	100.0
2006-01-03 05:00:00	SPY	ETF	125.44	125.49	125.44	125.46	2100.0
2006-01-03 06:00:00	SPY	ETF	125.36	125.4	125.35	125.4	4200.0
2006-01-03 07:00:00	SPY	ETF	125.34	125.39	125.27	125.35	116900.0
2006-01-03 08:00:00	SPY	ETF	125.33	125.38	124.51	125.27	1288100.0
2006-01-03 09:00:00	SPY	ETF	125.26	125.33	124.98	125.13	7573300.0
2006-01-03 10:00:00	SPY	ETF	125.13	125.28	124.39	124.67	11924700.0
2006-01-03 11:00:00	SPY	ETF	124.68	125.0	124.6	124.99	4452200.0
2006-01-03 12:00:00	SPY	ETF	124.95	125.07	124.77	124.97	3747300.0
2006-01-03 13:00:00	SPY	ETF	124.98	125.12	124.81	124.96	3354100.0
2006-01-03 14:00:00	SPY	ETF	124.96	126.19	124.96	126.16	17116000.0
2006-01-03 15:00:00	SPY	ETF	126.16	127.0	126.132	126.75	15972900.0
2006-01-03 16:00:00	SPY	ETF	126.79	126.86	125.6	126.69	2435900.0
2006-01-03 17:00:00	SPY	ETF	126.74	126.8	126.7	126.79	110200.0
2006-01-03 18:00:00	SPY	ETF	126.8	126.8	126.69	126.69	137000.0
2006-01-03 19:00:00	SPY	ETF	126.7	126.71	126.67	126.67	4900.0
2006-01-03 09:00:00	QQQ	ETF	40.65	40.68	40.5	40.59	10533500.0
2006-01-03 10:00:00	QQQ	ETF	40.58	40.63	40.1	40.34	17595500.0
2006-01-03 11:00:00	QQQ	ETF	40.35	40.55	40.32	40.54	10602000.0
2006-01-03 12:00:00	QQQ	ETF	40.55	40.62	40.5	40.55	6638900.0
2006-01-03 13:00:00	QQQ	ETF	40.56	40.6	40.46	40.54	3600900.0
2006-01-03 14:00:00	QQQ	ETF	40.53	41.16	40.46	41.12	27384700.0
2006-01-03 15:00:00	QQQ	ETF	41.11	41.49	41.11	41.31	25336700.0
2006-01-03 04:00:00	IWM	ETF	66.89	66.89	66.89	66.89	100.0
2006-01-03 05:00:00	IWM	ETF	66.89	66.89	66.89	66.89	100.0
2006-01-03 06:00:00	IWM	ETF	66.89	66.89	66.89	66.89	200.0
2006-01-03 07:00:00	IWM	ETF	66.89	67.89	66.89	67.43	112900.0
2006-01-03 08:00:00	IWM	ETF	66.69	67.89	66.69	67.27	725300.0
2006-01-03 09:00:00	IWM	ETF	67.27	67.4	66.69	67.14	3513300.0
2006-01-03 10:00:00	IWM	ETF	67.14	67.25	66.05	66.36	7322500.0
2006-01-03 11:00:00	IWM	ETF	66.37	66.71	66.33	66.7	4289200.0
2006-01-03 12:00:00	IWM	ETF	66.7	66.82	66.6	66.7	2580100.0
2006-01-03 13:00:00	IWM	ETF	66.71	66.87	66.57	66.78	2509400.0
2006-01-03 14:00:00	IWM	ETF	66.78	67.71	66.74	67.6	6775300.0
2006-01-03 15:00:00	IWM	ETF	67.61	68.15	67.6	67.91	10090000.0
2006-01-03 16:00:00	IWM	ETF	67.9	68.51	67.544	68.0	426500.0
2006-01-03 17:00:00	IWM	ETF	68.0	68.14	68.0	68.14	52400.0
2006-01-03 18:00:00	IWM	ETF	68.14	68.14	68.03	68.09	104500.0
2006-01-03 06:00:00	DIA	ETF	107.5	107.5	107.5	107.5	100.0
2006-01-03 07:00:00	DIA	ETF	107.67	107.67	107.58	107.58	37800.0
2006-01-03 08:00:00	DIA	ETF	107.67	107.67	106.95	107.45	72600.0
2006-01-03 09:00:00	DIA	ETF	107.47	107.57	107.17	107.27	808600.0
2006-01-03 10:00:00	DIA	ETF	107.25	107.36	106.74	106.91	1011500.0
2006-01-03 11:00:00	DIA	ETF	106.93	107.08	106.83	107.08	440000.0
2006-01-03 12:00:00	DIA	ETF	107.1	107.16	106.94	107.1	375200.0
2006-01-03 13:00:00	DIA	ETF	107.11	107.19	106.98	107.03	900100.0
2006-01-03 14:00:00	DIA	ETF	107.04	107.99	107.04	107.94	3022000.0
2006-01-03 15:00:00	DIA	ETF	107.95	108.56	107.93	108.37	2607400.0
2006-01-03 16:00:00	DIA	ETF	108.38	108.41	108.25	108.31	238200.0
2006-01-03 17:00:00	DIA	ETF	108.31	108.31	108.27	108.27	800.0

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

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