PREVIEW / etf_30min / 2003-06-27

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-06-27.parquet
  size:    23 KB
  rows:    685

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
2003-06-27 08:00:00	SPY	ETF	98.86	98.91	98.86	98.86	22600.0
2003-06-27 08:30:00	SPY	ETF	98.9	98.91	98.84	98.85	21600.0
2003-06-27 09:00:00	SPY	ETF	98.84	98.85	98.77	98.85	5200.0
2003-06-27 09:30:00	SPY	ETF	98.747	98.81	98.2	98.4	6185000.0
2003-06-27 10:00:00	SPY	ETF	98.4	98.92	98.312	98.86	3889800.0
2003-06-27 10:30:00	SPY	ETF	98.87	99.15	98.82	99.126	2512400.0
2003-06-27 11:00:00	SPY	ETF	99.12	99.19	98.91	98.921	4758600.0
2003-06-27 11:30:00	SPY	ETF	98.91	99.08	98.68	98.76	4406500.0
2003-06-27 12:00:00	SPY	ETF	98.76	98.84	98.64	98.82	713900.0
2003-06-27 12:30:00	SPY	ETF	98.82	98.89	98.66	98.7	723200.0
2003-06-27 13:00:00	SPY	ETF	98.79	98.88	98.5	98.52	1846500.0
2003-06-27 13:30:00	SPY	ETF	98.52	98.58	97.75	98.0	5892900.0
2003-06-27 14:00:00	SPY	ETF	98.02	98.12	97.9	98.07	1669900.0
2003-06-27 14:30:00	SPY	ETF	98.08	98.18	98.02	98.12	2741200.0
2003-06-27 15:00:00	SPY	ETF	98.12	98.17	97.66	97.85	2253400.0
2003-06-27 15:30:00	SPY	ETF	97.847	98.09	97.78	97.86	1907900.0
2003-06-27 16:00:00	SPY	ETF	97.85	97.892	97.58	97.65	1184800.0
2003-06-27 16:30:00	SPY	ETF	97.67	97.88	97.62	97.67	804100.0
2003-06-27 17:00:00	SPY	ETF	97.67	97.67	97.64	97.64	8700.0
2003-06-27 17:30:00	SPY	ETF	97.64	97.64	97.64	97.64	100.0
2003-06-27 18:00:00	SPY	ETF	97.63	97.7	97.63	97.64	1100.0
2003-06-27 18:30:00	SPY	ETF	97.71	97.71	97.71	97.71	2400.0
2003-06-27 19:00:00	SPY	ETF	97.71	97.73	97.71	97.72	1800.0
2003-06-27 19:30:00	SPY	ETF	97.72	97.72	97.72	97.72	700.0
2003-06-27 08:00:00	QQQ	ETF	30.28	30.29	30.25	30.28	19600.0
2003-06-27 08:30:00	QQQ	ETF	30.3	30.3	30.26	30.29	102500.0
2003-06-27 09:00:00	QQQ	ETF	30.28	30.29	30.25	30.28	94300.0
2003-06-27 09:30:00	QQQ	ETF	30.25	30.39	30.16	30.24	8908200.0
2003-06-27 10:00:00	QQQ	ETF	30.238	30.48	30.2	30.456	7266100.0
2003-06-27 10:30:00	QQQ	ETF	30.456	30.55	30.38	30.53	5248100.0
2003-06-27 11:00:00	QQQ	ETF	30.55	30.57	30.43	30.43	3371800.0
2003-06-27 11:30:00	QQQ	ETF	30.45	30.48	30.292	30.33	4289700.0
2003-06-27 12:00:00	QQQ	ETF	30.334	30.39	30.29	30.359	3453400.0
2003-06-27 12:30:00	QQQ	ETF	30.35	30.43	30.27	30.31	4514700.0
2003-06-27 13:00:00	QQQ	ETF	30.32	30.36	30.2	30.24	3274400.0
2003-06-27 13:30:00	QQQ	ETF	30.26	30.27	29.772	29.98	13146900.0
2003-06-27 14:00:00	QQQ	ETF	29.97	30.05	29.9	29.99	3389900.0
2003-06-27 14:30:00	QQQ	ETF	29.97	30.09	29.96	30.03	3310500.0
2003-06-27 15:00:00	QQQ	ETF	30.02	30.05	29.83	29.958	5018400.0
2003-06-27 15:30:00	QQQ	ETF	29.96	30.05	29.9	30.0	5716800.0
2003-06-27 16:00:00	QQQ	ETF	29.98	29.99	29.81	29.88	1658400.0
2003-06-27 16:30:00	QQQ	ETF	29.89	29.909	29.86	29.87	20000.0
2003-06-27 17:00:00	QQQ	ETF	29.86	29.89	29.85	29.89	119800.0
2003-06-27 17:30:00	QQQ	ETF	29.87	29.91	29.86	29.9	20300.0
2003-06-27 18:00:00	QQQ	ETF	29.9	29.93	29.88	29.92	73500.0
2003-06-27 18:30:00	QQQ	ETF	29.92	29.92	29.9	29.9	6000.0
2003-06-27 19:00:00	QQQ	ETF	29.91	29.92	29.91	29.92	10300.0
2003-06-27 19:30:00	QQQ	ETF	29.91	29.92	29.89	29.9	5800.0
2003-06-27 09:30:00	IWM	ETF	45.0	45.195	44.96	45.17	477200.0
2003-06-27 10:00:00	IWM	ETF	45.17	45.435	45.105	45.425	777600.0

> showing 50 of 685 rows — these rows as CSV

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