PREVIEW / etf_1hour / 2003-04-30

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-04-30.parquet
  size:    16 KB
  rows:    402

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
2003-04-30 08:00:00	SPY	ETF	91.97	91.97	91.78	91.78	17500.0
2003-04-30 09:00:00	SPY	ETF	91.8	92.14	91.44	92.01	7349900.0
2003-04-30 10:00:00	SPY	ETF	92.01	92.07	91.41	92.02	7760500.0
2003-04-30 11:00:00	SPY	ETF	92.03	92.49	91.82	91.93	7363500.0
2003-04-30 12:00:00	SPY	ETF	91.98	92.15	91.71	92.11	2573800.0
2003-04-30 13:00:00	SPY	ETF	92.09	92.38	91.95	92.18	2774300.0
2003-04-30 14:00:00	SPY	ETF	92.18	92.57	92.08	92.26	3690500.0
2003-04-30 15:00:00	SPY	ETF	92.26	92.53	91.85	91.88	5423100.0
2003-04-30 16:00:00	SPY	ETF	91.85	92.04	91.7	91.91	6764300.0
2003-04-30 17:00:00	SPY	ETF	91.9	92.0	91.9	91.99	15000.0
2003-04-30 18:00:00	SPY	ETF	92.0	92.0	91.86	91.86	11900.0
2003-04-30 19:00:00	SPY	ETF	91.87	91.9	91.86	91.86	2400.0
2003-04-30 08:00:00	QQQ	ETF	27.7	27.71	27.62	27.63	49800.0
2003-04-30 09:00:00	QQQ	ETF	27.63	27.73	27.5	27.69	7260400.0
2003-04-30 10:00:00	QQQ	ETF	27.69	27.7	27.43	27.61	12350000.0
2003-04-30 11:00:00	QQQ	ETF	27.62	27.79	27.5	27.53	10995900.0
2003-04-30 12:00:00	QQQ	ETF	27.53	27.62	27.44	27.56	4022700.0
2003-04-30 13:00:00	QQQ	ETF	27.57	27.69	27.49	27.59	4600200.0
2003-04-30 14:00:00	QQQ	ETF	27.59	27.73	27.55	27.6	4517000.0
2003-04-30 15:00:00	QQQ	ETF	27.6	27.71	27.46	27.48	7897500.0
2003-04-30 16:00:00	QQQ	ETF	27.5	27.51	27.42	27.42	2295200.0
2003-04-30 17:00:00	QQQ	ETF	27.42	27.47	27.42	27.47	90100.0
2003-04-30 18:00:00	QQQ	ETF	27.49	27.49	27.42	27.42	45200.0
2003-04-30 19:00:00	QQQ	ETF	27.42	27.43	27.39	27.39	30900.0
2003-04-30 09:00:00	IWM	ETF	39.425	39.46	39.315	39.45	246600.0
2003-04-30 10:00:00	IWM	ETF	39.5	39.545	39.3	39.525	371200.0
2003-04-30 11:00:00	IWM	ETF	39.54	39.72	39.53	39.6	184200.0
2003-04-30 12:00:00	IWM	ETF	39.58	39.725	39.54	39.725	140400.0
2003-04-30 13:00:00	IWM	ETF	39.72	39.87	39.695	39.82	169200.0
2003-04-30 14:00:00	IWM	ETF	39.81	39.95	39.77	39.82	166200.0
2003-04-30 15:00:00	IWM	ETF	39.82	39.895	39.62	39.645	477400.0
2003-04-30 16:00:00	IWM	ETF	39.65	39.7	39.585	39.7	293800.0
2003-04-30 08:00:00	DIA	ETF	84.9	84.9	84.83	84.88	1100.0
2003-04-30 09:00:00	DIA	ETF	84.85	85.11	84.44	85.02	1511900.0
2003-04-30 10:00:00	DIA	ETF	85.1	85.1	84.47	84.93	2281500.0
2003-04-30 11:00:00	DIA	ETF	84.93	85.4	84.73	84.82	1858300.0
2003-04-30 12:00:00	DIA	ETF	84.83	85.0	84.63	84.93	512200.0
2003-04-30 13:00:00	DIA	ETF	84.93	85.21	84.8	85.02	637400.0
2003-04-30 14:00:00	DIA	ETF	85.03	85.41	84.92	85.11	741900.0
2003-04-30 15:00:00	DIA	ETF	85.11	85.37	84.77	84.8	1455700.0
2003-04-30 16:00:00	DIA	ETF	84.79	85.01	84.65	84.88	235300.0
2003-04-30 17:00:00	DIA	ETF	84.86	84.86	84.85	84.85	500.0
2003-04-30 18:00:00	DIA	ETF	84.87	84.87	84.79	84.79	3200.0
2003-04-30 19:00:00	DIA	ETF	84.83	84.93	84.83	84.93	1000.0
2003-04-30 09:00:00	TLT	ETF	88.79	88.79	88.73	88.73	5300.0
2003-04-30 10:00:00	TLT	ETF	88.72	89.17	88.72	89.17	36200.0
2003-04-30 11:00:00	TLT	ETF	89.1	89.2	89.1	89.19	68800.0
2003-04-30 12:00:00	TLT	ETF	89.2	89.36	89.2	89.27	18400.0
2003-04-30 13:00:00	TLT	ETF	89.15	89.23	89.15	89.23	1100.0
2003-04-30 14:00:00	TLT	ETF	89.18	89.36	89.18	89.29	5000.0

> showing 50 of 402 rows — these rows as CSV

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