PREVIEW / etf_30min / 2001-03-01

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-03-01.parquet
  size:    14 KB
  rows:    346

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
2001-03-01 09:30:00	SPY	ETF	124.05	124.1	122.66	123.12	1554100.0
2001-03-01 10:00:00	SPY	ETF	123.05	123.95	123.0	123.6	1205900.0
2001-03-01 10:30:00	SPY	ETF	123.5	123.6	122.5	122.5	808900.0
2001-03-01 11:00:00	SPY	ETF	122.49	123.17	122.45	122.92	439300.0
2001-03-01 11:30:00	SPY	ETF	123.0	123.46	122.86	123.06	515100.0
2001-03-01 12:00:00	SPY	ETF	123.02	123.1	122.3	122.65	486500.0
2001-03-01 12:30:00	SPY	ETF	122.63	122.89	122.4	122.41	435700.0
2001-03-01 13:00:00	SPY	ETF	122.45	122.82	122.1	122.1	697600.0
2001-03-01 13:30:00	SPY	ETF	122.17	122.7	122.03	122.41	634600.0
2001-03-01 14:00:00	SPY	ETF	122.41	122.43	121.75	122.18	1112300.0
2001-03-01 14:30:00	SPY	ETF	122.16	123.1	122.14	122.99	1319100.0
2001-03-01 15:00:00	SPY	ETF	122.99	124.0	122.67	123.85	2236800.0
2001-03-01 15:30:00	SPY	ETF	123.8	124.5	123.8	124.4	1756100.0
2001-03-01 16:00:00	SPY	ETF	124.45	124.6	123.14	124.16	816400.0
2001-03-01 16:30:00	SPY	ETF	124.6	124.75	124.57	124.57	500.0
2001-03-01 17:00:00	SPY	ETF	124.57	124.57	124.57	124.57	100.0
2001-03-01 17:30:00	SPY	ETF	124.6	124.6	124.6	124.6	100.0
2001-03-01 09:30:00	QQQ	ETF	46.97	47.41	46.25	46.75	9224200.0
2001-03-01 10:00:00	QQQ	ETF	46.75	47.55	46.65	47.14	8385100.0
2001-03-01 10:30:00	QQQ	ETF	47.19	47.3	46.49	46.55	4129800.0
2001-03-01 11:00:00	QQQ	ETF	46.5	47.09	46.4	46.88	4388700.0
2001-03-01 11:30:00	QQQ	ETF	46.88	47.47	46.78	47.18	4110900.0
2001-03-01 12:00:00	QQQ	ETF	47.16	47.24	46.53	46.85	2938700.0
2001-03-01 12:30:00	QQQ	ETF	46.75	46.98	46.45	46.51	2614700.0
2001-03-01 13:00:00	QQQ	ETF	46.5	46.75	46.13	46.15	3437400.0
2001-03-01 13:30:00	QQQ	ETF	46.07	46.45	46.0	46.27	5006100.0
2001-03-01 14:00:00	QQQ	ETF	46.34	46.36	45.75	46.08	4336900.0
2001-03-01 14:30:00	QQQ	ETF	46.1	47.0	45.97	46.9	8254300.0
2001-03-01 15:00:00	QQQ	ETF	46.85	48.59	46.7	48.2	18339600.0
2001-03-01 15:30:00	QQQ	ETF	48.23	49.2	48.15	48.93	15534400.0
2001-03-01 16:00:00	QQQ	ETF	49.1	49.1	48.5	48.85	1892800.0
2001-03-01 16:30:00	QQQ	ETF	48.84	49.0	48.0	48.03	553200.0
2001-03-01 17:00:00	QQQ	ETF	48.19	48.38	46.35	47.97	430700.0
2001-03-01 17:30:00	QQQ	ETF	47.9	48.05	47.6	47.8	125700.0
2001-03-01 18:00:00	QQQ	ETF	47.85	47.9	47.6	47.84	75900.0
2001-03-01 09:30:00	IWM	ETF	47.025	47.07	46.655	46.7	38400.0
2001-03-01 10:00:00	IWM	ETF	46.775	46.95	46.75	46.95	3400.0
2001-03-01 10:30:00	IWM	ETF	46.75	46.75	46.425	46.425	19400.0
2001-03-01 11:00:00	IWM	ETF	46.5	46.65	46.5	46.5	7200.0
2001-03-01 11:30:00	IWM	ETF	46.415	46.825	46.415	46.825	17000.0
2001-03-01 12:00:00	IWM	ETF	46.7	46.7	46.4	46.45	125000.0
2001-03-01 12:30:00	IWM	ETF	46.55	46.625	46.405	46.625	102400.0
2001-03-01 13:00:00	IWM	ETF	46.515	46.7	46.5	46.5	5600.0
2001-03-01 13:30:00	IWM	ETF	46.355	46.595	46.355	46.595	18200.0
2001-03-01 14:00:00	IWM	ETF	46.52	46.52	46.35	46.355	2200.0
2001-03-01 14:30:00	IWM	ETF	46.355	46.69	46.355	46.65	16800.0
2001-03-01 15:00:00	IWM	ETF	46.65	47.0	46.65	47.0	37800.0
2001-03-01 15:30:00	IWM	ETF	47.125	47.4	47.05	47.4	139400.0
2001-03-01 09:30:00	DIA	ETF	104.45	104.68	103.83	104.2	230300.0
2001-03-01 10:00:00	DIA	ETF	104.2	104.74	103.95	104.4	344800.0

> showing 50 of 346 rows — these rows as CSV

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