PREVIEW / etf_30min / 2001-11-01

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-11-01.parquet
  size:    17 KB
  rows:    417

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-11-01 09:30:00	SPY	ETF	106.6	106.88	106.29	106.58	2949400.0
2001-11-01 10:00:00	SPY	ETF	106.64	107.0	105.69	106.35	3947100.0
2001-11-01 10:30:00	SPY	ETF	106.38	107.5	106.34	107.44	2698400.0
2001-11-01 11:00:00	SPY	ETF	107.45	107.59	107.06	107.3	2737600.0
2001-11-01 11:30:00	SPY	ETF	107.27	107.47	107.08	107.25	1220900.0
2001-11-01 12:00:00	SPY	ETF	107.28	107.69	107.18	107.28	712100.0
2001-11-01 12:30:00	SPY	ETF	107.32	107.82	107.32	107.69	1162600.0
2001-11-01 13:00:00	SPY	ETF	107.69	108.45	107.68	108.36	2843000.0
2001-11-01 13:30:00	SPY	ETF	108.37	108.7	108.31	108.37	1400400.0
2001-11-01 14:00:00	SPY	ETF	108.31	108.75	108.27	108.7	959600.0
2001-11-01 14:30:00	SPY	ETF	108.69	108.77	108.05	108.11	1895100.0
2001-11-01 15:00:00	SPY	ETF	108.15	108.6	108.06	108.41	2164500.0
2001-11-01 15:30:00	SPY	ETF	108.44	109.01	108.36	108.67	2552900.0
2001-11-01 16:00:00	SPY	ETF	108.71	108.71	108.43	108.47	1653200.0
2001-11-01 16:30:00	SPY	ETF	108.5	108.53	108.5	108.51	2600.0
2001-11-01 17:00:00	SPY	ETF	108.47	108.48	108.25	108.25	40700.0
2001-11-01 17:30:00	SPY	ETF	108.2	108.45	108.2	108.45	500.0
2001-11-01 09:30:00	QQQ	ETF	34.44	34.6	34.2	34.42	9329400.0
2001-11-01 10:00:00	QQQ	ETF	34.42	34.71	33.78	34.3	11975000.0
2001-11-01 10:30:00	QQQ	ETF	34.28	34.86	34.25	34.82	11549900.0
2001-11-01 11:00:00	QQQ	ETF	34.82	34.9	34.56	34.69	4850100.0
2001-11-01 11:30:00	QQQ	ETF	34.69	34.84	34.54	34.64	3873100.0
2001-11-01 12:00:00	QQQ	ETF	34.65	34.84	34.49	34.56	2650000.0
2001-11-01 12:30:00	QQQ	ETF	34.59	34.86	34.56	34.69	3102900.0
2001-11-01 13:00:00	QQQ	ETF	34.72	35.2	34.3	35.09	8134400.0
2001-11-01 13:30:00	QQQ	ETF	35.02	35.3	35.01	35.13	9292400.0
2001-11-01 14:00:00	QQQ	ETF	35.13	35.38	35.06	35.36	4634300.0
2001-11-01 14:30:00	QQQ	ETF	35.37	35.42	35.05	35.05	4947000.0
2001-11-01 15:00:00	QQQ	ETF	35.07	35.43	35.02	35.34	5825900.0
2001-11-01 15:30:00	QQQ	ETF	35.32	35.56	35.3	35.44	8955300.0
2001-11-01 16:00:00	QQQ	ETF	35.45	35.48	35.2	35.34	1968800.0
2001-11-01 16:30:00	QQQ	ETF	35.31	35.37	35.3	35.37	126400.0
2001-11-01 17:00:00	QQQ	ETF	35.31	35.35	35.17	35.18	75700.0
2001-11-01 17:30:00	QQQ	ETF	35.18	35.24	35.14	35.2	31400.0
2001-11-01 18:00:00	QQQ	ETF	35.24	35.3	35.24	35.28	39800.0
2001-11-01 09:30:00	IWM	ETF	42.67	42.8	42.6	42.6	23200.0
2001-11-01 10:00:00	IWM	ETF	42.695	42.7	42.25	42.4	128400.0
2001-11-01 10:30:00	IWM	ETF	42.48	42.745	42.4	42.74	46400.0
2001-11-01 11:00:00	IWM	ETF	42.75	42.9	42.735	42.89	40000.0
2001-11-01 11:30:00	IWM	ETF	42.89	42.9	42.73	42.75	41600.0
2001-11-01 12:00:00	IWM	ETF	42.815	42.875	42.815	42.85	15000.0
2001-11-01 12:30:00	IWM	ETF	42.82	42.9	42.8	42.84	241600.0
2001-11-01 13:00:00	IWM	ETF	42.85	43.15	42.85	43.07	90800.0
2001-11-01 13:30:00	IWM	ETF	43.05	43.175	43.05	43.05	20800.0
2001-11-01 14:00:00	IWM	ETF	43.03	43.075	43.03	43.07	19600.0
2001-11-01 14:30:00	IWM	ETF	43.075	43.1	42.925	42.955	50400.0
2001-11-01 15:00:00	IWM	ETF	42.94	43.05	42.8	42.955	31200.0
2001-11-01 15:30:00	IWM	ETF	42.975	43.3	42.975	43.3	37000.0
2001-11-01 16:00:00	IWM	ETF	42.575	42.575	42.575	42.575	3600.0
2001-11-01 09:30:00	DIA	ETF	91.15	91.34	90.66	90.93	555000.0

> showing 50 of 417 rows — these rows as CSV

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