PREVIEW / etf_30min / 2016-03-02

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-03-02.parquet
  size:    392 KB
  rows:    13,231

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-03-02 04:00:00	SPY	ETF	198.6	198.6	198.08	198.15	19249.0
2016-03-02 04:30:00	SPY	ETF	198.2	198.24	197.89	197.92	17548.0
2016-03-02 05:00:00	SPY	ETF	197.89	198.04	197.89	197.93	9869.0
2016-03-02 05:30:00	SPY	ETF	197.99	197.99	197.8	197.83	5625.0
2016-03-02 06:00:00	SPY	ETF	197.83	197.94	197.83	197.89	21415.0
2016-03-02 06:30:00	SPY	ETF	197.89	198.03	197.89	197.96	31325.0
2016-03-02 07:00:00	SPY	ETF	198.02	198.02	197.78	197.97	101723.0
2016-03-02 07:30:00	SPY	ETF	198.0	198.25	198.0	198.07	90585.0
2016-03-02 08:00:00	SPY	ETF	197.9	198.21	197.85	197.85	584513.0
2016-03-02 08:30:00	SPY	ETF	197.88	197.96	197.74	197.82	311922.0
2016-03-02 09:00:00	SPY	ETF	197.81	197.94	197.7	197.74	288722.0
2016-03-02 09:30:00	SPY	ETF	197.74	198.09	197.44	197.65	13331911.0
2016-03-02 10:00:00	SPY	ETF	197.66	198.25	197.57	197.89	7323886.0
2016-03-02 10:30:00	SPY	ETF	197.89	198.09	197.25	198.03	9198776.0
2016-03-02 11:00:00	SPY	ETF	198.03	198.47	197.92	198.25	7605715.0
2016-03-02 11:30:00	SPY	ETF	198.25	198.46	197.71	197.73	4266447.0
2016-03-02 12:00:00	SPY	ETF	197.73	197.87	197.55	197.71	3620459.0
2016-03-02 12:30:00	SPY	ETF	197.715	198.18	197.63	198.12	3035023.0
2016-03-02 13:00:00	SPY	ETF	198.1225	198.35	198.0	198.3	3806129.0
2016-03-02 13:30:00	SPY	ETF	198.305	198.45	197.98	198.0001	3588705.0
2016-03-02 14:00:00	SPY	ETF	198.005	198.25	197.76	198.14	5335104.0
2016-03-02 14:30:00	SPY	ETF	198.14	198.645	198.12	198.46	5816352.0
2016-03-02 15:00:00	SPY	ETF	198.45	198.73	198.17	198.46	6849278.0
2016-03-02 15:30:00	SPY	ETF	198.47	199.06	198.31	199.0	15048240.0
2016-03-02 16:00:00	SPY	ETF	199.01	199.09	198.0504	198.93	9045896.0
2016-03-02 16:30:00	SPY	ETF	198.92	199.03	198.79	198.88	271602.0
2016-03-02 17:00:00	SPY	ETF	198.86	198.93	198.86	198.86	86701.0
2016-03-02 17:30:00	SPY	ETF	198.85	198.92	198.83	198.84	25423.0
2016-03-02 18:00:00	SPY	ETF	198.83	198.83	198.51	198.62	175180.0
2016-03-02 18:30:00	SPY	ETF	198.6	198.62	198.55	198.58	12450.0
2016-03-02 19:00:00	SPY	ETF	198.68	198.79	198.59	198.75	36110.0
2016-03-02 19:30:00	SPY	ETF	198.77	198.86	198.72	198.86	41236.0
2016-03-02 04:00:00	QQQ	ETF	106.02	106.02	106.02	106.02	100.0
2016-03-02 04:30:00	QQQ	ETF	105.96	105.96	105.78	105.81	1100.0
2016-03-02 05:00:00	QQQ	ETF	105.78	105.78	105.78	105.78	655.0
2016-03-02 05:30:00	QQQ	ETF	105.78	105.78	105.78	105.78	100.0
2016-03-02 06:30:00	QQQ	ETF	105.75	105.75	105.75	105.75	100.0
2016-03-02 07:00:00	QQQ	ETF	105.75	105.77	105.73	105.74	1100.0
2016-03-02 07:30:00	QQQ	ETF	105.88	105.88	105.83	105.83	1405.0
2016-03-02 08:00:00	QQQ	ETF	105.81	105.89	105.71	105.71	37498.0
2016-03-02 08:30:00	QQQ	ETF	105.72	105.73	105.64	105.68	103394.0
2016-03-02 09:00:00	QQQ	ETF	105.66	105.71	105.61	105.62	48224.0
2016-03-02 09:30:00	QQQ	ETF	105.63	105.805	105.275	105.45	3839392.0
2016-03-02 10:00:00	QQQ	ETF	105.46	105.85	105.43	105.62	2152330.0
2016-03-02 10:30:00	QQQ	ETF	105.62	105.62	105.22	105.56	2924104.0
2016-03-02 11:00:00	QQQ	ETF	105.55	105.73	105.25	105.35	1862561.0
2016-03-02 11:30:00	QQQ	ETF	105.35	105.4698	105.07	105.1	2006130.0
2016-03-02 12:00:00	QQQ	ETF	105.09	105.21	105.01	105.1	2009074.0
2016-03-02 12:30:00	QQQ	ETF	105.1	105.335	105.07	105.31	988169.0
2016-03-02 13:00:00	QQQ	ETF	105.312	105.81	105.19	105.38	956798.0

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

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