PREVIEW / etf_30min / 2008-06-25

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-06-25.parquet
  size:    168 KB
  rows:    5,811

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-06-25 04:00:00	SPY	ETF	131.84	131.84	131.84	131.84	200.0
2008-06-25 05:30:00	SPY	ETF	132.0	132.0	132.0	132.0	100.0
2008-06-25 06:00:00	SPY	ETF	131.92	131.97	131.9	131.93	33000.0
2008-06-25 06:30:00	SPY	ETF	131.94	132.02	131.92	131.94	71500.0
2008-06-25 07:00:00	SPY	ETF	131.91	132.08	131.82	131.99	953593.0
2008-06-25 07:30:00	SPY	ETF	131.95	132.0	131.86	131.88	511868.0
2008-06-25 08:00:00	SPY	ETF	131.89	132.08	131.78	131.9	1645086.0
2008-06-25 08:30:00	SPY	ETF	131.91	132.05	131.83	131.9	2006486.0
2008-06-25 09:00:00	SPY	ETF	131.91	131.95	131.68	131.71	1346582.0
2008-06-25 09:30:00	SPY	ETF	131.72	132.35	131.62	132.17	21690911.0
2008-06-25 10:00:00	SPY	ETF	132.17	132.38	131.94	132.04	12421018.0
2008-06-25 10:30:00	SPY	ETF	132.05	132.73	132.01	132.56	24102430.0
2008-06-25 11:00:00	SPY	ETF	132.56	132.65	132.44	132.58	9119681.0
2008-06-25 11:30:00	SPY	ETF	132.59	132.675	132.36	132.49	9685545.0
2008-06-25 12:00:00	SPY	ETF	132.49	132.51	132.36	132.48	4356434.0
2008-06-25 12:30:00	SPY	ETF	132.48	132.58	132.28	132.36	5298558.0
2008-06-25 13:00:00	SPY	ETF	132.36	132.57	132.31	132.37	5979996.0
2008-06-25 13:30:00	SPY	ETF	132.38	132.45	132.28	132.32	7697711.0
2008-06-25 14:00:00	SPY	ETF	132.33	133.1	131.92	132.47	43226664.0
2008-06-25 14:30:00	SPY	ETF	132.47	132.95	132.13	132.83	35192307.0
2008-06-25 15:00:00	SPY	ETF	132.83	133.4	132.3	132.53	33388032.0
2008-06-25 15:30:00	SPY	ETF	132.54	132.55	131.74	132.0	46839610.0
2008-06-25 16:00:00	SPY	ETF	132.01	132.5	131.8	131.85	6245067.0
2008-06-25 16:30:00	SPY	ETF	131.87	131.88	131.2391	131.61	9381904.0
2008-06-25 17:00:00	SPY	ETF	131.59	132.2466	131.22	131.42	2431842.0
2008-06-25 17:30:00	SPY	ETF	131.29	131.3	131.16	131.29	35752.0
2008-06-25 18:00:00	SPY	ETF	131.3	131.4	131.3	131.39	31381.0
2008-06-25 18:30:00	SPY	ETF	131.37	131.45	131.35	131.38	7652.0
2008-06-25 19:00:00	SPY	ETF	131.35	131.46	131.35	131.46	16329.0
2008-06-25 19:30:00	SPY	ETF	131.48	131.56	131.46	131.54	25304.0
2008-06-25 04:00:00	QQQ	ETF	47.04	47.04	47.04	47.04	200.0
2008-06-25 05:30:00	QQQ	ETF	47.06	47.06	47.06	47.06	1000.0
2008-06-25 06:30:00	QQQ	ETF	47.07	47.14	47.06	47.14	2300.0
2008-06-25 07:00:00	QQQ	ETF	47.11	47.24	47.07	47.16	662694.0
2008-06-25 07:30:00	QQQ	ETF	47.19	47.22	47.14	47.15	731816.0
2008-06-25 08:00:00	QQQ	ETF	47.15	47.23	47.09	47.12	3911458.0
2008-06-25 08:30:00	QQQ	ETF	47.11	47.22	47.11	47.17	2274150.0
2008-06-25 09:00:00	QQQ	ETF	47.17	47.21	46.97	46.99	2251751.0
2008-06-25 09:30:00	QQQ	ETF	47.0	47.35	46.94	47.25	16670520.0
2008-06-25 10:00:00	QQQ	ETF	47.25	47.31	47.14	47.22	5515305.0
2008-06-25 10:30:00	QQQ	ETF	47.22	47.66	47.1	47.58	15014462.0
2008-06-25 11:00:00	QQQ	ETF	47.59	47.65	47.52	47.5897	5330207.0
2008-06-25 11:30:00	QQQ	ETF	47.59	47.62	47.46	47.58	5959091.0
2008-06-25 12:00:00	QQQ	ETF	47.57	47.63	47.5	47.61	3477031.0
2008-06-25 12:30:00	QQQ	ETF	47.602	47.65	47.53	47.58	2835442.0
2008-06-25 13:00:00	QQQ	ETF	47.57	47.63	47.52	47.54	2728426.0
2008-06-25 13:30:00	QQQ	ETF	47.54	47.5678	47.45	47.47	3591256.0
2008-06-25 14:00:00	QQQ	ETF	47.47	47.8	47.46	47.5401	20054299.0
2008-06-25 14:30:00	QQQ	ETF	47.55	47.76	47.36	47.72	23468397.0
2008-06-25 15:00:00	QQQ	ETF	47.73	48.0	47.57	47.68	20720428.0

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

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