PREVIEW / etf_30min / 2005-08-02

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-08-02.parquet
  size:    45 KB
  rows:    1,627

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-08-02 07:00:00	SPY	ETF	123.93	123.93	123.93	123.93	200.0
2005-08-02 07:30:00	SPY	ETF	123.83	123.83	123.81	123.81	51000.0
2005-08-02 08:00:00	SPY	ETF	123.81	123.85	123.8	123.85	98000.0
2005-08-02 08:30:00	SPY	ETF	123.86	123.93	123.79	123.9	1424900.0
2005-08-02 09:00:00	SPY	ETF	123.87	123.89	123.65	123.88	94800.0
2005-08-02 09:30:00	SPY	ETF	123.87	124.03	123.74	124.0	5377900.0
2005-08-02 10:00:00	SPY	ETF	123.99	124.4	123.93	124.23	10334300.0
2005-08-02 10:30:00	SPY	ETF	124.24	124.41	124.21	124.24	3344900.0
2005-08-02 11:00:00	SPY	ETF	124.22	124.32	124.18	124.26	1927100.0
2005-08-02 11:30:00	SPY	ETF	124.26	124.48	124.22	124.38	1953500.0
2005-08-02 12:00:00	SPY	ETF	124.38	124.56	124.34	124.48	2341500.0
2005-08-02 12:30:00	SPY	ETF	124.47	124.48	124.27	124.34	1478100.0
2005-08-02 13:00:00	SPY	ETF	124.33	124.36	124.25	124.36	1139200.0
2005-08-02 13:30:00	SPY	ETF	124.33	124.39	124.18	124.2	2936700.0
2005-08-02 14:00:00	SPY	ETF	124.2	124.46	124.18	124.32	1723000.0
2005-08-02 14:30:00	SPY	ETF	124.32	124.46	124.23	124.36	2405400.0
2005-08-02 15:00:00	SPY	ETF	124.37	124.42	124.21	124.4	1819000.0
2005-08-02 15:30:00	SPY	ETF	124.4	124.6	124.35	124.46	4403900.0
2005-08-02 16:00:00	SPY	ETF	124.45	124.47	124.36	124.39	962800.0
2005-08-02 16:30:00	SPY	ETF	124.37	124.37	124.26	124.33	51600.0
2005-08-02 17:00:00	SPY	ETF	124.35	124.35	124.34	124.34	20100.0
2005-08-02 17:30:00	SPY	ETF	124.32	124.32	124.31	124.31	600.0
2005-08-02 18:00:00	SPY	ETF	124.34	124.36	124.34	124.35	5600.0
2005-08-02 18:30:00	SPY	ETF	124.39	124.4	124.32	124.32	24100.0
2005-08-02 19:00:00	SPY	ETF	124.33	124.33	124.33	124.33	500.0
2005-08-02 19:30:00	SPY	ETF	124.36	124.36	124.36	124.36	600.0
2005-08-02 09:30:00	QQQ	ETF	39.71	39.8	39.65	39.76	8953100.0
2005-08-02 10:00:00	QQQ	ETF	39.77	39.91	39.73	39.87	10176600.0
2005-08-02 10:30:00	QQQ	ETF	39.87	40.1	39.85	39.99	12457600.0
2005-08-02 11:00:00	QQQ	ETF	39.99	40.02	39.95	40.0	4288200.0
2005-08-02 11:30:00	QQQ	ETF	40.0	40.08	39.98	40.07	3455700.0
2005-08-02 12:00:00	QQQ	ETF	40.07	40.12	39.85	40.09	4868900.0
2005-08-02 12:30:00	QQQ	ETF	40.08	40.1	40.03	40.04	2428500.0
2005-08-02 13:00:00	QQQ	ETF	40.04	40.05	40.0	40.05	2688700.0
2005-08-02 13:30:00	QQQ	ETF	40.04	40.08	39.98	40.0	3949800.0
2005-08-02 14:00:00	QQQ	ETF	40.01	40.1	39.99	40.02	3314200.0
2005-08-02 14:30:00	QQQ	ETF	40.01	40.07	39.99	40.04	3202200.0
2005-08-02 15:00:00	QQQ	ETF	40.03	40.08	39.85	40.06	3134100.0
2005-08-02 15:30:00	QQQ	ETF	40.07	40.14	40.05	40.07	8127900.0
2005-08-02 08:30:00	IWM	ETF	67.99	68.05	67.8	67.8	1900.0
2005-08-02 09:00:00	IWM	ETF	68.03	68.04	68.02	68.04	1000.0
2005-08-02 09:30:00	IWM	ETF	68.03	68.26	68.0	68.18	1177700.0
2005-08-02 10:00:00	IWM	ETF	68.19	68.42	68.1	68.28	1906500.0
2005-08-02 10:30:00	IWM	ETF	68.27	68.4	68.19	68.22	1139300.0
2005-08-02 11:00:00	IWM	ETF	68.23	68.24	68.0	68.08	1631500.0
2005-08-02 11:30:00	IWM	ETF	68.08	68.3	68.07	68.23	1411000.0
2005-08-02 12:00:00	IWM	ETF	68.24	68.38	68.17	68.31	889100.0
2005-08-02 12:30:00	IWM	ETF	68.32	68.32	68.19	68.21	680100.0
2005-08-02 13:00:00	IWM	ETF	68.22	68.31	68.17	68.25	316200.0
2005-08-02 13:30:00	IWM	ETF	68.26	68.31	68.13	68.21	796200.0

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

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