PREVIEW / etf_30min / 2011-06-16

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-06-16.parquet
  size:    288 KB
  rows:    9,526

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-06-16 04:00:00	SPY	ETF	127.0	127.46	127.0	127.43	16504.0
2011-06-16 04:30:00	SPY	ETF	127.43	127.43	127.35	127.35	1048.0
2011-06-16 05:00:00	SPY	ETF	127.1	127.1	126.9	126.96	5100.0
2011-06-16 05:30:00	SPY	ETF	126.85	127.12	126.76	126.95	8200.0
2011-06-16 06:00:00	SPY	ETF	126.92	126.97	126.84	126.95	16600.0
2011-06-16 06:30:00	SPY	ETF	126.9	127.08	126.82	127.04	32155.0
2011-06-16 07:00:00	SPY	ETF	127.01	127.15	126.76	126.85	244846.0
2011-06-16 07:30:00	SPY	ETF	126.81	126.82	126.48	126.5	626247.0
2011-06-16 08:00:00	SPY	ETF	126.48	126.71	126.44	126.65	1250386.0
2011-06-16 08:30:00	SPY	ETF	126.65	127.25	126.63	127.21	3812488.0
2011-06-16 09:00:00	SPY	ETF	127.2	127.39	126.91	127.09	4429302.0
2011-06-16 09:30:00	SPY	ETF	127.06	127.54	126.97	127.27	27378393.0
2011-06-16 10:00:00	SPY	ETF	127.29	127.75	126.67	127.41	38630847.0
2011-06-16 10:30:00	SPY	ETF	127.42	127.87	127.36	127.65	21064797.0
2011-06-16 11:00:00	SPY	ETF	127.641	127.95	127.3	127.8	21649463.0
2011-06-16 11:30:00	SPY	ETF	127.8	127.97	127.53	127.61	16634104.0
2011-06-16 12:00:00	SPY	ETF	127.61	127.86	127.56	127.83	8730844.0
2011-06-16 12:30:00	SPY	ETF	127.82	127.86	127.56	127.56	6889973.0
2011-06-16 13:00:00	SPY	ETF	127.57	127.71	127.43	127.46	13571176.0
2011-06-16 13:30:00	SPY	ETF	127.465	127.48	126.85	126.86	16950145.0
2011-06-16 14:00:00	SPY	ETF	126.86	127.0757	126.69	126.86	16482289.0
2011-06-16 14:30:00	SPY	ETF	126.86	126.89	126.32	126.73	19525740.0
2011-06-16 15:00:00	SPY	ETF	126.72	127.07	126.66	126.96	18001315.0
2011-06-16 15:30:00	SPY	ETF	126.96	127.39	126.93	127.3	35152877.0
2011-06-16 16:00:00	SPY	ETF	127.31	127.5	126.46	127.46	18764677.0
2011-06-16 16:30:00	SPY	ETF	127.45	127.6	126.86	127.55	7733922.0
2011-06-16 17:00:00	SPY	ETF	127.57	127.57	126.7647	127.5	229258.0
2011-06-16 17:30:00	SPY	ETF	127.5	127.51	127.47	127.51	55685.0
2011-06-16 18:00:00	SPY	ETF	127.52	127.62	127.28	127.57	113668.0
2011-06-16 18:30:00	SPY	ETF	127.58	127.79	127.58	127.77	60697.0
2011-06-16 19:00:00	SPY	ETF	127.75	127.88	127.72	127.84	104487.0
2011-06-16 19:30:00	SPY	ETF	127.82	127.84	127.78	127.83	40800.0
2011-06-16 05:30:00	QQQ	ETF	54.15	54.15	54.15	54.15	100.0
2011-06-16 06:00:00	QQQ	ETF	54.18	54.18	54.18	54.18	600.0
2011-06-16 06:30:00	QQQ	ETF	54.27	54.3	54.27	54.3	1640.0
2011-06-16 07:00:00	QQQ	ETF	54.27	54.27	54.2	54.23	85700.0
2011-06-16 07:30:00	QQQ	ETF	54.21	54.21	54.09	54.12	22886.0
2011-06-16 08:00:00	QQQ	ETF	54.1	54.28	54.07	54.28	153519.0
2011-06-16 08:30:00	QQQ	ETF	54.13	54.41	54.13	54.38	291570.0
2011-06-16 09:00:00	QQQ	ETF	54.37	54.41	54.24	54.32	248541.0
2011-06-16 09:30:00	QQQ	ETF	54.32	54.36	54.22	54.33	5675736.0
2011-06-16 10:00:00	QQQ	ETF	54.32	54.47	54.13	54.34	7256282.0
2011-06-16 10:30:00	QQQ	ETF	54.35	54.5	54.31	54.395	2258581.0
2011-06-16 11:00:00	QQQ	ETF	54.39	54.48	54.27	54.4499	4024381.0
2011-06-16 11:30:00	QQQ	ETF	54.45	54.5	54.33	54.35	2527711.0
2011-06-16 12:00:00	QQQ	ETF	54.35	54.415	54.34	54.395	1423556.0
2011-06-16 12:30:00	QQQ	ETF	54.4	54.4199	54.33	54.35	1091470.0
2011-06-16 13:00:00	QQQ	ETF	54.3473	54.3889	54.2901	54.31	1857920.0
2011-06-16 13:30:00	QQQ	ETF	54.31	54.33	54.07	54.08	3798301.0
2011-06-16 14:00:00	QQQ	ETF	54.08	54.13	53.931	53.98	4224824.0

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

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