PREVIEW / etf_30min / 2016-12-02

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-12-02.parquet
  size:    429 KB
  rows:    14,550

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-12-02 04:00:00	SPY	ETF	219.25	219.25	218.99	219.02	54951.0
2016-12-02 04:30:00	SPY	ETF	219.09	219.19	219.09	219.15	2182.0
2016-12-02 05:00:00	SPY	ETF	219.09	219.09	219.02	219.05	2631.0
2016-12-02 05:30:00	SPY	ETF	219.02	219.14	219.01	219.11	6376.0
2016-12-02 06:00:00	SPY	ETF	219.07	219.19	219.07	219.19	7787.0
2016-12-02 06:30:00	SPY	ETF	219.19	219.19	219.06	219.06	4329.0
2016-12-02 07:00:00	SPY	ETF	219.1	219.3	219.1	219.3	7168.0
2016-12-02 07:30:00	SPY	ETF	219.27	219.4	219.22	219.36	130149.0
2016-12-02 08:00:00	SPY	ETF	219.2	219.63	219.12	219.56	292020.0
2016-12-02 08:30:00	SPY	ETF	219.41	219.69	219.19	219.53	453609.0
2016-12-02 09:00:00	SPY	ETF	219.53	219.66	219.46	219.66	361248.0
2016-12-02 09:30:00	SPY	ETF	219.67	220.0	219.48	219.92	7518223.0
2016-12-02 10:00:00	SPY	ETF	219.93	220.07	219.61	219.78	5296618.0
2016-12-02 10:30:00	SPY	ETF	219.77	220.16	219.76	219.95	4187808.0
2016-12-02 11:00:00	SPY	ETF	219.96	220.25	219.9	220.115	8037293.0
2016-12-02 11:30:00	SPY	ETF	220.11	220.15	219.87	219.92	4246527.0
2016-12-02 12:00:00	SPY	ETF	219.915	219.93	219.68	219.77	2098035.0
2016-12-02 12:30:00	SPY	ETF	219.77	219.95	219.51	219.87	3742886.0
2016-12-02 13:00:00	SPY	ETF	219.865	219.8859	219.32	219.33	4186053.0
2016-12-02 13:30:00	SPY	ETF	219.33	219.52	219.33	219.415	3051912.0
2016-12-02 14:00:00	SPY	ETF	219.41	219.51	219.26	219.475	2694493.0
2016-12-02 14:30:00	SPY	ETF	219.47	219.54	219.4	219.42	2981857.0
2016-12-02 15:00:00	SPY	ETF	219.42	219.64	219.38	219.61	2813974.0
2016-12-02 15:30:00	SPY	ETF	219.61	219.87	219.48	219.66	12924261.0
2016-12-02 16:00:00	SPY	ETF	219.69	219.86	219.545	219.79	6271601.0
2016-12-02 16:30:00	SPY	ETF	219.79	219.84	219.6	219.6	2261795.0
2016-12-02 17:00:00	SPY	ETF	219.65	219.68	219.52	219.55	73811.0
2016-12-02 17:30:00	SPY	ETF	219.61	219.75	219.61	219.68	16771.0
2016-12-02 18:00:00	SPY	ETF	219.66	219.68	219.29	219.33	167255.0
2016-12-02 18:30:00	SPY	ETF	219.33	219.42	219.33	219.37	11671.0
2016-12-02 19:00:00	SPY	ETF	219.39	219.43	219.36	219.42	11245.0
2016-12-02 19:30:00	SPY	ETF	219.4	219.44	219.37	219.44	17902.0
2016-12-02 04:00:00	QQQ	ETF	115.16	115.16	114.98	114.98	3900.0
2016-12-02 04:30:00	QQQ	ETF	114.98	114.99	114.98	114.99	1242.0
2016-12-02 05:30:00	QQQ	ETF	115.0	115.02	115.0	115.02	11206.0
2016-12-02 06:00:00	QQQ	ETF	114.98	115.03	114.97	115.03	11298.0
2016-12-02 06:30:00	QQQ	ETF	115.04	115.04	115.0	115.0	458.0
2016-12-02 07:00:00	QQQ	ETF	115.02	115.2	115.02	115.18	8987.0
2016-12-02 07:30:00	QQQ	ETF	115.16	115.22	115.09	115.19	4100.0
2016-12-02 08:00:00	QQQ	ETF	115.14	115.44	115.05	115.4	56523.0
2016-12-02 08:30:00	QQQ	ETF	115.42	115.53	115.2	115.45	213733.0
2016-12-02 09:00:00	QQQ	ETF	115.45	115.6	115.42	115.58	328032.0
2016-12-02 09:30:00	QQQ	ETF	115.58	116.16	115.34	115.72	4419301.0
2016-12-02 10:00:00	QQQ	ETF	115.73	115.9	115.22	115.55	2519017.0
2016-12-02 10:30:00	QQQ	ETF	115.54	115.93	115.53	115.79	1504886.0
2016-12-02 11:00:00	QQQ	ETF	115.79	116.13	115.72	116.06	1438516.0
2016-12-02 11:30:00	QQQ	ETF	116.06	116.1	115.71	115.755	1017266.0
2016-12-02 12:00:00	QQQ	ETF	115.76	115.87	115.7	115.8	660022.0
2016-12-02 12:30:00	QQQ	ETF	115.79	115.935	115.631	115.895	616855.0
2016-12-02 13:00:00	QQQ	ETF	115.88	115.89	115.51	115.55	687635.0

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

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