PREVIEW / etf_30min / 2016-05-09

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-05-09.parquet
  size:    389 KB
  rows:    13,295

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-09 04:00:00	SPY	ETF	205.58	205.85	205.55	205.85	13273.0
2016-05-09 04:30:00	SPY	ETF	205.92	206.27	205.92	206.25	19252.0
2016-05-09 05:00:00	SPY	ETF	206.3	206.41	206.3	206.34	1774.0
2016-05-09 05:30:00	SPY	ETF	206.29	206.42	206.27	206.27	4509.0
2016-05-09 06:00:00	SPY	ETF	206.29	206.35	206.23	206.32	3182.0
2016-05-09 06:30:00	SPY	ETF	206.35	206.38	206.25	206.25	9492.0
2016-05-09 07:00:00	SPY	ETF	206.27	206.46	206.22	206.46	67435.0
2016-05-09 07:30:00	SPY	ETF	206.46	206.47	206.2	206.22	92002.0
2016-05-09 08:00:00	SPY	ETF	206.38	206.44	205.96	206.03	424773.0
2016-05-09 08:30:00	SPY	ETF	206.03	206.04	205.7	205.84	179826.0
2016-05-09 09:00:00	SPY	ETF	205.83	205.85	205.41	205.56	1629039.0
2016-05-09 09:30:00	SPY	ETF	205.57	206.32	205.48	206.25	8328803.0
2016-05-09 10:00:00	SPY	ETF	206.25	206.39	205.63	205.7099	6897153.0
2016-05-09 10:30:00	SPY	ETF	205.71	205.91	205.55	205.76	5855082.0
2016-05-09 11:00:00	SPY	ETF	205.76	206.02	205.36	205.56	6399572.0
2016-05-09 11:30:00	SPY	ETF	205.56	205.86	205.42	205.76	4117365.0
2016-05-09 12:00:00	SPY	ETF	205.745	205.96	205.52	205.9175	2747094.0
2016-05-09 12:30:00	SPY	ETF	205.92	205.95	205.695	205.89	2042574.0
2016-05-09 13:00:00	SPY	ETF	205.89	206.14	205.86	206.01	2573219.0
2016-05-09 13:30:00	SPY	ETF	206.01	206.16	205.85	205.88	2295346.0
2016-05-09 14:00:00	SPY	ETF	205.88	206.03	205.69	205.93	3348827.0
2016-05-09 14:30:00	SPY	ETF	205.94	206.4	205.92	206.34	3756524.0
2016-05-09 15:00:00	SPY	ETF	206.34	206.365	206.13	206.13	3307848.0
2016-05-09 15:30:00	SPY	ETF	206.13	206.19	205.74	205.89	8443366.0
2016-05-09 16:00:00	SPY	ETF	205.88	206.05	205.78	205.91	7380585.0
2016-05-09 16:30:00	SPY	ETF	205.92	205.96	205.84	205.94	791186.0
2016-05-09 17:00:00	SPY	ETF	205.9	205.99	205.9	205.97	80130.0
2016-05-09 17:30:00	SPY	ETF	205.96	205.99	205.93	205.94	65319.0
2016-05-09 18:00:00	SPY	ETF	205.94	205.94	205.32	205.45	602252.0
2016-05-09 18:30:00	SPY	ETF	205.45	205.51	205.44	205.45	110271.0
2016-05-09 19:00:00	SPY	ETF	205.45	205.56	205.45	205.52	26573.0
2016-05-09 19:30:00	SPY	ETF	205.52	205.62	205.52	205.57	48962.0
2016-05-09 04:00:00	QQQ	ETF	105.6	105.6	105.56	105.56	300.0
2016-05-09 05:30:00	QQQ	ETF	106.0	106.04	106.0	106.0	3998.0
2016-05-09 06:00:00	QQQ	ETF	106.0	106.02	106.0	106.02	2781.0
2016-05-09 06:30:00	QQQ	ETF	106.0	106.0	105.96	105.96	1598.0
2016-05-09 07:00:00	QQQ	ETF	105.94	106.06	105.93	106.06	12393.0
2016-05-09 07:30:00	QQQ	ETF	106.04	106.04	105.93	105.93	11699.0
2016-05-09 08:00:00	QQQ	ETF	106.01	106.01	105.89	105.91	28509.0
2016-05-09 08:30:00	QQQ	ETF	105.88	105.89	105.78	105.78	17845.0
2016-05-09 09:00:00	QQQ	ETF	105.78	105.78	105.56	105.6	78493.0
2016-05-09 09:30:00	QQQ	ETF	105.61	106.16	105.54	106.16	2539331.0
2016-05-09 10:00:00	QQQ	ETF	106.15	106.25	105.78	105.82	1807902.0
2016-05-09 10:30:00	QQQ	ETF	105.82	106.01	105.72	105.92	922132.0
2016-05-09 11:00:00	QQQ	ETF	105.92	106.08	105.71	105.85	1295255.0
2016-05-09 11:30:00	QQQ	ETF	105.85	106.04	105.72	105.95	782905.0
2016-05-09 12:00:00	QQQ	ETF	105.95	106.105	105.81	106.07	686274.0
2016-05-09 12:30:00	QQQ	ETF	106.07	106.085	105.95	106.04	563743.0
2016-05-09 13:00:00	QQQ	ETF	106.04	106.17	106.01	106.0915	705456.0
2016-05-09 13:30:00	QQQ	ETF	106.1	106.2	106.03	106.04	778808.0

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

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