PREVIEW / etf_30min / 2014-09-12

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-09-12.parquet
  size:    345 KB
  rows:    11,546

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
2014-09-12 04:00:00	SPY	ETF	200.24	200.24	200.21	200.24	1500.0
2014-09-12 04:30:00	SPY	ETF	200.18	200.25	200.15	200.15	15588.0
2014-09-12 05:00:00	SPY	ETF	200.15	200.2	200.15	200.2	10700.0
2014-09-12 05:30:00	SPY	ETF	200.19	200.27	200.19	200.26	7135.0
2014-09-12 06:00:00	SPY	ETF	200.27	200.33	200.24	200.24	8766.0
2014-09-12 06:30:00	SPY	ETF	200.29	200.35	200.27	200.27	13101.0
2014-09-12 07:00:00	SPY	ETF	200.27	200.35	200.26	200.26	45901.0
2014-09-12 07:30:00	SPY	ETF	200.28	200.44	200.25	200.33	171627.0
2014-09-12 08:00:00	SPY	ETF	200.25	200.36	200.13	200.22	327811.0
2014-09-12 08:30:00	SPY	ETF	200.21	200.26	200.04	200.18	439048.0
2014-09-12 09:00:00	SPY	ETF	200.18	200.27	200.06	200.11	263625.0
2014-09-12 09:30:00	SPY	ETF	200.1	200.12	199.5	199.54	9523555.0
2014-09-12 10:00:00	SPY	ETF	199.54	199.87	199.22	199.72	10091854.0
2014-09-12 10:30:00	SPY	ETF	199.73	199.91	199.49	199.835	4854045.0
2014-09-12 11:00:00	SPY	ETF	199.83	199.86	199.53	199.6	5180680.0
2014-09-12 11:30:00	SPY	ETF	199.6	199.631	199.28	199.47	5172309.0
2014-09-12 12:00:00	SPY	ETF	199.47	199.55	199.3	199.43	4593445.0
2014-09-12 12:30:00	SPY	ETF	199.43	199.43	199.06	199.18	6250881.0
2014-09-12 13:00:00	SPY	ETF	199.18	199.28	198.76	198.92	6513531.0
2014-09-12 13:30:00	SPY	ETF	198.92	199.02	198.71	198.92	7278008.0
2014-09-12 14:00:00	SPY	ETF	198.92	199.18	198.84	198.84	9042660.0
2014-09-12 14:30:00	SPY	ETF	198.84	198.94	198.56	198.69	5765223.0
2014-09-12 15:00:00	SPY	ETF	198.686	199.2	198.58	199.075	6754427.0
2014-09-12 15:30:00	SPY	ETF	199.075	199.19	198.92	199.1299	13212272.0
2014-09-12 16:00:00	SPY	ETF	199.12	200.3032	199.05	199.06	8012818.0
2014-09-12 16:30:00	SPY	ETF	199.06	200.3032	199.02	199.03	3717894.0
2014-09-12 17:00:00	SPY	ETF	199.03	199.03	198.99	199.03	68744.0
2014-09-12 17:30:00	SPY	ETF	199.02	199.03	198.98	198.98	12921.0
2014-09-12 18:00:00	SPY	ETF	198.98	198.99	198.9	198.92	27414.0
2014-09-12 18:30:00	SPY	ETF	198.91	198.95	198.88	198.9	7050.0
2014-09-12 19:00:00	SPY	ETF	198.91	198.93	198.88	198.88	26317.0
2014-09-12 19:30:00	SPY	ETF	198.9	198.97	198.88	198.88	6714.0
2014-09-12 04:00:00	QQQ	ETF	99.99	99.99	99.99	99.99	125.0
2014-09-12 04:30:00	QQQ	ETF	99.93	99.93	99.93	99.93	10000.0
2014-09-12 06:30:00	QQQ	ETF	100.0	100.0	100.0	100.0	100.0
2014-09-12 07:00:00	QQQ	ETF	100.0	100.0	99.95	99.95	15620.0
2014-09-12 07:30:00	QQQ	ETF	99.95	100.03	99.94	99.99	12595.0
2014-09-12 08:00:00	QQQ	ETF	99.98	99.99	99.88	99.99	61016.0
2014-09-12 08:30:00	QQQ	ETF	99.95	99.97	99.87	99.95	83173.0
2014-09-12 09:00:00	QQQ	ETF	99.96	99.96	99.87	99.89	120065.0
2014-09-12 09:30:00	QQQ	ETF	99.9	99.93	99.53	99.54	3873956.0
2014-09-12 10:00:00	QQQ	ETF	99.54	99.71	99.4	99.61	2556958.0
2014-09-12 10:30:00	QQQ	ETF	99.6	99.785	99.48	99.76	2278377.0
2014-09-12 11:00:00	QQQ	ETF	99.76	99.81	99.63	99.72	1455525.0
2014-09-12 11:30:00	QQQ	ETF	99.71	99.71	99.51	99.65	1127708.0
2014-09-12 12:00:00	QQQ	ETF	99.65	99.7	99.57	99.625	905670.0
2014-09-12 12:30:00	QQQ	ETF	99.627	99.627	99.44	99.54	984345.0
2014-09-12 13:00:00	QQQ	ETF	99.54	99.6	99.33	99.4	1442154.0
2014-09-12 13:30:00	QQQ	ETF	99.4	99.44	99.27	99.39	1222969.0
2014-09-12 14:00:00	QQQ	ETF	99.39	99.56	99.35	99.39	1958614.0

> showing 50 of 11,546 rows — these rows as CSV

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