PREVIEW / etf_30min / 2011-12-06

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-12-06.parquet
  size:    276 KB
  rows:    9,308

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
2011-12-06 04:00:00	SPY	ETF	126.32	126.32	125.89	125.89	20585.0
2011-12-06 04:30:00	SPY	ETF	125.89	126.1	125.76	126.1	11700.0
2011-12-06 05:00:00	SPY	ETF	126.15	126.39	126.11	126.39	6600.0
2011-12-06 05:30:00	SPY	ETF	126.38	126.69	126.38	126.69	6400.0
2011-12-06 06:00:00	SPY	ETF	126.66	126.66	126.5	126.5	42700.0
2011-12-06 06:30:00	SPY	ETF	126.4	126.5	126.3	126.5	90340.0
2011-12-06 07:00:00	SPY	ETF	126.5	126.64	126.32	126.5	389518.0
2011-12-06 07:30:00	SPY	ETF	126.52	126.54	126.24	126.3	189810.0
2011-12-06 08:00:00	SPY	ETF	126.3	126.48	126.1	126.16	1481074.0
2011-12-06 08:30:00	SPY	ETF	126.1	126.34	125.98	126.11	1907050.0
2011-12-06 09:00:00	SPY	ETF	126.11	126.35	126.01	126.21	1937964.0
2011-12-06 09:30:00	SPY	ETF	126.21	126.42	125.76	126.01	18300819.0
2011-12-06 10:00:00	SPY	ETF	126.0	126.45	125.96	126.39	12135182.0
2011-12-06 10:30:00	SPY	ETF	126.4	126.56	126.08	126.12	12659783.0
2011-12-06 11:00:00	SPY	ETF	126.13	126.27	126.01	126.07	6752660.0
2011-12-06 11:30:00	SPY	ETF	126.09	126.28	125.83	126.18	8193385.0
2011-12-06 12:00:00	SPY	ETF	126.17	126.27	126.01	126.14	4783265.0
2011-12-06 12:30:00	SPY	ETF	126.13	126.25	126.04	126.13	3392476.0
2011-12-06 13:00:00	SPY	ETF	126.14	126.45	125.99	126.4	13021004.0
2011-12-06 13:30:00	SPY	ETF	126.41	126.45	126.24	126.2509	4099229.0
2011-12-06 14:00:00	SPY	ETF	126.2508	126.43	126.14	126.36	6950084.0
2011-12-06 14:30:00	SPY	ETF	126.35	127.02	126.34	126.89	15223488.0
2011-12-06 15:00:00	SPY	ETF	126.89	127.11	126.63	126.64	13361216.0
2011-12-06 15:30:00	SPY	ETF	126.64	126.85	126.3	126.31	20830705.0
2011-12-06 16:00:00	SPY	ETF	126.31	126.5354	126.01	126.18	17631411.0
2011-12-06 16:30:00	SPY	ETF	126.18	126.26	126.12	126.24	4520701.0
2011-12-06 17:00:00	SPY	ETF	126.21	126.21	126.13	126.15	207313.0
2011-12-06 17:30:00	SPY	ETF	126.15	126.2	126.13	126.16	50616.0
2011-12-06 18:00:00	SPY	ETF	126.15	126.32	126.04	126.23	157986.0
2011-12-06 18:30:00	SPY	ETF	126.23	126.33	126.18	126.27	81517.0
2011-12-06 19:00:00	SPY	ETF	126.29	126.34	126.22	126.31	155957.0
2011-12-06 19:30:00	SPY	ETF	126.31	126.48	126.29	126.47	254555.0
2011-12-06 04:00:00	QQQ	ETF	57.35	57.35	57.35	57.35	500.0
2011-12-06 05:00:00	QQQ	ETF	57.35	57.35	57.35	57.35	3575.0
2011-12-06 05:30:00	QQQ	ETF	57.41	57.54	57.41	57.54	5900.0
2011-12-06 06:00:00	QQQ	ETF	57.53	57.53	57.5	57.5	1446.0
2011-12-06 06:30:00	QQQ	ETF	57.42	57.42	57.42	57.42	600.0
2011-12-06 07:00:00	QQQ	ETF	57.51	57.52	57.41	57.48	12300.0
2011-12-06 07:30:00	QQQ	ETF	57.45	57.48	57.33	57.37	128200.0
2011-12-06 08:00:00	QQQ	ETF	57.34	57.41	57.24	57.27	879393.0
2011-12-06 08:30:00	QQQ	ETF	57.25	57.27	57.18	57.24	58503.0
2011-12-06 09:00:00	QQQ	ETF	57.24	57.35	57.23	57.28	540060.0
2011-12-06 09:30:00	QQQ	ETF	57.28	57.45	57.17	57.255	3100185.0
2011-12-06 10:00:00	QQQ	ETF	57.26	57.3874	57.0875	57.2399	2556241.0
2011-12-06 10:30:00	QQQ	ETF	57.24	57.31	57.06	57.08	3313823.0
2011-12-06 11:00:00	QQQ	ETF	57.08	57.15	57.03	57.03	1707266.0
2011-12-06 11:30:00	QQQ	ETF	57.04	57.08	56.89	57.03	2731067.0
2011-12-06 12:00:00	QQQ	ETF	57.03	57.09	56.95	56.98	2327629.0
2011-12-06 12:30:00	QQQ	ETF	56.99	57.03	56.93	56.99	909035.0
2011-12-06 13:00:00	QQQ	ETF	57.0	57.11	56.9175	57.09	1363450.0

> showing 50 of 9,308 rows — these rows as CSV

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