PREVIEW / etf_1hour / 2002-12-13

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-12-13.parquet
  size:    16 KB
  rows:    385

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
2002-12-13 08:00:00	SPY	ETF	90.0	90.02	89.75	89.93	40500.0
2002-12-13 09:00:00	SPY	ETF	89.98	90.4	89.84	89.95	6047000.0
2002-12-13 10:00:00	SPY	ETF	89.94	89.99	89.36	89.83	6564300.0
2002-12-13 11:00:00	SPY	ETF	89.87	90.0	89.61	89.87	2390500.0
2002-12-13 12:00:00	SPY	ETF	89.88	90.48	89.65	90.38	3615600.0
2002-12-13 13:00:00	SPY	ETF	90.4	90.45	90.05	90.14	2657900.0
2002-12-13 14:00:00	SPY	ETF	90.17	90.19	89.61	89.71	3049300.0
2002-12-13 15:00:00	SPY	ETF	89.7	89.91	89.48	89.54	4682900.0
2002-12-13 16:00:00	SPY	ETF	89.48	89.57	89.27	89.4	3138500.0
2002-12-13 17:00:00	SPY	ETF	89.4	89.4	89.15	89.2	7700.0
2002-12-13 18:00:00	SPY	ETF	89.17	89.18	89.08	89.12	8800.0
2002-12-13 19:00:00	SPY	ETF	89.23	89.32	89.09	89.09	2800.0
2002-12-13 08:00:00	QQQ	ETF	25.6	25.63	25.48	25.56	70300.0
2002-12-13 09:00:00	QQQ	ETF	25.56	25.59	25.27	25.31	13376600.0
2002-12-13 10:00:00	QQQ	ETF	25.32	25.33	25.1	25.23	16739600.0
2002-12-13 11:00:00	QQQ	ETF	25.23	25.3	25.12	25.25	7842800.0
2002-12-13 12:00:00	QQQ	ETF	25.25	25.39	25.16	25.36	4436600.0
2002-12-13 13:00:00	QQQ	ETF	25.36	25.41	25.2	25.26	6909500.0
2002-12-13 14:00:00	QQQ	ETF	25.25	25.28	25.06	25.09	4832500.0
2002-12-13 15:00:00	QQQ	ETF	25.09	25.2	25.03	25.05	10862900.0
2002-12-13 16:00:00	QQQ	ETF	25.05	25.09	24.97	25.0	3119400.0
2002-12-13 17:00:00	QQQ	ETF	24.98	24.99	24.9	24.94	103500.0
2002-12-13 18:00:00	QQQ	ETF	24.91	24.96	24.9	24.95	44200.0
2002-12-13 19:00:00	QQQ	ETF	24.96	24.97	24.9	24.95	15000.0
2002-12-13 08:00:00	IWM	ETF	39.21	39.21	39.01	39.01	5800.0
2002-12-13 09:00:00	IWM	ETF	39.02	39.95	38.91	38.96	161000.0
2002-12-13 10:00:00	IWM	ETF	38.95	38.95	38.73	38.85	334800.0
2002-12-13 11:00:00	IWM	ETF	38.805	38.85	38.75	38.785	192600.0
2002-12-13 12:00:00	IWM	ETF	38.78	38.915	38.71	38.915	160400.0
2002-12-13 13:00:00	IWM	ETF	38.915	38.935	38.775	38.875	48800.0
2002-12-13 14:00:00	IWM	ETF	38.89	38.9	38.72	38.72	80800.0
2002-12-13 15:00:00	IWM	ETF	38.78	38.88	38.56	38.585	581600.0
2002-12-13 16:00:00	IWM	ETF	38.535	38.595	38.48	38.575	85600.0
2002-12-13 08:00:00	DIA	ETF	84.7	84.77	84.7	84.77	1400.0
2002-12-13 09:00:00	DIA	ETF	84.92	85.3	84.75	84.95	1377800.0
2002-12-13 10:00:00	DIA	ETF	84.95	85.08	84.44	84.89	1484300.0
2002-12-13 11:00:00	DIA	ETF	84.89	85.1	84.71	84.93	586300.0
2002-12-13 12:00:00	DIA	ETF	84.92	85.45	84.72	85.35	463000.0
2002-12-13 13:00:00	DIA	ETF	85.35	85.45	85.03	85.16	500300.0
2002-12-13 14:00:00	DIA	ETF	85.14	85.19	84.72	84.8	643000.0
2002-12-13 15:00:00	DIA	ETF	84.81	84.98	84.56	84.59	865400.0
2002-12-13 16:00:00	DIA	ETF	84.51	84.83	84.35	84.42	144300.0
2002-12-13 17:00:00	DIA	ETF	84.42	84.42	84.27	84.27	3400.0
2002-12-13 18:00:00	DIA	ETF	84.3	84.3	84.2	84.2	1100.0
2002-12-13 19:00:00	DIA	ETF	84.29	84.29	84.29	84.29	100.0
2002-12-13 09:00:00	TLT	ETF	87.12	87.16	86.93	86.93	8700.0
2002-12-13 10:00:00	TLT	ETF	86.95	87.07	86.9	87.07	25200.0
2002-12-13 11:00:00	TLT	ETF	87.03	87.03	86.55	86.55	128400.0
2002-12-13 12:00:00	TLT	ETF	86.54	86.65	86.54	86.57	15500.0
2002-12-13 13:00:00	TLT	ETF	86.6	86.8	86.6	86.75	98200.0

> showing 50 of 385 rows — these rows as CSV

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