PREVIEW / etf_1hour / 2004-01-08

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-01-08.parquet
  size:    24 KB
  rows:    650

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
2004-01-08 08:00:00	SPY	ETF	112.9	113.42	112.9	113.36	155800.0
2004-01-08 09:00:00	SPY	ETF	113.34	113.36	112.89	113.08	6390800.0
2004-01-08 10:00:00	SPY	ETF	113.07	113.17	112.77	112.99	6529900.0
2004-01-08 11:00:00	SPY	ETF	112.99	113.2	112.84	113.08	3278200.0
2004-01-08 12:00:00	SPY	ETF	113.08	113.19	112.97	113.19	1457000.0
2004-01-08 13:00:00	SPY	ETF	113.16	113.3	112.91	113.23	3043800.0
2004-01-08 14:00:00	SPY	ETF	113.23	113.31	112.91	113.21	5718400.0
2004-01-08 15:00:00	SPY	ETF	113.23	113.41	113.13	113.32	5636700.0
2004-01-08 16:00:00	SPY	ETF	113.32	113.48	113.22	113.38	3163500.0
2004-01-08 17:00:00	SPY	ETF	113.38	113.45	113.35	113.41	63600.0
2004-01-08 18:00:00	SPY	ETF	113.41	113.43	113.4	113.41	7400.0
2004-01-08 19:00:00	SPY	ETF	113.43	113.43	113.38	113.38	1800.0
2004-01-08 08:00:00	QQQ	ETF	37.68	37.96	37.68	37.91	454300.0
2004-01-08 09:00:00	QQQ	ETF	37.92	37.93	37.68	37.781	13701100.0
2004-01-08 10:00:00	QQQ	ETF	37.8	37.84	37.6	37.72	12292700.0
2004-01-08 11:00:00	QQQ	ETF	37.73	37.87	37.65	37.8	7647300.0
2004-01-08 12:00:00	QQQ	ETF	37.81	37.9	37.78	37.87	5149500.0
2004-01-08 13:00:00	QQQ	ETF	37.87	37.97	37.75	37.94	10427500.0
2004-01-08 14:00:00	QQQ	ETF	37.933	37.97	37.762	37.922	6956900.0
2004-01-08 15:00:00	QQQ	ETF	37.93	37.98	37.84	37.94	11356000.0
2004-01-08 16:00:00	QQQ	ETF	37.95	38.0	37.91	37.98	5138300.0
2004-01-08 17:00:00	QQQ	ETF	37.98	38.04	37.7	38.01	446400.0
2004-01-08 18:00:00	QQQ	ETF	38.0	38.02	37.99	37.99	26900.0
2004-01-08 19:00:00	QQQ	ETF	38.01	38.02	38.0	38.0	8200.0
2004-01-08 09:00:00	IWM	ETF	57.46	57.6415	57.29	57.44	1317200.0
2004-01-08 10:00:00	IWM	ETF	57.41	57.4605	57.205	57.32	664200.0
2004-01-08 11:00:00	IWM	ETF	57.3	57.545	57.3	57.495	662000.0
2004-01-08 12:00:00	IWM	ETF	57.5	57.695	57.495	57.67	472200.0
2004-01-08 13:00:00	IWM	ETF	57.645	57.81	57.545	57.795	322800.0
2004-01-08 14:00:00	IWM	ETF	57.795	57.865	57.65	57.775	592000.0
2004-01-08 15:00:00	IWM	ETF	57.775	57.805	57.59	57.735	956400.0
2004-01-08 16:00:00	IWM	ETF	57.7	57.74	57.61	57.66	643400.0
2004-01-08 17:00:00	IWM	ETF	57.725	57.725	57.725	57.725	278000.0
2004-01-08 08:00:00	DIA	ETF	105.65	106.07	105.65	106.07	34900.0
2004-01-08 09:00:00	DIA	ETF	106.02	106.05	105.58	105.819	1491000.0
2004-01-08 10:00:00	DIA	ETF	105.8	105.85	105.51	105.76	1804300.0
2004-01-08 11:00:00	DIA	ETF	105.76	105.94	105.59	105.83	508000.0
2004-01-08 12:00:00	DIA	ETF	105.8	105.9	105.7	105.89	330900.0
2004-01-08 13:00:00	DIA	ETF	105.89	105.99	105.67	105.91	708500.0
2004-01-08 14:00:00	DIA	ETF	105.9	106.0	105.63	105.89	1166700.0
2004-01-08 15:00:00	DIA	ETF	105.87	106.06	105.82	106.02	1398500.0
2004-01-08 16:00:00	DIA	ETF	106.0	106.067	105.86	106.02	391500.0
2004-01-08 17:00:00	DIA	ETF	106.04	106.04	105.95	105.99	5600.0
2004-01-08 18:00:00	DIA	ETF	105.99	105.99	105.97	105.97	1000.0
2004-01-08 09:00:00	TLT	ETF	85.3	85.46	85.3	85.45	34100.0
2004-01-08 10:00:00	TLT	ETF	85.45	85.62	85.44	85.49	48600.0
2004-01-08 11:00:00	TLT	ETF	85.5	85.59	85.46	85.55	40700.0
2004-01-08 12:00:00	TLT	ETF	85.6	85.64	85.52	85.52	46700.0
2004-01-08 13:00:00	TLT	ETF	85.44	85.44	85.18	85.25	68400.0
2004-01-08 14:00:00	TLT	ETF	85.3	85.57	85.25	85.56	184600.0

> showing 50 of 650 rows — these rows as CSV

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