PREVIEW / etf_1hour / 2004-03-23

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-23.parquet
  size:    24 KB
  rows:    691

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-03-23 08:00:00	SPY	ETF	110.2	110.35	110.14	110.32	154000.0
2004-03-23 09:00:00	SPY	ETF	110.32	110.39	110.01	110.2	8647200.0
2004-03-23 10:00:00	SPY	ETF	110.23	110.31	109.86	110.24	7500800.0
2004-03-23 11:00:00	SPY	ETF	110.25	110.25	109.65	109.92	6183400.0
2004-03-23 12:00:00	SPY	ETF	109.92	109.97	109.36	109.7	5050500.0
2004-03-23 13:00:00	SPY	ETF	109.69	110.17	109.57	110.03	4425800.0
2004-03-23 14:00:00	SPY	ETF	110.03	110.38	109.9	110.27	4862600.0
2004-03-23 15:00:00	SPY	ETF	110.27	110.4	109.63	109.69	5529600.0
2004-03-23 16:00:00	SPY	ETF	109.65	109.69	109.25	109.3	2274900.0
2004-03-23 17:00:00	SPY	ETF	109.3	109.48	109.27	109.4	102500.0
2004-03-23 18:00:00	SPY	ETF	109.35	109.35	109.23	109.25	19500.0
2004-03-23 19:00:00	SPY	ETF	109.2	109.3	109.2	109.24	14600.0
2004-03-23 08:00:00	QQQ	ETF	34.54	34.62	34.51	34.61	384300.0
2004-03-23 09:00:00	QQQ	ETF	34.6	34.65	34.478	34.55	11726000.0
2004-03-23 10:00:00	QQQ	ETF	34.56	34.58	34.355	34.47	16907200.0
2004-03-23 11:00:00	QQQ	ETF	34.48	34.48	34.111	34.29	14938900.0
2004-03-23 12:00:00	QQQ	ETF	34.283	34.29	34.01	34.208	19040400.0
2004-03-23 13:00:00	QQQ	ETF	34.208	34.37	34.12	34.32	13840200.0
2004-03-23 14:00:00	QQQ	ETF	34.31	34.5	34.27	34.466	11694200.0
2004-03-23 15:00:00	QQQ	ETF	34.461	34.5	34.1	34.12	18453500.0
2004-03-23 16:00:00	QQQ	ETF	34.12	34.14	33.97	33.97	4977400.0
2004-03-23 17:00:00	QQQ	ETF	33.98	34.05	33.97	34.03	136500.0
2004-03-23 18:00:00	QQQ	ETF	34.03	34.04	33.97	33.97	95800.0
2004-03-23 19:00:00	QQQ	ETF	34.0	34.01	33.98	33.98	10800.0
2004-03-23 09:00:00	IWM	ETF	56.15	56.5	56.025	56.42	2846200.0
2004-03-23 10:00:00	IWM	ETF	56.43	56.555	56.125	56.375	1674800.0
2004-03-23 11:00:00	IWM	ETF	56.375	56.375	55.87	56.06	1822200.0
2004-03-23 12:00:00	IWM	ETF	56.05	56.06	55.635	55.875	1105400.0
2004-03-23 13:00:00	IWM	ETF	55.88	56.19	55.795	56.115	1325800.0
2004-03-23 14:00:00	IWM	ETF	56.12	56.23	56.015	56.215	1144400.0
2004-03-23 15:00:00	IWM	ETF	56.2	56.33	55.95	55.96	2643200.0
2004-03-23 16:00:00	IWM	ETF	55.96	55.965	55.725	55.725	569600.0
2004-03-23 17:00:00	IWM	ETF	55.8	55.825	55.36	55.825	17000.0
2004-03-23 08:00:00	DIA	ETF	101.15	101.22	101.13	101.2	19800.0
2004-03-23 09:00:00	DIA	ETF	101.2	101.38	101.05	101.25	1238100.0
2004-03-23 10:00:00	DIA	ETF	101.24	101.29	100.97	101.27	1046300.0
2004-03-23 11:00:00	DIA	ETF	101.26	101.27	100.77	101.02	859300.0
2004-03-23 12:00:00	DIA	ETF	101.0	101.05	100.58	100.8	1166800.0
2004-03-23 13:00:00	DIA	ETF	100.8	101.24	100.72	101.17	1353400.0
2004-03-23 14:00:00	DIA	ETF	101.17	101.43	101.0	101.3	701500.0
2004-03-23 15:00:00	DIA	ETF	101.3	101.39	100.75	100.79	908400.0
2004-03-23 16:00:00	DIA	ETF	100.82	100.83	100.5	100.5	335000.0
2004-03-23 17:00:00	DIA	ETF	100.6	100.65	100.37	100.65	20200.0
2004-03-23 18:00:00	DIA	ETF	100.51	100.51	100.51	100.51	100.0
2004-03-23 19:00:00	DIA	ETF	100.51	100.51	100.51	100.51	500.0
2004-03-23 09:00:00	TLT	ETF	90.8	90.89	90.75	90.8	61900.0
2004-03-23 10:00:00	TLT	ETF	90.8	90.9	90.78	90.87	133900.0
2004-03-23 11:00:00	TLT	ETF	90.9	90.96	90.85	90.92	85100.0
2004-03-23 12:00:00	TLT	ETF	90.92	90.97	90.9	90.95	20100.0
2004-03-23 13:00:00	TLT	ETF	90.9	91.04	90.9	91.0	35000.0

> showing 50 of 691 rows — these rows as CSV

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