PREVIEW / etf_30min / 2002-07-18

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-07-18.parquet
  size:    18 KB
  rows:    489

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-07-18 09:30:00	SPY	ETF	90.7	91.1	90.02	90.26	3731600.0
2002-07-18 10:00:00	SPY	ETF	90.25	90.59	89.65	90.3	3208100.0
2002-07-18 10:30:00	SPY	ETF	90.27	90.7	90.02	90.07	1513900.0
2002-07-18 11:00:00	SPY	ETF	90.02	90.86	90.0	90.55	1450100.0
2002-07-18 11:30:00	SPY	ETF	90.53	91.0	90.39	90.96	1075300.0
2002-07-18 12:00:00	SPY	ETF	91.0	91.05	90.16	90.53	3190300.0
2002-07-18 12:30:00	SPY	ETF	90.52	90.74	90.25	90.43	613400.0
2002-07-18 13:00:00	SPY	ETF	90.37	90.64	90.2	90.25	757200.0
2002-07-18 13:30:00	SPY	ETF	90.27	90.34	89.99	90.19	1200600.0
2002-07-18 14:00:00	SPY	ETF	90.18	90.25	89.3	89.46	2186400.0
2002-07-18 14:30:00	SPY	ETF	89.48	89.48	88.8	89.0	3008400.0
2002-07-18 15:00:00	SPY	ETF	89.02	89.27	88.71	88.91	2389200.0
2002-07-18 15:30:00	SPY	ETF	88.88	88.97	88.24	88.33	4181800.0
2002-07-18 16:00:00	SPY	ETF	88.3	88.35	87.75	87.8	1864400.0
2002-07-18 09:30:00	QQQ	ETF	25.38	25.57	25.03	25.13	14682000.0
2002-07-18 10:00:00	QQQ	ETF	25.13	25.26	25.01	25.12	11321400.0
2002-07-18 10:30:00	QQQ	ETF	25.12	25.3	25.1	25.12	6906900.0
2002-07-18 11:00:00	QQQ	ETF	25.14	25.44	25.1	25.31	6515900.0
2002-07-18 11:30:00	QQQ	ETF	25.3	25.52	25.2	25.5	8462500.0
2002-07-18 12:00:00	QQQ	ETF	25.5	25.53	25.22	25.28	9721700.0
2002-07-18 12:30:00	QQQ	ETF	25.28	25.35	25.07	25.16	4830800.0
2002-07-18 13:00:00	QQQ	ETF	25.18	25.32	25.11	25.15	3525300.0
2002-07-18 13:30:00	QQQ	ETF	25.19	25.2	25.03	25.1	5753400.0
2002-07-18 14:00:00	QQQ	ETF	25.09	25.15	24.85	24.9	8081900.0
2002-07-18 14:30:00	QQQ	ETF	24.9	24.99	24.71	24.8	9433000.0
2002-07-18 15:00:00	QQQ	ETF	24.77	24.9	24.73	24.84	7164600.0
2002-07-18 15:30:00	QQQ	ETF	24.84	24.91	24.67	24.78	9867200.0
2002-07-18 16:00:00	QQQ	ETF	24.76	24.89	24.72	24.73	796100.0
2002-07-18 09:30:00	IWM	ETF	40.65	40.95	40.605	40.605	65600.0
2002-07-18 10:00:00	IWM	ETF	40.525	40.79	40.5	40.79	201400.0
2002-07-18 10:30:00	IWM	ETF	40.68	40.885	40.68	40.75	75600.0
2002-07-18 11:00:00	IWM	ETF	40.71	40.9	40.71	40.8	97800.0
2002-07-18 11:30:00	IWM	ETF	40.88	40.88	40.7	40.86	47400.0
2002-07-18 12:00:00	IWM	ETF	40.76	40.76	40.505	40.57	113600.0
2002-07-18 12:30:00	IWM	ETF	40.67	40.67	40.5	40.57	6600.0
2002-07-18 13:00:00	IWM	ETF	40.57	40.61	40.43	40.43	4600.0
2002-07-18 13:30:00	IWM	ETF	40.4	40.5	40.125	40.125	44800.0
2002-07-18 14:00:00	IWM	ETF	40.305	40.305	39.875	39.875	184400.0
2002-07-18 14:30:00	IWM	ETF	39.825	39.945	39.73	39.835	285200.0
2002-07-18 15:00:00	IWM	ETF	39.77	40.0	39.76	39.8	131400.0
2002-07-18 15:30:00	IWM	ETF	39.87	39.89	39.525	39.575	563800.0
2002-07-18 16:00:00	IWM	ETF	39.575	39.575	39.45	39.45	5200.0
2002-07-18 09:30:00	DIA	ETF	85.56	86.05	85.25	85.39	668400.0
2002-07-18 10:00:00	DIA	ETF	85.45	85.89	84.9	85.7	582600.0
2002-07-18 10:30:00	DIA	ETF	85.62	86.0	85.46	85.56	418700.0
2002-07-18 11:00:00	DIA	ETF	85.44	86.26	85.4	85.97	469900.0
2002-07-18 11:30:00	DIA	ETF	85.93	86.45	85.85	86.39	278500.0
2002-07-18 12:00:00	DIA	ETF	86.45	86.45	85.55	86.03	777700.0
2002-07-18 12:30:00	DIA	ETF	86.07	86.29	85.77	86.0	149500.0
2002-07-18 13:00:00	DIA	ETF	85.96	86.25	85.78	85.85	264600.0

> showing 50 of 489 rows — these rows as CSV

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