PREVIEW / etf_30min / 2016-05-20

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-05-20.parquet
  size:    376 KB
  rows:    12,831

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-05-20 04:00:00	SPY	ETF	204.82	205.2	204.82	205.05	5610.0
2016-05-20 04:30:00	SPY	ETF	205.1	205.15	205.1	205.15	3468.0
2016-05-20 05:00:00	SPY	ETF	205.09	205.09	204.62	204.83	8849.0
2016-05-20 05:30:00	SPY	ETF	204.79	205.0	204.79	204.99	23721.0
2016-05-20 06:00:00	SPY	ETF	204.95	204.95	204.78	204.93	4280.0
2016-05-20 06:30:00	SPY	ETF	204.9	204.98	204.85	204.89	59642.0
2016-05-20 07:00:00	SPY	ETF	204.88	204.88	204.8	204.86	73726.0
2016-05-20 07:30:00	SPY	ETF	204.86	205.03	204.79	204.98	299138.0
2016-05-20 08:00:00	SPY	ETF	204.97	205.12	204.8	205.03	484883.0
2016-05-20 08:30:00	SPY	ETF	205.02	205.07	204.83	205.06	442291.0
2016-05-20 09:00:00	SPY	ETF	205.01	205.15	204.93	204.93	1656995.0
2016-05-20 09:30:00	SPY	ETF	204.92	205.8	204.86	205.65	13061497.0
2016-05-20 10:00:00	SPY	ETF	205.66	205.95	205.48	205.505	12391918.0
2016-05-20 10:30:00	SPY	ETF	205.5	205.81	205.47	205.63	7204940.0
2016-05-20 11:00:00	SPY	ETF	205.63	205.99	205.58	205.89	5266809.0
2016-05-20 11:30:00	SPY	ETF	205.9	206.1	205.77	205.8105	5080254.0
2016-05-20 12:00:00	SPY	ETF	205.82	205.86	205.68	205.795	3399060.0
2016-05-20 12:30:00	SPY	ETF	205.795	205.92	205.69	205.7708	2463365.0
2016-05-20 13:00:00	SPY	ETF	205.77	205.85	205.55	205.55	2597580.0
2016-05-20 13:30:00	SPY	ETF	205.56	205.56	205.28	205.41	4846489.0
2016-05-20 14:00:00	SPY	ETF	205.41	205.78	205.35	205.769	4916673.0
2016-05-20 14:30:00	SPY	ETF	205.76	205.8	205.4	205.4475	3712047.0
2016-05-20 15:00:00	SPY	ETF	205.45	205.48	205.04	205.1232	8539460.0
2016-05-20 15:30:00	SPY	ETF	205.125	205.51	205.1	205.46	11483537.0
2016-05-20 16:00:00	SPY	ETF	205.47	205.59	205.3981	205.55	11001173.0
2016-05-20 16:30:00	SPY	ETF	205.55	205.6	205.55	205.57	633529.0
2016-05-20 17:00:00	SPY	ETF	205.56	205.62	205.49	205.5	333092.0
2016-05-20 17:30:00	SPY	ETF	205.53	205.58	205.49	205.55	48689.0
2016-05-20 18:00:00	SPY	ETF	205.55	205.57	205.5	205.54	57477.0
2016-05-20 18:30:00	SPY	ETF	205.5	205.55	205.5	205.54	2405.0
2016-05-20 19:00:00	SPY	ETF	205.54	205.57	205.54	205.56	4958.0
2016-05-20 19:30:00	SPY	ETF	205.56	205.57	205.51	205.53	17540.0
2016-05-20 04:00:00	QQQ	ETF	105.93	105.97	105.93	105.97	1100.0
2016-05-20 05:00:00	QQQ	ETF	105.69	105.69	105.69	105.69	636.0
2016-05-20 05:30:00	QQQ	ETF	105.78	105.78	105.78	105.78	399.0
2016-05-20 07:00:00	QQQ	ETF	105.69	105.72	105.69	105.72	533.0
2016-05-20 07:30:00	QQQ	ETF	105.7	105.8	105.7	105.79	6299.0
2016-05-20 08:00:00	QQQ	ETF	105.78	105.86	105.76	105.82	26646.0
2016-05-20 08:30:00	QQQ	ETF	105.79	105.94	105.74	105.91	97806.0
2016-05-20 09:00:00	QQQ	ETF	105.94	106.01	105.74	105.75	404959.0
2016-05-20 09:30:00	QQQ	ETF	105.74	106.43	105.67	106.43	3790530.0
2016-05-20 10:00:00	QQQ	ETF	106.43	106.64	106.38	106.4099	2693565.0
2016-05-20 10:30:00	QQQ	ETF	106.4	106.71	106.4	106.5799	1398741.0
2016-05-20 11:00:00	QQQ	ETF	106.57	106.75	106.56	106.71	1717283.0
2016-05-20 11:30:00	QQQ	ETF	106.71	106.9	106.69	106.75	1531245.0
2016-05-20 12:00:00	QQQ	ETF	106.76	106.79	106.66	106.77	899867.0
2016-05-20 12:30:00	QQQ	ETF	106.76	106.83	106.69	106.7239	542763.0
2016-05-20 13:00:00	QQQ	ETF	106.72	106.76	106.56	106.56	951075.0
2016-05-20 13:30:00	QQQ	ETF	106.57	106.57	106.41	106.5	975771.0
2016-05-20 14:00:00	QQQ	ETF	106.495	106.67	106.455	106.655	896820.0

> showing 50 of 12,831 rows — these rows as CSV

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