PREVIEW / etf_30min / 2002-07-19

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-07-19.parquet
  size:    19 KB
  rows:    534

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-19 09:30:00	SPY	ETF	86.76	87.2	86.35	86.83	6419800.0
2002-07-19 10:00:00	SPY	ETF	86.85	87.55	86.65	86.95	5398800.0
2002-07-19 10:30:00	SPY	ETF	86.95	87.23	86.65	86.85	3085400.0
2002-07-19 11:00:00	SPY	ETF	86.85	87.03	86.12	86.44	4148200.0
2002-07-19 11:30:00	SPY	ETF	86.45	86.59	86.05	86.14	3512000.0
2002-07-19 12:00:00	SPY	ETF	86.14	86.72	86.12	86.39	1701300.0
2002-07-19 12:30:00	SPY	ETF	86.39	86.45	86.0	86.07	3308500.0
2002-07-19 13:00:00	SPY	ETF	86.1	86.3	85.84	85.98	3261100.0
2002-07-19 13:30:00	SPY	ETF	86.05	86.8	85.97	86.2	3145800.0
2002-07-19 14:00:00	SPY	ETF	86.2	86.44	85.96	86.03	2926800.0
2002-07-19 14:30:00	SPY	ETF	86.1	86.35	85.58	86.1	4342200.0
2002-07-19 15:00:00	SPY	ETF	86.14	86.15	85.7	86.0	3748000.0
2002-07-19 15:30:00	SPY	ETF	85.92	86.01	84.3	84.8	12642000.0
2002-07-19 16:00:00	SPY	ETF	84.83	85.3	84.64	84.71	2133000.0
2002-07-19 09:30:00	QQQ	ETF	24.33	24.5	24.02	24.4	23093800.0
2002-07-19 10:00:00	QQQ	ETF	24.41	24.71	24.31	24.5	15951900.0
2002-07-19 10:30:00	QQQ	ETF	24.51	24.71	24.37	24.5	8278600.0
2002-07-19 11:00:00	QQQ	ETF	24.5	24.64	24.27	24.41	7372300.0
2002-07-19 11:30:00	QQQ	ETF	24.4	24.49	24.19	24.26	7745100.0
2002-07-19 12:00:00	QQQ	ETF	24.25	24.45	24.22	24.35	5774200.0
2002-07-19 12:30:00	QQQ	ETF	24.36	24.4	24.23	24.3	3865700.0
2002-07-19 13:00:00	QQQ	ETF	24.29	24.38	24.15	24.21	4254200.0
2002-07-19 13:30:00	QQQ	ETF	24.21	24.5	24.2	24.28	6311000.0
2002-07-19 14:00:00	QQQ	ETF	24.28	24.4	24.2	24.29	3546500.0
2002-07-19 14:30:00	QQQ	ETF	24.3	24.4	24.16	24.34	7082300.0
2002-07-19 15:00:00	QQQ	ETF	24.34	24.35	24.15	24.24	6498500.0
2002-07-19 15:30:00	QQQ	ETF	24.26	24.28	23.8	24.0	16932200.0
2002-07-19 16:00:00	QQQ	ETF	23.95	24.05	23.88	23.99	2617300.0
2002-07-19 09:30:00	IWM	ETF	39.025	39.325	38.925	39.19	228600.0
2002-07-19 10:00:00	IWM	ETF	39.11	39.335	39.11	39.19	579800.0
2002-07-19 10:30:00	IWM	ETF	39.195	39.25	39.025	39.055	204200.0
2002-07-19 11:00:00	IWM	ETF	39.045	39.05	38.555	38.555	239800.0
2002-07-19 11:30:00	IWM	ETF	38.665	38.825	38.6	38.67	91400.0
2002-07-19 12:00:00	IWM	ETF	38.6	38.825	38.59	38.75	108400.0
2002-07-19 12:30:00	IWM	ETF	38.69	38.815	38.655	38.74	153600.0
2002-07-19 13:00:00	IWM	ETF	38.69	38.765	38.65	38.655	51800.0
2002-07-19 13:30:00	IWM	ETF	38.6	39.0	38.6	38.87	274000.0
2002-07-19 14:00:00	IWM	ETF	38.86	38.955	38.75	38.92	31200.0
2002-07-19 14:30:00	IWM	ETF	38.9	38.925	38.76	38.8	317600.0
2002-07-19 15:00:00	IWM	ETF	38.8	38.855	38.64	38.735	108600.0
2002-07-19 15:30:00	IWM	ETF	38.725	38.785	38.325	38.545	376800.0
2002-07-19 16:00:00	IWM	ETF	38.555	38.7	38.46	38.625	60200.0
2002-07-19 09:30:00	DIA	ETF	82.59	82.88	81.95	82.45	1938400.0
2002-07-19 10:00:00	DIA	ETF	82.5	83.1	82.16	82.51	805500.0
2002-07-19 10:30:00	DIA	ETF	82.51	82.79	82.14	82.19	574000.0
2002-07-19 11:00:00	DIA	ETF	82.18	82.25	81.3	81.67	1478100.0
2002-07-19 11:30:00	DIA	ETF	81.7	81.76	81.25	81.36	1111200.0
2002-07-19 12:00:00	DIA	ETF	81.41	82.0	81.33	81.6	714800.0
2002-07-19 12:30:00	DIA	ETF	81.61	81.7	81.25	81.4	613400.0
2002-07-19 13:00:00	DIA	ETF	81.34	81.6	80.97	81.28	802600.0

> showing 50 of 534 rows — these rows as CSV

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