PREVIEW / etf_30min / 2017-12-21

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-12-21.parquet
  size:    457 KB
  rows:    15,939

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
2017-12-21 04:00:00	SPY	ETF	267.07	267.1	267.04	267.1	3355.0
2017-12-21 04:30:00	SPY	ETF	267.07	267.1	267.07	267.1	2106.0
2017-12-21 05:00:00	SPY	ETF	267.14	267.2	267.14	267.2	1595.0
2017-12-21 05:30:00	SPY	ETF	267.24	267.3	267.24	267.3	5550.0
2017-12-21 06:00:00	SPY	ETF	267.31	267.45	267.31	267.45	4691.0
2017-12-21 06:30:00	SPY	ETF	267.44	267.5	267.44	267.49	3631.0
2017-12-21 07:00:00	SPY	ETF	267.5	267.52	267.46	267.5	151644.0
2017-12-21 07:30:00	SPY	ETF	267.5	267.54	267.45	267.45	146313.0
2017-12-21 08:00:00	SPY	ETF	267.51	267.51	267.42	267.49	342781.0
2017-12-21 08:30:00	SPY	ETF	267.46	267.75	267.45	267.69	464580.0
2017-12-21 09:00:00	SPY	ETF	267.69	267.78	267.68	267.75	196452.0
2017-12-21 09:30:00	SPY	ETF	267.74	267.84	267.3	267.38	6126924.0
2017-12-21 10:00:00	SPY	ETF	267.38	267.7	267.37	267.665	3022089.0
2017-12-21 10:30:00	SPY	ETF	267.67	268.09	267.665	267.87	4198249.0
2017-12-21 11:00:00	SPY	ETF	267.87	268.05	267.8	268.0	2748714.0
2017-12-21 11:30:00	SPY	ETF	268.0	268.17	267.97	268.03	2659553.0
2017-12-21 12:00:00	SPY	ETF	268.03	268.04	267.91	267.995	3919616.0
2017-12-21 12:30:00	SPY	ETF	267.995	268.21	267.92	268.19	2576449.0
2017-12-21 13:00:00	SPY	ETF	268.19	268.385	268.18	268.355	2398386.0
2017-12-21 13:30:00	SPY	ETF	268.3505	268.365	268.17	268.19	2901903.0
2017-12-21 14:00:00	SPY	ETF	268.19	268.2	268.01	268.07	1765537.0
2017-12-21 14:30:00	SPY	ETF	268.08	268.11	267.925	268.09	2909405.0
2017-12-21 15:00:00	SPY	ETF	268.0925	268.12	267.76	267.965	4201354.0
2017-12-21 15:30:00	SPY	ETF	267.965	268.0295	267.41	267.57	12286976.0
2017-12-21 16:00:00	SPY	ETF	267.56	267.82	267.48	267.56	7257474.0
2017-12-21 16:30:00	SPY	ETF	267.56	267.9523	267.42	267.46	214374.0
2017-12-21 17:00:00	SPY	ETF	267.45	267.58	267.45	267.49	2373415.0
2017-12-21 17:30:00	SPY	ETF	267.47	267.47	267.42	267.44	17527.0
2017-12-21 18:00:00	SPY	ETF	267.43	267.71	267.43	267.71	1039314.0
2017-12-21 18:30:00	SPY	ETF	267.7	267.74	267.66	267.68	26897.0
2017-12-21 19:00:00	SPY	ETF	267.67	267.69	267.56	267.56	13608.0
2017-12-21 19:30:00	SPY	ETF	267.63	267.72	267.63	267.72	8508.0
2017-12-21 04:00:00	QQQ	ETF	157.39	157.39	157.39	157.39	5000.0
2017-12-21 04:30:00	QQQ	ETF	157.41	157.46	157.4	157.42	7100.0
2017-12-21 05:30:00	QQQ	ETF	157.5	157.5	157.48	157.48	1300.0
2017-12-21 06:00:00	QQQ	ETF	157.58	157.58	157.52	157.58	2400.0
2017-12-21 06:30:00	QQQ	ETF	157.67	157.68	157.62	157.62	3100.0
2017-12-21 07:00:00	QQQ	ETF	157.64	157.66	157.64	157.64	1900.0
2017-12-21 07:30:00	QQQ	ETF	157.64	157.75	157.64	157.71	68395.0
2017-12-21 08:00:00	QQQ	ETF	157.71	157.76	157.64	157.65	44597.0
2017-12-21 08:30:00	QQQ	ETF	157.67	157.81	157.67	157.77	11020.0
2017-12-21 09:00:00	QQQ	ETF	157.76	157.77	157.65	157.75	82956.0
2017-12-21 09:30:00	QQQ	ETF	157.73	157.98	157.37	157.47	2563004.0
2017-12-21 10:00:00	QQQ	ETF	157.48	157.66	157.41	157.6	987804.0
2017-12-21 10:30:00	QQQ	ETF	157.601	157.87	157.53	157.5967	1395059.0
2017-12-21 11:00:00	QQQ	ETF	157.59	158.015	157.58	157.95	913530.0
2017-12-21 11:30:00	QQQ	ETF	157.97	158.09	157.93	157.93	871501.0
2017-12-21 12:00:00	QQQ	ETF	157.93	158.02	157.86	158.01	629116.0
2017-12-21 12:30:00	QQQ	ETF	158.01	158.11	157.88	158.09	358053.0
2017-12-21 13:00:00	QQQ	ETF	158.09	158.25	158.075	158.21	573898.0

> showing 50 of 15,939 rows — these rows as CSV

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