PREVIEW / etf_30min / 2008-07-31

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-07-31.parquet
  size:    170 KB
  rows:    5,910

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
2008-07-31 04:00:00	SPY	ETF	128.25	128.25	128.25	128.25	200.0
2008-07-31 04:30:00	SPY	ETF	128.26	128.26	128.26	128.26	7383.0
2008-07-31 05:00:00	SPY	ETF	128.29	128.29	128.29	128.29	7600.0
2008-07-31 05:30:00	SPY	ETF	128.26	128.3	128.26	128.3	15000.0
2008-07-31 06:00:00	SPY	ETF	128.37	128.49	128.37	128.49	10300.0
2008-07-31 06:30:00	SPY	ETF	128.58	128.58	128.55	128.55	2000.0
2008-07-31 07:00:00	SPY	ETF	128.47	128.83	128.47	128.76	692353.0
2008-07-31 07:30:00	SPY	ETF	128.75	128.88	128.71	128.83	521143.0
2008-07-31 08:00:00	SPY	ETF	128.85	129.08	128.65	128.94	1338917.0
2008-07-31 08:30:00	SPY	ETF	128.98	128.98	127.56	127.58	11844588.0
2008-07-31 09:00:00	SPY	ETF	127.58	127.66	127.24	127.37	4512072.0
2008-07-31 09:30:00	SPY	ETF	127.4	128.4787	127.24	128.05	41833845.0
2008-07-31 10:00:00	SPY	ETF	128.05	128.53	127.74	128.38	31789944.0
2008-07-31 10:30:00	SPY	ETF	128.37	128.57	128.0	128.56	17654764.0
2008-07-31 11:00:00	SPY	ETF	128.55	128.57	127.87	127.89	15168545.0
2008-07-31 11:30:00	SPY	ETF	127.89	128.53	127.61	127.8	13213497.0
2008-07-31 12:00:00	SPY	ETF	127.805	127.86	127.17	127.38	17578553.0
2008-07-31 12:30:00	SPY	ETF	127.38	127.73	127.31	127.56	13118208.0
2008-07-31 13:00:00	SPY	ETF	127.56	128.02	127.3	127.81	11441409.0
2008-07-31 13:30:00	SPY	ETF	127.8	127.98	127.58	127.61	10152693.0
2008-07-31 14:00:00	SPY	ETF	127.61	128.08	127.58	127.72	11599130.0
2008-07-31 14:30:00	SPY	ETF	127.71	128.35	127.71	128.03	16970952.0
2008-07-31 15:00:00	SPY	ETF	128.04	128.23	127.65	127.67	14747108.0
2008-07-31 15:30:00	SPY	ETF	127.68	127.71	126.63	126.84	35803719.0
2008-07-31 16:00:00	SPY	ETF	126.8	127.8081	126.6	126.75	4812853.0
2008-07-31 16:30:00	SPY	ETF	126.75	127.33	126.75	126.84	280599.0
2008-07-31 17:00:00	SPY	ETF	126.87	126.87	126.81	126.81	31038.0
2008-07-31 17:30:00	SPY	ETF	126.81	126.83	126.8	126.8	15800.0
2008-07-31 18:00:00	SPY	ETF	126.81	126.84	126.74	126.82	104721.0
2008-07-31 18:30:00	SPY	ETF	126.8	126.87	126.8	126.84	17840.0
2008-07-31 19:00:00	SPY	ETF	126.87	126.9	126.86	126.9	6800.0
2008-07-31 19:30:00	SPY	ETF	126.88	126.91	126.87	126.91	17001.0
2008-07-31 05:00:00	QQQ	ETF	45.49	45.49	45.49	45.49	100.0
2008-07-31 06:30:00	QQQ	ETF	45.59	45.59	45.59	45.59	100.0
2008-07-31 07:00:00	QQQ	ETF	45.63	45.73	45.63	45.72	70800.0
2008-07-31 07:30:00	QQQ	ETF	45.72	45.73	45.71	45.71	30250.0
2008-07-31 08:00:00	QQQ	ETF	45.72	45.81	45.66	45.66	719000.0
2008-07-31 08:30:00	QQQ	ETF	45.71	45.71	45.17	45.18	4459147.0
2008-07-31 09:00:00	QQQ	ETF	45.18	45.19	45.0	45.11	2030083.0
2008-07-31 09:30:00	QQQ	ETF	45.11	45.86	45.02	45.76	31659297.0
2008-07-31 10:00:00	QQQ	ETF	45.75	46.15	45.63	46.05	22173300.0
2008-07-31 10:30:00	QQQ	ETF	46.05	46.07	45.9	46.04	14091450.0
2008-07-31 11:00:00	QQQ	ETF	46.048	46.07	45.83	45.84	9149265.0
2008-07-31 11:30:00	QQQ	ETF	45.84	45.88	45.71	45.82	9262847.0
2008-07-31 12:00:00	QQQ	ETF	45.82	45.88	45.52	45.658	11147215.0
2008-07-31 12:30:00	QQQ	ETF	45.64	45.9	45.61	45.78	7850236.0
2008-07-31 13:00:00	QQQ	ETF	45.78	45.99	45.78	45.859	6962701.0
2008-07-31 13:30:00	QQQ	ETF	45.85	45.98	45.82	45.83	5810323.0
2008-07-31 14:00:00	QQQ	ETF	45.83	46.01	45.81	45.86	7048259.0
2008-07-31 14:30:00	QQQ	ETF	45.85	46.07	45.84	45.93	9195146.0

> showing 50 of 5,910 rows — these rows as CSV

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