PREVIEW / etf_30min / 2014-03-06

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-03-06.parquet
  size:    335 KB
  rows:    11,383

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-03-06 04:00:00	SPY	ETF	188.26	188.26	188.14	188.14	8230.0
2014-03-06 04:30:00	SPY	ETF	188.1	188.13	188.07	188.09	27142.0
2014-03-06 05:00:00	SPY	ETF	188.09	188.1	188.05	188.07	3238.0
2014-03-06 05:30:00	SPY	ETF	188.06	188.14	188.06	188.07	1624.0
2014-03-06 06:00:00	SPY	ETF	188.11	188.15	188.01	188.04	12889.0
2014-03-06 06:30:00	SPY	ETF	188.09	188.1	187.95	188.02	9331.0
2014-03-06 07:00:00	SPY	ETF	188.0	188.14	188.0	188.13	136409.0
2014-03-06 07:30:00	SPY	ETF	188.1	188.11	187.92	188.07	181752.0
2014-03-06 08:00:00	SPY	ETF	188.04	188.24	187.99	188.14	259538.0
2014-03-06 08:30:00	SPY	ETF	188.12	188.25	187.9	188.11	812488.0
2014-03-06 09:00:00	SPY	ETF	188.12	188.32	188.09	188.2	683297.0
2014-03-06 09:30:00	SPY	ETF	188.21	188.61	188.15	188.56	10861906.0
2014-03-06 10:00:00	SPY	ETF	188.56	188.58	188.11	188.406	9589058.0
2014-03-06 10:30:00	SPY	ETF	188.4	188.53	188.3	188.47	3767684.0
2014-03-06 11:00:00	SPY	ETF	188.475	188.52	188.3305	188.3999	2822731.0
2014-03-06 11:30:00	SPY	ETF	188.39	188.52	188.37	188.5	2886162.0
2014-03-06 12:00:00	SPY	ETF	188.505	188.6	188.45	188.478	2932821.0
2014-03-06 12:30:00	SPY	ETF	188.48	188.535	188.46	188.52	2403598.0
2014-03-06 13:00:00	SPY	ETF	188.51	188.56	188.28	188.31	3254268.0
2014-03-06 13:30:00	SPY	ETF	188.32	188.37	187.93	187.97	7562190.0
2014-03-06 14:00:00	SPY	ETF	187.97	188.29	187.89	188.244	5965958.0
2014-03-06 14:30:00	SPY	ETF	188.25	188.35	188.14	188.265	4590433.0
2014-03-06 15:00:00	SPY	ETF	188.27	188.32	188.16	188.29	3572869.0
2014-03-06 15:30:00	SPY	ETF	188.295	188.42	187.99	188.18	11843371.0
2014-03-06 16:00:00	SPY	ETF	188.19	188.21	187.7796	188.13	5470276.0
2014-03-06 16:30:00	SPY	ETF	188.13	188.17	188.1	188.14	1815694.0
2014-03-06 17:00:00	SPY	ETF	188.16	188.21	188.13	188.15	31795.0
2014-03-06 17:30:00	SPY	ETF	188.17	188.18	188.1	188.1	46921.0
2014-03-06 18:00:00	SPY	ETF	188.12	188.31	188.12	188.27	87694.0
2014-03-06 18:30:00	SPY	ETF	188.29	188.34	188.24	188.26	35988.0
2014-03-06 19:00:00	SPY	ETF	188.29	188.33	188.25	188.28	37750.0
2014-03-06 19:30:00	SPY	ETF	188.28	188.3	188.22	188.24	22695.0
2014-03-06 04:00:00	QQQ	ETF	91.24	91.3	91.22	91.22	10100.0
2014-03-06 05:30:00	QQQ	ETF	91.2	91.2	91.2	91.2	100.0
2014-03-06 06:00:00	QQQ	ETF	91.21	91.21	91.21	91.21	3500.0
2014-03-06 07:00:00	QQQ	ETF	91.2	91.24	91.2	91.24	3500.0
2014-03-06 07:30:00	QQQ	ETF	91.22	91.25	91.18	91.19	73100.0
2014-03-06 08:00:00	QQQ	ETF	91.22	91.26	91.2	91.26	18400.0
2014-03-06 08:30:00	QQQ	ETF	91.26	91.28	91.15	91.19	91831.0
2014-03-06 09:00:00	QQQ	ETF	91.21	91.29	91.18	91.24	110334.0
2014-03-06 09:30:00	QQQ	ETF	91.25	91.335	91.22	91.24	3141923.0
2014-03-06 10:00:00	QQQ	ETF	91.24	91.25	91.03	91.24	2612817.0
2014-03-06 10:30:00	QQQ	ETF	91.24	91.25	91.16	91.24	860800.0
2014-03-06 11:00:00	QQQ	ETF	91.239	91.27	91.15	91.19	1446932.0
2014-03-06 11:30:00	QQQ	ETF	91.19	91.2801	91.19	91.27	742848.0
2014-03-06 12:00:00	QQQ	ETF	91.2763	91.3	91.21	91.2375	801774.0
2014-03-06 12:30:00	QQQ	ETF	91.24	91.265	91.16	91.1801	669245.0
2014-03-06 13:00:00	QQQ	ETF	91.1801	91.22	91.0	91.03	980758.0
2014-03-06 13:30:00	QQQ	ETF	91.03	91.07	90.7	90.71	2323294.0
2014-03-06 14:00:00	QQQ	ETF	90.7	90.96	90.65	90.94	1783773.0

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

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