PREVIEW / etf_30min / 2002-07-31

all etf 30-min files

  file:    by_date/etf_30min/2002/2002-07-31.parquet
  size:    20 KB
  rows:    571

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-31 09:30:00	SPY	ETF	90.49	90.85	90.03	90.31	4315100.0
2002-07-31 10:00:00	SPY	ETF	90.3	90.36	89.55	89.55	4904700.0
2002-07-31 10:30:00	SPY	ETF	89.57	89.69	89.25	89.48	2948500.0
2002-07-31 11:00:00	SPY	ETF	89.48	90.08	89.38	89.87	2835600.0
2002-07-31 11:30:00	SPY	ETF	89.82	90.23	89.67	90.1	1754300.0
2002-07-31 12:00:00	SPY	ETF	90.1	90.55	90.09	90.18	2302600.0
2002-07-31 12:30:00	SPY	ETF	90.13	90.4	89.9	90.32	1911900.0
2002-07-31 13:00:00	SPY	ETF	90.41	90.41	89.85	89.96	1330200.0
2002-07-31 13:30:00	SPY	ETF	89.99	90.23	89.6	89.72	2004100.0
2002-07-31 14:00:00	SPY	ETF	89.72	90.08	89.37	89.55	2170600.0
2002-07-31 14:30:00	SPY	ETF	89.51	90.06	89.4	89.78	2259700.0
2002-07-31 15:00:00	SPY	ETF	89.76	90.65	89.5	90.1	2346700.0
2002-07-31 15:30:00	SPY	ETF	90.09	91.45	90.05	91.38	6210400.0
2002-07-31 16:00:00	SPY	ETF	91.39	91.55	91.16	91.16	2358300.0
2002-07-31 09:30:00	QQQ	ETF	24.0	24.19	23.88	23.88	11645000.0
2002-07-31 10:00:00	QQQ	ETF	23.9	23.95	23.54	23.57	14335600.0
2002-07-31 10:30:00	QQQ	ETF	23.56	23.69	23.5	23.66	8209200.0
2002-07-31 11:00:00	QQQ	ETF	23.64	23.79	23.58	23.77	4979400.0
2002-07-31 11:30:00	QQQ	ETF	23.77	23.84	23.63	23.77	4678400.0
2002-07-31 12:00:00	QQQ	ETF	23.77	23.92	23.72	23.75	4049100.0
2002-07-31 12:30:00	QQQ	ETF	23.74	23.79	23.64	23.77	2566600.0
2002-07-31 13:00:00	QQQ	ETF	23.77	23.8	23.51	23.59	4077200.0
2002-07-31 13:30:00	QQQ	ETF	23.61	23.69	23.44	23.5	4313100.0
2002-07-31 14:00:00	QQQ	ETF	23.51	23.58	23.36	23.43	6195800.0
2002-07-31 14:30:00	QQQ	ETF	23.42	23.67	23.41	23.5	4659600.0
2002-07-31 15:00:00	QQQ	ETF	23.48	23.73	23.42	23.57	5629700.0
2002-07-31 15:30:00	QQQ	ETF	23.56	23.92	23.53	23.89	10782200.0
2002-07-31 16:00:00	QQQ	ETF	23.9	23.93	23.81	23.85	1176300.0
2002-07-31 09:30:00	IWM	ETF	39.895	39.95	39.68	39.75	141800.0
2002-07-31 10:00:00	IWM	ETF	39.665	39.85	39.4	39.4	157600.0
2002-07-31 10:30:00	IWM	ETF	39.405	39.415	39.175	39.3	103600.0
2002-07-31 11:00:00	IWM	ETF	39.23	39.375	39.18	39.375	116200.0
2002-07-31 11:30:00	IWM	ETF	39.35	39.445	39.35	39.445	51000.0
2002-07-31 12:00:00	IWM	ETF	39.485	39.725	39.45	39.575	66800.0
2002-07-31 12:30:00	IWM	ETF	39.57	39.605	39.515	39.605	15800.0
2002-07-31 13:00:00	IWM	ETF	39.515	39.595	39.495	39.495	14600.0
2002-07-31 13:30:00	IWM	ETF	39.49	39.515	39.35	39.35	33200.0
2002-07-31 14:00:00	IWM	ETF	39.385	39.525	39.265	39.275	43600.0
2002-07-31 14:30:00	IWM	ETF	39.33	39.525	39.19	39.35	143400.0
2002-07-31 15:00:00	IWM	ETF	39.35	39.6	39.225	39.435	153800.0
2002-07-31 15:30:00	IWM	ETF	39.425	39.625	39.215	39.325	614000.0
2002-07-31 16:00:00	IWM	ETF	39.225	39.32	39.175	39.275	50200.0
2002-07-31 09:30:00	DIA	ETF	86.63	86.98	86.23	86.27	1248700.0
2002-07-31 10:00:00	DIA	ETF	86.28	86.34	85.65	85.7	1410400.0
2002-07-31 10:30:00	DIA	ETF	85.72	85.8	85.39	85.63	966600.0
2002-07-31 11:00:00	DIA	ETF	85.6	86.17	85.5	86.03	847400.0
2002-07-31 11:30:00	DIA	ETF	86.0	86.4	85.88	86.29	431500.0
2002-07-31 12:00:00	DIA	ETF	86.25	86.71	86.13	86.3	461100.0
2002-07-31 12:30:00	DIA	ETF	86.3	86.49	86.03	86.45	281600.0
2002-07-31 13:00:00	DIA	ETF	86.45	86.45	86.01	86.16	237500.0

> showing 50 of 571 rows — these rows as CSV

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