PREVIEW / etf_30min / 2016-07-13

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-07-13.parquet
  size:    401 KB
  rows:    13,567

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
2016-07-13 04:00:00	SPY	ETF	214.75	214.98	214.75	214.85	15067.0
2016-07-13 04:30:00	SPY	ETF	214.92	215.0	214.92	214.99	2771.0
2016-07-13 05:00:00	SPY	ETF	214.95	215.13	214.95	215.03	6731.0
2016-07-13 05:30:00	SPY	ETF	215.08	215.16	215.08	215.15	7542.0
2016-07-13 06:00:00	SPY	ETF	215.1	215.25	215.08	215.18	20919.0
2016-07-13 06:30:00	SPY	ETF	215.18	215.27	215.18	215.21	9614.0
2016-07-13 07:00:00	SPY	ETF	215.16	215.16	215.05	215.05	48680.0
2016-07-13 07:30:00	SPY	ETF	215.06	215.12	215.0	215.12	55897.0
2016-07-13 08:00:00	SPY	ETF	215.12	215.33	214.594	215.32	223346.0
2016-07-13 08:30:00	SPY	ETF	215.3	215.61	215.28	215.55	566998.0
2016-07-13 09:00:00	SPY	ETF	215.53	215.57	215.41	215.45	820693.0
2016-07-13 09:30:00	SPY	ETF	215.44	215.45	214.75	214.87	10126475.0
2016-07-13 10:00:00	SPY	ETF	214.87	215.16	214.86	214.92	7256527.0
2016-07-13 10:30:00	SPY	ETF	214.92	215.18	214.77	215.08	5531664.0
2016-07-13 11:00:00	SPY	ETF	215.0789	215.17	214.73	214.795	5197187.0
2016-07-13 11:30:00	SPY	ETF	214.7999	214.8	214.35	214.56	6930705.0
2016-07-13 12:00:00	SPY	ETF	214.56	214.77	214.56	214.63	5959966.0
2016-07-13 12:30:00	SPY	ETF	214.62	214.76	214.52	214.75	6133284.0
2016-07-13 13:00:00	SPY	ETF	214.75	214.93	214.669	214.68	2883814.0
2016-07-13 13:30:00	SPY	ETF	214.67	214.95	214.6	214.7	4806693.0
2016-07-13 14:00:00	SPY	ETF	214.7	215.08	214.6	215.05	3924939.0
2016-07-13 14:30:00	SPY	ETF	215.06	215.13	214.91	215.02	4718772.0
2016-07-13 15:00:00	SPY	ETF	215.02	215.16	214.84	214.93	4356679.0
2016-07-13 15:30:00	SPY	ETF	214.93	215.15	214.9099	214.92	9726575.0
2016-07-13 16:00:00	SPY	ETF	214.91	215.02	214.9	214.96	5822148.0
2016-07-13 16:30:00	SPY	ETF	214.96	215.0	214.93	214.94	655523.0
2016-07-13 17:00:00	SPY	ETF	214.96	215.0	214.92	214.94	260966.0
2016-07-13 17:30:00	SPY	ETF	214.95	214.96	214.91	214.92	32993.0
2016-07-13 18:00:00	SPY	ETF	214.91	214.91	214.72	214.73	74017.0
2016-07-13 18:30:00	SPY	ETF	214.73	214.81	214.73	214.76	12794.0
2016-07-13 19:00:00	SPY	ETF	214.81	214.82	214.78	214.8	17903.0
2016-07-13 19:30:00	SPY	ETF	214.79	214.85	214.77	214.8	17051.0
2016-07-13 04:30:00	QQQ	ETF	111.5	111.51	111.5	111.51	3000.0
2016-07-13 05:00:00	QQQ	ETF	111.51	111.57	111.51	111.57	1900.0
2016-07-13 05:30:00	QQQ	ETF	111.61	111.64	111.59	111.62	4000.0
2016-07-13 06:00:00	QQQ	ETF	111.62	111.67	111.62	111.67	1298.0
2016-07-13 06:30:00	QQQ	ETF	111.68	111.72	111.68	111.72	1507.0
2016-07-13 07:00:00	QQQ	ETF	111.64	111.64	111.64	111.64	200.0
2016-07-13 07:30:00	QQQ	ETF	111.61	111.66	111.59	111.64	12940.0
2016-07-13 08:00:00	QQQ	ETF	111.64	111.75	111.62	111.74	48621.0
2016-07-13 08:30:00	QQQ	ETF	111.73	111.84	111.71	111.83	232955.0
2016-07-13 09:00:00	QQQ	ETF	111.81	111.83	111.75	111.79	51701.0
2016-07-13 09:30:00	QQQ	ETF	111.79	111.8	111.41	111.59	2718388.0
2016-07-13 10:00:00	QQQ	ETF	111.6	111.77	111.57	111.6	1000092.0
2016-07-13 10:30:00	QQQ	ETF	111.61	111.82	111.52	111.75	963858.0
2016-07-13 11:00:00	QQQ	ETF	111.74	111.79	111.43	111.47	1260878.0
2016-07-13 11:30:00	QQQ	ETF	111.47	111.47	111.22	111.38	1961096.0
2016-07-13 12:00:00	QQQ	ETF	111.375	111.46	111.36	111.36	829490.0
2016-07-13 12:30:00	QQQ	ETF	111.35	111.47	111.31	111.439	719962.0
2016-07-13 13:00:00	QQQ	ETF	111.43	111.54	111.37	111.37	634980.0

> showing 50 of 13,567 rows — these rows as CSV

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