PREVIEW / etf_1hour / 2004-05-21

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-05-21.parquet
  size:    24 KB
  rows:    660

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-21 09:00:00	SPY	ETF	110.05	110.13	109.81	109.86	5583800.0
2004-05-21 10:00:00	SPY	ETF	109.85	110.2	109.62	110.2	7646700.0
2004-05-21 11:00:00	SPY	ETF	110.19	110.55	110.15	110.32	8686800.0
2004-05-21 12:00:00	SPY	ETF	110.32	110.4	110.21	110.29	2976400.0
2004-05-21 13:00:00	SPY	ETF	110.3	110.35	109.77	109.96	7102400.0
2004-05-21 14:00:00	SPY	ETF	109.97	110.03	109.47	109.63	4357600.0
2004-05-21 15:00:00	SPY	ETF	109.63	109.95	109.47	109.93	5755200.0
2004-05-21 16:00:00	SPY	ETF	109.94	109.98	109.69	109.75	2200100.0
2004-05-21 17:00:00	SPY	ETF	109.74	109.9	109.7	109.87	7500.0
2004-05-21 18:00:00	SPY	ETF	109.85	109.9	109.85	109.9	3000.0
2004-05-21 19:00:00	SPY	ETF	109.94	109.94	109.94	109.94	4400.0
2004-05-21 09:00:00	QQQ	ETF	35.05	35.1	34.877	34.92	16852700.0
2004-05-21 10:00:00	QQQ	ETF	34.919	35.03	34.78	34.96	25583600.0
2004-05-21 11:00:00	QQQ	ETF	34.96	35.17	34.95	35.07	19854300.0
2004-05-21 12:00:00	QQQ	ETF	35.069	35.09	35.01	35.04	7378100.0
2004-05-21 13:00:00	QQQ	ETF	35.04	35.05	34.85	34.92	7471500.0
2004-05-21 14:00:00	QQQ	ETF	34.92	34.93	34.74	34.78	12182600.0
2004-05-21 15:00:00	QQQ	ETF	34.776	35.01	34.738	35.0	13820100.0
2004-05-21 16:00:00	QQQ	ETF	35.008	35.04	34.95	34.99	2637000.0
2004-05-21 17:00:00	QQQ	ETF	34.99	35.04	34.98	35.04	155900.0
2004-05-21 18:00:00	QQQ	ETF	35.02	35.05	34.99	35.02	47500.0
2004-05-21 19:00:00	QQQ	ETF	35.03	35.03	35.0	35.03	7200.0
2004-05-21 09:00:00	IWM	ETF	54.2	54.3	54.03	54.165	861000.0
2004-05-21 10:00:00	IWM	ETF	54.165	54.395	53.93	54.395	1596600.0
2004-05-21 11:00:00	IWM	ETF	54.395	54.595	54.375	54.435	3004800.0
2004-05-21 12:00:00	IWM	ETF	54.46	54.475	54.375	54.39	871600.0
2004-05-21 13:00:00	IWM	ETF	54.395	54.41	54.1	54.205	1067600.0
2004-05-21 14:00:00	IWM	ETF	54.205	54.235	53.99	54.04	699400.0
2004-05-21 15:00:00	IWM	ETF	54.035	54.4	53.92	54.4	2850600.0
2004-05-21 16:00:00	IWM	ETF	54.4	54.415	54.345	54.395	208800.0
2004-05-21 09:00:00	DIA	ETF	100.0	100.1	99.81	99.87	420100.0
2004-05-21 10:00:00	DIA	ETF	99.86	100.15	99.62	100.12	556200.0
2004-05-21 11:00:00	DIA	ETF	100.15	100.53	100.15	100.32	884300.0
2004-05-21 12:00:00	DIA	ETF	100.32	100.43	100.22	100.3	313900.0
2004-05-21 13:00:00	DIA	ETF	100.33	100.34	99.81	99.92	678400.0
2004-05-21 14:00:00	DIA	ETF	99.93	100.01	99.56	99.69	928900.0
2004-05-21 15:00:00	DIA	ETF	99.7	99.88	99.55	99.85	1188500.0
2004-05-21 16:00:00	DIA	ETF	99.86	99.89	99.77	99.78	193800.0
2004-05-21 17:00:00	DIA	ETF	99.77	99.86	99.77	99.86	3500.0
2004-05-21 18:00:00	DIA	ETF	99.86	99.9	99.86	99.9	300.0
2004-05-21 19:00:00	DIA	ETF	99.91	99.91	99.91	99.91	100.0
2004-05-21 09:00:00	TLT	ETF	82.24	82.38	82.24	82.32	334200.0
2004-05-21 10:00:00	TLT	ETF	82.29	82.34	82.14	82.18	91300.0
2004-05-21 11:00:00	TLT	ETF	82.2	82.22	81.81	81.85	302400.0
2004-05-21 12:00:00	TLT	ETF	81.83	81.89	81.76	81.78	212500.0
2004-05-21 13:00:00	TLT	ETF	81.78	81.8	81.62	81.8	337900.0
2004-05-21 14:00:00	TLT	ETF	81.79	81.8	81.59	81.59	48000.0
2004-05-21 15:00:00	TLT	ETF	81.69	81.78	81.63	81.68	72700.0
2004-05-21 16:00:00	TLT	ETF	81.72	81.74	81.7	81.71	12300.0
2004-05-21 17:00:00	TLT	ETF	81.74	81.74	81.74	81.74	100.0

> showing 50 of 660 rows — these rows as CSV

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