PREVIEW / etf_30min / 2016-11-08

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-11-08.parquet
  size:    417 KB
  rows:    14,018

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-11-08 04:00:00	SPY	ETF	213.25	213.37	213.19	213.19	3511.0
2016-11-08 04:30:00	SPY	ETF	213.3	213.36	213.28	213.28	3908.0
2016-11-08 05:00:00	SPY	ETF	213.28	213.28	213.0	213.0	12859.0
2016-11-08 05:30:00	SPY	ETF	213.01	213.12	212.82	213.09	15505.0
2016-11-08 06:00:00	SPY	ETF	213.07	213.09	212.97	213.0	14337.0
2016-11-08 06:30:00	SPY	ETF	212.99	213.0	212.85	212.9	134218.0
2016-11-08 07:00:00	SPY	ETF	212.96	213.07	212.91	213.01	39478.0
2016-11-08 07:30:00	SPY	ETF	213.07	213.15	212.99	213.08	112213.0
2016-11-08 08:00:00	SPY	ETF	213.0	213.08	212.95	212.96	202010.0
2016-11-08 08:30:00	SPY	ETF	212.95	213.05	212.83	212.86	271281.0
2016-11-08 09:00:00	SPY	ETF	212.86	212.91	212.69	212.69	560565.0
2016-11-08 09:30:00	SPY	ETF	212.69	212.89	212.38	212.555	8963237.0
2016-11-08 10:00:00	SPY	ETF	212.555	212.84	212.48	212.8	4148541.0
2016-11-08 10:30:00	SPY	ETF	212.79	213.02	212.69	212.99	4897505.0
2016-11-08 11:00:00	SPY	ETF	212.99	213.92	212.95	213.695	8564353.0
2016-11-08 11:30:00	SPY	ETF	213.69	214.2	213.66	214.19	5629458.0
2016-11-08 12:00:00	SPY	ETF	214.19	214.66	214.14	214.52	7471220.0
2016-11-08 12:30:00	SPY	ETF	214.525	214.75	214.34	214.7	6585529.0
2016-11-08 13:00:00	SPY	ETF	214.7	214.77	214.21	214.33	6437974.0
2016-11-08 13:30:00	SPY	ETF	214.33	214.57	214.28	214.34	5328212.0
2016-11-08 14:00:00	SPY	ETF	214.34	214.35	213.88	214.05	5767130.0
2016-11-08 14:30:00	SPY	ETF	214.05	214.06	213.57	213.87	6494709.0
2016-11-08 15:00:00	SPY	ETF	213.86	214.31	213.8	214.255	7474131.0
2016-11-08 15:30:00	SPY	ETF	214.255	214.53	213.84	214.07	18465281.0
2016-11-08 16:00:00	SPY	ETF	214.07	214.3742	212.9408	213.97	4947338.0
2016-11-08 16:30:00	SPY	ETF	213.96	214.14	213.89	214.03	374809.0
2016-11-08 17:00:00	SPY	ETF	214.1	214.11	213.82	214.11	239440.0
2016-11-08 17:30:00	SPY	ETF	214.1	214.21	214.08	214.15	148150.0
2016-11-08 18:00:00	SPY	ETF	214.21	214.83	214.21	214.71	370789.0
2016-11-08 18:30:00	SPY	ETF	214.7	214.72	214.43	214.69	93774.0
2016-11-08 19:00:00	SPY	ETF	214.63	214.79	213.7	214.64	567610.0
2016-11-08 19:30:00	SPY	ETF	214.64	215.54	213.28	215.48	837355.0
2016-11-08 20:00:00	SPY	ETF	214.11	214.11	214.0012	214.0052	1245000.0
2016-11-08 04:00:00	QQQ	ETF	116.4	116.4	116.4	116.4	200.0
2016-11-08 04:30:00	QQQ	ETF	116.44	116.44	116.44	116.44	199.0
2016-11-08 05:00:00	QQQ	ETF	116.3	116.3	116.27	116.27	498.0
2016-11-08 05:30:00	QQQ	ETF	116.26	116.26	116.26	116.26	250.0
2016-11-08 06:00:00	QQQ	ETF	116.33	116.33	116.33	116.33	300.0
2016-11-08 06:30:00	QQQ	ETF	116.28	116.28	116.28	116.28	900.0
2016-11-08 07:00:00	QQQ	ETF	116.29	116.36	116.29	116.36	3740.0
2016-11-08 07:30:00	QQQ	ETF	116.38	116.39	116.37	116.38	3400.0
2016-11-08 08:00:00	QQQ	ETF	116.37	116.38	116.3	116.3	41545.0
2016-11-08 08:30:00	QQQ	ETF	116.3	116.34	116.25	116.27	30506.0
2016-11-08 09:00:00	QQQ	ETF	116.23	116.28	116.21	116.21	40763.0
2016-11-08 09:30:00	QQQ	ETF	116.21	116.31	115.96	116.06	2589322.0
2016-11-08 10:00:00	QQQ	ETF	116.05	116.23	116.03	116.21	959352.0
2016-11-08 10:30:00	QQQ	ETF	116.2	116.37	116.179	116.37	1286318.0
2016-11-08 11:00:00	QQQ	ETF	116.37	116.885	116.33	116.75	1330227.0
2016-11-08 11:30:00	QQQ	ETF	116.75	117.13	116.74	117.12	1676013.0
2016-11-08 12:00:00	QQQ	ETF	117.12	117.55	117.12	117.46	1489174.0

> showing 50 of 14,018 rows — these rows as CSV

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