PREVIEW / etf_1hour / 2002-08-19

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-08-19.parquet
  size:    16 KB
  rows:    363

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-08-19 09:00:00	SPY	ETF	93.46	93.73	93.18	93.64	1993000.0
2002-08-19 10:00:00	SPY	ETF	93.6	94.7	93.57	94.63	7641800.0
2002-08-19 11:00:00	SPY	ETF	94.7	95.0	94.55	94.76	4073600.0
2002-08-19 12:00:00	SPY	ETF	94.79	95.0	94.55	94.74	2071400.0
2002-08-19 13:00:00	SPY	ETF	94.74	95.36	94.72	95.36	3439600.0
2002-08-19 14:00:00	SPY	ETF	95.34	95.49	94.76	95.04	5625000.0
2002-08-19 15:00:00	SPY	ETF	95.0	95.75	94.85	95.52	6085000.0
2002-08-19 16:00:00	SPY	ETF	95.49	95.6	95.35	95.4	1245100.0
2002-08-19 09:00:00	QQQ	ETF	24.77	24.92	24.68	24.89	8577400.0
2002-08-19 10:00:00	QQQ	ETF	24.89	25.14	24.84	25.1	17883600.0
2002-08-19 11:00:00	QQQ	ETF	25.1	25.29	25.07	25.19	10740300.0
2002-08-19 12:00:00	QQQ	ETF	25.18	25.27	25.1	25.22	3947800.0
2002-08-19 13:00:00	QQQ	ETF	25.23	25.55	25.2	25.52	9083500.0
2002-08-19 14:00:00	QQQ	ETF	25.54	25.59	25.21	25.35	9367100.0
2002-08-19 15:00:00	QQQ	ETF	25.35	25.56	25.28	25.47	13160400.0
2002-08-19 16:00:00	QQQ	ETF	25.46	25.48	25.3	25.3	490000.0
2002-08-19 09:00:00	IWM	ETF	39.705	39.75	39.535	39.68	562600.0
2002-08-19 10:00:00	IWM	ETF	39.68	40.0	39.675	39.995	383400.0
2002-08-19 11:00:00	IWM	ETF	39.98	40.125	39.9	39.935	238200.0
2002-08-19 12:00:00	IWM	ETF	39.955	39.955	39.845	39.875	172800.0
2002-08-19 13:00:00	IWM	ETF	39.875	40.05	39.875	40.0	507400.0
2002-08-19 14:00:00	IWM	ETF	40.01	40.075	39.875	39.885	1038600.0
2002-08-19 15:00:00	IWM	ETF	39.9	40.14	39.895	40.09	195600.0
2002-08-19 16:00:00	IWM	ETF	40.05	40.05	39.99	40.025	8000.0
2002-08-19 09:00:00	DIA	ETF	87.53	88.2	87.5	88.0	727500.0
2002-08-19 10:00:00	DIA	ETF	88.0	89.33	87.96	89.26	2285600.0
2002-08-19 11:00:00	DIA	ETF	89.25	89.58	89.0	89.33	1364700.0
2002-08-19 12:00:00	DIA	ETF	89.32	89.48	89.03	89.32	599500.0
2002-08-19 13:00:00	DIA	ETF	89.31	89.8	89.18	89.79	1164500.0
2002-08-19 14:00:00	DIA	ETF	89.77	89.89	89.12	89.43	1179600.0
2002-08-19 15:00:00	DIA	ETF	89.43	90.13	89.3	89.99	2027200.0
2002-08-19 16:00:00	DIA	ETF	89.98	90.0	89.83	89.92	86800.0
2002-08-19 09:00:00	TLT	ETF	85.05	85.11	84.95	85.02	10300.0
2002-08-19 10:00:00	TLT	ETF	85.05	85.24	84.9	85.12	5600.0
2002-08-19 11:00:00	TLT	ETF	85.04	85.08	84.71	84.88	7900.0
2002-08-19 12:00:00	TLT	ETF	84.84	85.22	84.84	85.05	7400.0
2002-08-19 13:00:00	TLT	ETF	85.0	85.02	84.78	85.02	7700.0
2002-08-19 14:00:00	TLT	ETF	85.08	85.34	85.07	85.34	4700.0
2002-08-19 15:00:00	TLT	ETF	85.25	85.34	85.25	85.32	3700.0

> showing 39 of 363 rows — these rows as CSV

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