PREVIEW / etf_30min / 2005-05-27

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-05-27.parquet
  size:    41 KB
  rows:    1,460

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
2005-05-27 06:30:00	SPY	ETF	120.03	120.03	120.03	120.03	500.0
2005-05-27 07:00:00	SPY	ETF	120.06	120.06	120.06	120.06	1600.0
2005-05-27 07:30:00	SPY	ETF	120.1	120.15	120.08	120.15	160300.0
2005-05-27 08:00:00	SPY	ETF	120.15	120.15	120.1	120.11	39400.0
2005-05-27 08:30:00	SPY	ETF	120.1	120.19	120.1	120.17	48300.0
2005-05-27 09:00:00	SPY	ETF	120.16	120.16	120.09	120.1	27400.0
2005-05-27 09:30:00	SPY	ETF	120.06	120.1	119.91	120.0	4423100.0
2005-05-27 10:00:00	SPY	ETF	119.99	120.05	119.8	119.88	2361300.0
2005-05-27 10:30:00	SPY	ETF	119.88	119.98	119.81	119.92	1969900.0
2005-05-27 11:00:00	SPY	ETF	119.93	120.07	119.92	120.03	1727500.0
2005-05-27 11:30:00	SPY	ETF	120.03	120.06	119.96	119.98	1567900.0
2005-05-27 12:00:00	SPY	ETF	119.98	120.01	119.93	119.98	516400.0
2005-05-27 12:30:00	SPY	ETF	119.98	120.05	119.94	120.05	938300.0
2005-05-27 13:00:00	SPY	ETF	120.04	120.18	119.99	120.09	2499300.0
2005-05-27 13:30:00	SPY	ETF	120.1	120.1	120.04	120.08	636500.0
2005-05-27 14:00:00	SPY	ETF	120.09	120.23	120.06	120.19	1438700.0
2005-05-27 14:30:00	SPY	ETF	120.19	120.21	120.12	120.19	659900.0
2005-05-27 15:00:00	SPY	ETF	120.19	120.21	120.1	120.2	893400.0
2005-05-27 15:30:00	SPY	ETF	120.2	120.25	120.02	120.18	3164800.0
2005-05-27 16:00:00	SPY	ETF	120.18	120.32	120.15	120.27	150900.0
2005-05-27 16:30:00	SPY	ETF	120.27	120.4	120.27	120.4	37300.0
2005-05-27 17:00:00	SPY	ETF	120.4	120.43	120.34	120.34	6900.0
2005-05-27 17:30:00	SPY	ETF	120.34	120.34	120.34	120.34	400.0
2005-05-27 18:00:00	SPY	ETF	120.38	120.4	120.38	120.4	1700.0
2005-05-27 18:30:00	SPY	ETF	120.35	120.35	120.35	120.35	100.0
2005-05-27 19:30:00	SPY	ETF	120.35	120.35	120.35	120.35	100.0
2005-05-27 09:30:00	QQQ	ETF	38.14	38.17	38.08	38.11	9749700.0
2005-05-27 10:00:00	QQQ	ETF	38.11	38.15	38.02	38.07	7346800.0
2005-05-27 10:30:00	QQQ	ETF	38.07	38.13	38.05	38.11	4396700.0
2005-05-27 11:00:00	QQQ	ETF	38.11	38.16	38.1	38.16	2631600.0
2005-05-27 11:30:00	QQQ	ETF	38.16	38.16	38.11	38.12	1341100.0
2005-05-27 12:00:00	QQQ	ETF	38.12	38.15	38.11	38.13	769100.0
2005-05-27 12:30:00	QQQ	ETF	38.14	38.17	38.12	38.16	1044100.0
2005-05-27 13:00:00	QQQ	ETF	38.17	38.22	38.15	38.21	3455200.0
2005-05-27 13:30:00	QQQ	ETF	38.21	38.21	38.18	38.2	1332400.0
2005-05-27 14:00:00	QQQ	ETF	38.19	38.25	38.15	38.24	2269500.0
2005-05-27 14:30:00	QQQ	ETF	38.25	38.25	38.2	38.24	2016500.0
2005-05-27 15:00:00	QQQ	ETF	38.23	38.24	38.2	38.22	2403200.0
2005-05-27 15:30:00	QQQ	ETF	38.22	38.25	38.15	38.22	5951800.0
2005-05-27 08:00:00	IWM	ETF	61.2	61.2	61.2	61.2	400.0
2005-05-27 08:30:00	IWM	ETF	61.24	61.25	61.22	61.25	6200.0
2005-05-27 09:00:00	IWM	ETF	61.275	61.275	61.22	61.22	76000.0
2005-05-27 09:30:00	IWM	ETF	61.3	61.3	61.025	61.11	2216200.0
2005-05-27 10:00:00	IWM	ETF	61.11	61.17	60.9	60.97	2665400.0
2005-05-27 10:30:00	IWM	ETF	60.97	61.105	60.955	61.06	1118200.0
2005-05-27 11:00:00	IWM	ETF	61.07	61.125	61.07	61.1	269800.0
2005-05-27 11:30:00	IWM	ETF	61.1	61.13	61.08	61.11	497000.0
2005-05-27 12:00:00	IWM	ETF	61.11	61.185	61.095	61.115	614000.0
2005-05-27 12:30:00	IWM	ETF	61.135	61.245	61.11	61.235	446200.0
2005-05-27 13:00:00	IWM	ETF	61.245	61.465	61.225	61.44	2395000.0

> showing 50 of 1,460 rows — these rows as CSV

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