PREVIEW / etf_30min / 2001-07-27

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-07-27.parquet
  size:    14 KB
  rows:    355

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-07-27 09:30:00	SPY	ETF	120.83	120.99	120.17	120.3	1349900.0
2001-07-27 10:00:00	SPY	ETF	120.31	120.67	120.06	120.09	631800.0
2001-07-27 10:30:00	SPY	ETF	120.14	120.25	119.91	120.21	594300.0
2001-07-27 11:00:00	SPY	ETF	120.17	120.85	120.06	120.77	818700.0
2001-07-27 11:30:00	SPY	ETF	120.78	121.07	120.62	120.79	886500.0
2001-07-27 12:00:00	SPY	ETF	120.79	120.85	120.61	120.85	414600.0
2001-07-27 12:30:00	SPY	ETF	120.86	121.18	120.79	120.95	271800.0
2001-07-27 13:00:00	SPY	ETF	120.95	121.35	120.95	121.26	268800.0
2001-07-27 13:30:00	SPY	ETF	121.25	121.29	120.97	121.04	448900.0
2001-07-27 14:00:00	SPY	ETF	121.0	121.05	120.72	120.85	458200.0
2001-07-27 14:30:00	SPY	ETF	120.83	121.16	120.66	120.91	308300.0
2001-07-27 15:00:00	SPY	ETF	120.99	121.04	120.66	120.82	301600.0
2001-07-27 15:30:00	SPY	ETF	120.8	121.06	120.67	121.04	483800.0
2001-07-27 16:00:00	SPY	ETF	121.0	121.15	120.81	120.9	242800.0
2001-07-27 16:30:00	SPY	ETF	120.85	120.85	120.85	120.85	20000.0
2001-07-27 09:30:00	QQQ	ETF	41.64	42.02	41.4	41.56	9532700.0
2001-07-27 10:00:00	QQQ	ETF	41.56	41.95	41.42	41.55	4776800.0
2001-07-27 10:30:00	QQQ	ETF	41.56	41.7	41.35	41.56	3491700.0
2001-07-27 11:00:00	QQQ	ETF	41.67	41.93	41.52	41.9	3000500.0
2001-07-27 11:30:00	QQQ	ETF	41.82	42.06	41.7	41.76	3824500.0
2001-07-27 12:00:00	QQQ	ETF	41.77	41.94	41.65	41.9	1491800.0
2001-07-27 12:30:00	QQQ	ETF	41.93	42.1	41.8	41.9	2400900.0
2001-07-27 13:00:00	QQQ	ETF	41.9	42.26	41.88	42.12	3339900.0
2001-07-27 13:30:00	QQQ	ETF	42.13	42.21	41.92	42.0	2355100.0
2001-07-27 14:00:00	QQQ	ETF	41.96	42.0	41.68	41.84	3043300.0
2001-07-27 14:30:00	QQQ	ETF	41.83	42.08	41.73	41.99	2070000.0
2001-07-27 15:00:00	QQQ	ETF	41.97	42.08	41.78	41.84	2021000.0
2001-07-27 15:30:00	QQQ	ETF	41.84	42.0	41.75	41.93	3337500.0
2001-07-27 16:00:00	QQQ	ETF	41.94	42.0	41.9	41.93	928200.0
2001-07-27 16:30:00	QQQ	ETF	41.92	42.01	41.85	41.95	28400.0
2001-07-27 17:00:00	QQQ	ETF	41.92	41.93	41.88	41.9	15900.0
2001-07-27 17:30:00	QQQ	ETF	41.9	41.9	41.9	41.9	8200.0
2001-07-27 18:00:00	QQQ	ETF	41.9	41.93	41.9	41.91	1300.0
2001-07-27 09:30:00	IWM	ETF	48.325	48.5	48.125	48.3	249000.0
2001-07-27 10:00:00	IWM	ETF	48.35	48.35	48.175	48.32	5200.0
2001-07-27 10:30:00	IWM	ETF	48.13	48.245	48.085	48.245	3200.0
2001-07-27 11:00:00	IWM	ETF	48.105	48.44	48.105	48.44	17000.0
2001-07-27 11:30:00	IWM	ETF	48.43	48.43	48.255	48.3	72600.0
2001-07-27 12:00:00	IWM	ETF	48.37	48.37	48.21	48.21	11600.0
2001-07-27 12:30:00	IWM	ETF	48.415	48.49	48.415	48.49	23400.0
2001-07-27 13:00:00	IWM	ETF	48.49	48.49	48.46	48.49	6200.0
2001-07-27 13:30:00	IWM	ETF	48.475	48.495	48.425	48.49	70200.0
2001-07-27 14:00:00	IWM	ETF	48.525	48.525	48.395	48.395	8400.0
2001-07-27 14:30:00	IWM	ETF	48.285	48.485	48.26	48.35	49200.0
2001-07-27 15:00:00	IWM	ETF	48.44	48.44	48.44	48.44	1400.0
2001-07-27 15:30:00	IWM	ETF	48.42	48.43	48.35	48.35	12400.0
2001-07-27 09:30:00	DIA	ETF	104.55	104.7	104.01	104.13	199300.0
2001-07-27 10:00:00	DIA	ETF	104.16	104.35	103.95	104.0	152400.0
2001-07-27 10:30:00	DIA	ETF	104.02	104.12	103.81	104.05	53200.0
2001-07-27 11:00:00	DIA	ETF	104.05	104.5	103.92	104.35	86300.0

> showing 50 of 355 rows — these rows as CSV

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