PREVIEW / etf_30min / 2016-05-02

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-05-02.parquet
  size:    395 KB
  rows:    13,376

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-02 04:00:00	SPY	ETF	206.46	206.68	206.46	206.68	1480.0
2016-05-02 04:30:00	SPY	ETF	206.71	206.73	206.51	206.51	725.0
2016-05-02 05:00:00	SPY	ETF	206.48	206.73	206.48	206.73	1656.0
2016-05-02 05:30:00	SPY	ETF	206.56	206.59	206.49	206.53	5034.0
2016-05-02 06:00:00	SPY	ETF	206.56	206.56	206.49	206.56	3406.0
2016-05-02 06:30:00	SPY	ETF	206.5	206.65	206.5	206.65	40499.0
2016-05-02 07:00:00	SPY	ETF	206.67	206.96	206.67	206.94	219703.0
2016-05-02 07:30:00	SPY	ETF	206.94	207.04	206.88	206.88	208554.0
2016-05-02 08:00:00	SPY	ETF	206.88	207.07	206.58	206.94	219023.0
2016-05-02 08:30:00	SPY	ETF	206.92	206.95	206.77	206.9	170435.0
2016-05-02 09:00:00	SPY	ETF	206.91	207.08	206.87	206.92	303422.0
2016-05-02 09:30:00	SPY	ETF	206.92	207.03	206.41	206.64	7214546.0
2016-05-02 10:00:00	SPY	ETF	206.63	207.32	206.46	207.14	8152745.0
2016-05-02 10:30:00	SPY	ETF	207.14	207.23	206.69	206.8101	4507037.0
2016-05-02 11:00:00	SPY	ETF	206.81	207.37	206.8	207.1211	3660621.0
2016-05-02 11:30:00	SPY	ETF	207.125	207.3	206.8601	206.91	4140581.0
2016-05-02 12:00:00	SPY	ETF	206.91	207.03	206.7789	206.88	2808394.0
2016-05-02 12:30:00	SPY	ETF	206.88	207.32	206.88	207.295	2496979.0
2016-05-02 13:00:00	SPY	ETF	207.3	207.62	207.25	207.61	3534984.0
2016-05-02 13:30:00	SPY	ETF	207.61	207.75	207.55	207.57	2474624.0
2016-05-02 14:00:00	SPY	ETF	207.575	207.84	207.565	207.75	2937203.0
2016-05-02 14:30:00	SPY	ETF	207.75	207.84	207.6	207.75	2470306.0
2016-05-02 15:00:00	SPY	ETF	207.76	207.94	207.735	207.91	3472629.0
2016-05-02 15:30:00	SPY	ETF	207.905	208.18	207.76	207.97	8323789.0
2016-05-02 16:00:00	SPY	ETF	207.97	208.03	207.82	207.92	2229621.0
2016-05-02 16:30:00	SPY	ETF	207.93	208.07	207.92	208.01	276330.0
2016-05-02 17:00:00	SPY	ETF	208.0	208.07	207.98	208.07	65127.0
2016-05-02 17:30:00	SPY	ETF	208.05	208.05	207.98	207.99	47107.0
2016-05-02 18:00:00	SPY	ETF	207.98	208.04	207.86	208.04	108364.0
2016-05-02 18:30:00	SPY	ETF	207.98	208.0	207.92	207.96	6631.0
2016-05-02 19:00:00	SPY	ETF	207.99	208.0	207.89	207.89	25516.0
2016-05-02 19:30:00	SPY	ETF	207.89	207.92	207.85	207.85	34803.0
2016-05-02 04:30:00	QQQ	ETF	105.79	105.79	105.79	105.79	1050.0
2016-05-02 05:30:00	QQQ	ETF	105.69	105.69	105.69	105.69	100.0
2016-05-02 06:00:00	QQQ	ETF	105.72	105.72	105.72	105.72	100.0
2016-05-02 06:30:00	QQQ	ETF	105.81	105.81	105.81	105.81	1049.0
2016-05-02 07:00:00	QQQ	ETF	105.84	105.99	105.84	105.99	119085.0
2016-05-02 07:30:00	QQQ	ETF	106.0	106.02	105.93	105.93	19901.0
2016-05-02 08:00:00	QQQ	ETF	105.91	105.99	105.91	105.96	6100.0
2016-05-02 08:30:00	QQQ	ETF	105.92	105.96	105.89	105.95	11084.0
2016-05-02 09:00:00	QQQ	ETF	106.0	106.02	105.93	105.96	83911.0
2016-05-02 09:30:00	QQQ	ETF	105.97	106.02	105.601	105.68	2913366.0
2016-05-02 10:00:00	QQQ	ETF	105.68	106.12	105.5525	105.92	2744520.0
2016-05-02 10:30:00	QQQ	ETF	105.91	106.05	105.62	105.67	1842929.0
2016-05-02 11:00:00	QQQ	ETF	105.67	105.98	105.65	105.91	1183783.0
2016-05-02 11:30:00	QQQ	ETF	105.91	106.01	105.76	105.7945	1206846.0
2016-05-02 12:00:00	QQQ	ETF	105.8	105.95	105.7	105.86	724500.0
2016-05-02 12:30:00	QQQ	ETF	105.86	106.12	105.86	106.04	887651.0
2016-05-02 13:00:00	QQQ	ETF	106.04	106.28	105.96	106.26	679124.0
2016-05-02 13:30:00	QQQ	ETF	106.2669	106.405	106.245	106.28	888389.0

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

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