PREVIEW / etf_30min / 2007-09-06

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-09-06.parquet
  size:    122 KB
  rows:    4,575

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
2007-09-06 04:30:00	SPY	ETF	148.1	148.1	148.1	148.1	2000.0
2007-09-06 05:30:00	SPY	ETF	147.88	147.88	147.88	147.88	2000.0
2007-09-06 06:00:00	SPY	ETF	147.65	147.65	147.35	147.35	98500.0
2007-09-06 06:30:00	SPY	ETF	147.45	147.6	147.45	147.6	9500.0
2007-09-06 07:00:00	SPY	ETF	147.58	147.58	147.16	147.25	585000.0
2007-09-06 07:30:00	SPY	ETF	147.3	147.58	147.17	147.33	430800.0
2007-09-06 08:00:00	SPY	ETF	148.25	148.25	147.21	147.6	1288300.0
2007-09-06 08:30:00	SPY	ETF	147.6	148.01	147.55	147.88	3804900.0
2007-09-06 09:00:00	SPY	ETF	147.89	148.17	147.87	147.95	2007451.0
2007-09-06 09:30:00	SPY	ETF	147.95	148.24	147.48	147.61	14857705.0
2007-09-06 10:00:00	SPY	ETF	147.61	147.74	147.12	147.37	12747100.0
2007-09-06 10:30:00	SPY	ETF	147.38	147.91	147.29	147.78	9901300.0
2007-09-06 11:00:00	SPY	ETF	147.78	148.09	147.49	148.02	6107100.0
2007-09-06 11:30:00	SPY	ETF	148.02	148.38	148.02	148.18	11399600.0
2007-09-06 12:00:00	SPY	ETF	148.18	148.61	147.99	148.44	10209400.0
2007-09-06 12:30:00	SPY	ETF	148.44	148.47	147.93	148.24	6911200.0
2007-09-06 13:00:00	SPY	ETF	148.25	148.26	147.76	147.91	5852300.0
2007-09-06 13:30:00	SPY	ETF	147.92	148.12	147.78	148.1	5105000.0
2007-09-06 14:00:00	SPY	ETF	148.1	148.27	147.85	148.08	5979100.0
2007-09-06 14:30:00	SPY	ETF	148.08	148.25	147.96	148.19	7349700.0
2007-09-06 15:00:00	SPY	ETF	148.19	148.43	148.01	148.14	8975600.0
2007-09-06 15:30:00	SPY	ETF	148.14	148.34	148.03	148.27	8792000.0
2007-09-06 16:00:00	SPY	ETF	148.27	148.28	148.08	148.1	2114500.0
2007-09-06 16:30:00	SPY	ETF	148.11	148.14	148.05	148.08	520300.0
2007-09-06 17:00:00	SPY	ETF	148.08	148.18	148.08	148.17	64000.0
2007-09-06 17:30:00	SPY	ETF	148.12	148.12	148.07	148.07	5400.0
2007-09-06 18:00:00	SPY	ETF	148.16	148.16	147.99	147.99	47600.0
2007-09-06 18:30:00	SPY	ETF	147.99	148.15	147.99	148.15	26400.0
2007-09-06 19:00:00	SPY	ETF	148.05	148.05	148.05	148.05	700.0
2007-09-06 19:30:00	SPY	ETF	148.05	148.06	148.05	148.06	3100.0
2007-09-06 04:00:00	QQQ	ETF	49.26	49.26	49.26	49.26	500.0
2007-09-06 04:30:00	QQQ	ETF	49.25	49.25	49.25	49.25	100.0
2007-09-06 06:00:00	QQQ	ETF	49.23	49.23	49.23	49.23	100.0
2007-09-06 07:00:00	QQQ	ETF	49.06	49.13	49.0	49.0	70540.0
2007-09-06 07:30:00	QQQ	ETF	49.02	49.09	48.99	48.99	16360.0
2007-09-06 08:00:00	QQQ	ETF	49.02	49.07	48.99	49.06	1266270.0
2007-09-06 08:30:00	QQQ	ETF	49.07	49.18	49.06	49.17	2003431.0
2007-09-06 09:00:00	QQQ	ETF	49.18	49.35	49.18	49.24	1084462.0
2007-09-06 09:30:00	QQQ	ETF	49.23	49.36	49.0	49.02	12159482.0
2007-09-06 10:00:00	QQQ	ETF	49.02	49.07	48.81	48.9185	9753300.0
2007-09-06 10:30:00	QQQ	ETF	48.91	49.11	48.88	49.03	6261157.0
2007-09-06 11:00:00	QQQ	ETF	49.04	49.17	48.98	49.13	4475934.0
2007-09-06 11:30:00	QQQ	ETF	49.14	49.26	49.13	49.22	5902727.0
2007-09-06 12:00:00	QQQ	ETF	49.2211	49.35	49.14	49.28	4942539.0
2007-09-06 12:30:00	QQQ	ETF	49.29	49.3	49.09	49.19	7718074.0
2007-09-06 13:00:00	QQQ	ETF	49.19	49.22	49.0105	49.09	2917359.0
2007-09-06 13:30:00	QQQ	ETF	49.1	49.17	49.05	49.17	3348489.0
2007-09-06 14:00:00	QQQ	ETF	49.1614	49.21	49.07	49.14	2665639.0
2007-09-06 14:30:00	QQQ	ETF	49.14	49.24	49.11	49.24	3029118.0
2007-09-06 15:00:00	QQQ	ETF	49.25	49.35	49.15	49.18	5016156.0

> showing 50 of 4,575 rows — these rows as CSV

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