PREVIEW / etf_1hour / 2004-05-20

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-05-20.parquet
  size:    23 KB
  rows:    647

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-05-20 08:00:00	SPY	ETF	109.33	109.54	109.2	109.49	169600.0
2004-05-20 09:00:00	SPY	ETF	109.49	109.8	109.3	109.67	5950000.0
2004-05-20 10:00:00	SPY	ETF	109.67	109.87	109.43	109.67	5561800.0
2004-05-20 11:00:00	SPY	ETF	109.7	109.86	109.52	109.6	2870200.0
2004-05-20 12:00:00	SPY	ETF	109.59	109.6	109.04	109.43	7275200.0
2004-05-20 13:00:00	SPY	ETF	109.44	109.68	109.3	109.61	2779800.0
2004-05-20 14:00:00	SPY	ETF	109.6	109.79	109.36	109.52	4329600.0
2004-05-20 15:00:00	SPY	ETF	109.55	109.81	109.36	109.52	5690300.0
2004-05-20 16:00:00	SPY	ETF	109.51	109.68	109.45	109.5	1280500.0
2004-05-20 17:00:00	SPY	ETF	109.54	109.63	109.48	109.57	2800.0
2004-05-20 18:00:00	SPY	ETF	109.57	109.62	109.54	109.56	42800.0
2004-05-20 19:00:00	SPY	ETF	109.59	109.61	109.59	109.61	800.0
2004-05-20 08:00:00	QQQ	ETF	34.7	34.82	34.65	34.8	218300.0
2004-05-20 09:00:00	QQQ	ETF	34.79	35.02	34.73	34.94	16603600.0
2004-05-20 10:00:00	QQQ	ETF	34.934	35.0	34.8	34.94	12466100.0
2004-05-20 11:00:00	QQQ	ETF	34.94	34.98	34.783	34.84	10731000.0
2004-05-20 12:00:00	QQQ	ETF	34.832	34.85	34.56	34.8	22372000.0
2004-05-20 13:00:00	QQQ	ETF	34.79	34.9	34.71	34.85	8500800.0
2004-05-20 14:00:00	QQQ	ETF	34.846	34.91	34.65	34.79	11366900.0
2004-05-20 15:00:00	QQQ	ETF	34.79	34.886	34.697	34.77	9837800.0
2004-05-20 16:00:00	QQQ	ETF	34.77	34.861	34.73	34.82	1965000.0
2004-05-20 17:00:00	QQQ	ETF	34.82	34.85	34.798	34.8	101600.0
2004-05-20 18:00:00	QQQ	ETF	34.837	34.86	34.8	34.85	81400.0
2004-05-20 19:00:00	QQQ	ETF	34.85	34.87	34.84	34.84	6100.0
2004-05-20 08:00:00	IWM	ETF	53.7	54.04	53.7	54.04	13000.0
2004-05-20 09:00:00	IWM	ETF	53.975	54.3	53.755	54.205	1840600.0
2004-05-20 10:00:00	IWM	ETF	54.205	54.26	54.005	54.155	1663800.0
2004-05-20 11:00:00	IWM	ETF	54.16	54.21	53.985	54.05	1082400.0
2004-05-20 12:00:00	IWM	ETF	54.03	54.03	53.49	53.72	1588800.0
2004-05-20 13:00:00	IWM	ETF	53.7	53.95	53.64	53.91	871400.0
2004-05-20 14:00:00	IWM	ETF	53.925	54.05	53.73	53.85	1401400.0
2004-05-20 15:00:00	IWM	ETF	53.84	54.015	53.75	53.875	932000.0
2004-05-20 16:00:00	IWM	ETF	53.945	54.0	53.865	53.935	332400.0
2004-05-20 18:00:00	IWM	ETF	53.89	53.89	53.89	53.89	2000.0
2004-05-20 08:00:00	DIA	ETF	99.72	99.93	99.68	99.93	20400.0
2004-05-20 09:00:00	DIA	ETF	99.93	100.1	99.66	100.02	936600.0
2004-05-20 10:00:00	DIA	ETF	99.98	100.13	99.8	100.02	868100.0
2004-05-20 11:00:00	DIA	ETF	100.06	100.13	99.9	99.99	685300.0
2004-05-20 12:00:00	DIA	ETF	99.97	99.97	99.42	99.82	1347100.0
2004-05-20 13:00:00	DIA	ETF	99.86	99.99	99.71	99.9	1414800.0
2004-05-20 14:00:00	DIA	ETF	99.9	100.07	99.74	99.84	728300.0
2004-05-20 15:00:00	DIA	ETF	99.86	100.15	99.7	99.86	1483100.0
2004-05-20 16:00:00	DIA	ETF	99.88	100.02	99.81	99.98	352800.0
2004-05-20 17:00:00	DIA	ETF	99.94	99.99	99.94	99.99	600.0
2004-05-20 19:00:00	DIA	ETF	100.02	100.02	100.02	100.02	100.0
2004-05-20 09:00:00	TLT	ETF	81.74	81.8	81.72	81.73	179100.0
2004-05-20 10:00:00	TLT	ETF	81.73	81.78	81.62	81.75	63500.0
2004-05-20 11:00:00	TLT	ETF	81.75	81.84	81.73	81.84	284500.0
2004-05-20 12:00:00	TLT	ETF	81.8	82.0	81.8	81.86	155000.0
2004-05-20 13:00:00	TLT	ETF	81.87	82.0	81.87	81.9	62200.0

> showing 50 of 647 rows — these rows as CSV

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