PREVIEW / etf_30min / 2016-07-20

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-07-20.parquet
  size:    398 KB
  rows:    13,516

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-07-20 04:00:00	SPY	ETF	216.4	216.57	216.4	216.57	8192.0
2016-07-20 04:30:00	SPY	ETF	216.57	216.85	216.56	216.75	11605.0
2016-07-20 05:00:00	SPY	ETF	216.75	217.09	216.75	217.09	21491.0
2016-07-20 05:30:00	SPY	ETF	217.03	217.09	217.0	217.03	24909.0
2016-07-20 06:00:00	SPY	ETF	217.05	217.05	216.98	216.98	8694.0
2016-07-20 06:30:00	SPY	ETF	216.98	217.01	216.93	216.93	9290.0
2016-07-20 07:00:00	SPY	ETF	216.93	216.99	216.88	216.89	22455.0
2016-07-20 07:30:00	SPY	ETF	216.87	216.91	216.8	216.83	122000.0
2016-07-20 08:00:00	SPY	ETF	216.83	216.96	215.973	216.83	262199.0
2016-07-20 08:30:00	SPY	ETF	216.83	216.83	215.9	216.68	255559.0
2016-07-20 09:00:00	SPY	ETF	216.69	216.84	216.65	216.76	612714.0
2016-07-20 09:30:00	SPY	ETF	216.75	216.78	216.24	216.505	6674161.0
2016-07-20 10:00:00	SPY	ETF	216.509	216.91	216.4	216.8	4449364.0
2016-07-20 10:30:00	SPY	ETF	216.805	217.174	216.74	217.11	4523599.0
2016-07-20 11:00:00	SPY	ETF	217.12	217.37	217.08	217.34	4235145.0
2016-07-20 11:30:00	SPY	ETF	217.34	217.36	217.15	217.15	2066109.0
2016-07-20 12:00:00	SPY	ETF	217.15	217.2	217.06	217.1398	2014851.0
2016-07-20 12:30:00	SPY	ETF	217.135	217.14	217.05	217.11	1211588.0
2016-07-20 13:00:00	SPY	ETF	217.11	217.28	217.09	217.255	3352454.0
2016-07-20 13:30:00	SPY	ETF	217.2564	217.34	217.2	217.21	2101298.0
2016-07-20 14:00:00	SPY	ETF	217.215	217.37	217.205	217.2368	2914256.0
2016-07-20 14:30:00	SPY	ETF	217.24	217.3	217.14	217.14	2934444.0
2016-07-20 15:00:00	SPY	ETF	217.145	217.16	217.0	217.03	4683409.0
2016-07-20 15:30:00	SPY	ETF	217.035	217.265	217.03	217.09	8045473.0
2016-07-20 16:00:00	SPY	ETF	217.1	217.16	217.04	217.15	4118015.0
2016-07-20 16:30:00	SPY	ETF	217.15	217.28	217.12	217.28	351648.0
2016-07-20 17:00:00	SPY	ETF	217.26	217.28	217.12	217.2	93845.0
2016-07-20 17:30:00	SPY	ETF	217.21	217.23	217.18	217.18	18202.0
2016-07-20 18:00:00	SPY	ETF	217.19	217.22	217.14	217.22	59025.0
2016-07-20 18:30:00	SPY	ETF	217.22	217.23	217.15	217.15	33432.0
2016-07-20 19:00:00	SPY	ETF	217.14	217.18	217.06	217.07	28758.0
2016-07-20 19:30:00	SPY	ETF	217.1	217.13	217.0759	217.11	199975.0
2016-07-20 04:00:00	QQQ	ETF	112.44	112.48	112.44	112.48	1299.0
2016-07-20 04:30:00	QQQ	ETF	112.56	112.71	112.56	112.67	2299.0
2016-07-20 05:00:00	QQQ	ETF	112.77	112.84	112.77	112.84	300.0
2016-07-20 05:30:00	QQQ	ETF	112.8	112.8	112.77	112.8	3799.0
2016-07-20 06:00:00	QQQ	ETF	112.78	112.79	112.78	112.79	1100.0
2016-07-20 06:30:00	QQQ	ETF	112.77	112.77	112.75	112.75	1100.0
2016-07-20 07:00:00	QQQ	ETF	112.74	112.76	112.72	112.72	19200.0
2016-07-20 07:30:00	QQQ	ETF	112.71	112.73	112.69	112.73	21465.0
2016-07-20 08:00:00	QQQ	ETF	112.7	112.73	112.67	112.73	114726.0
2016-07-20 08:30:00	QQQ	ETF	112.71	112.71	112.65	112.67	122832.0
2016-07-20 09:00:00	QQQ	ETF	112.67	112.81	112.67	112.74	249980.0
2016-07-20 09:30:00	QQQ	ETF	112.75	112.97	112.6	112.94	2544639.0
2016-07-20 10:00:00	QQQ	ETF	112.95	113.17	112.9	113.11	1518467.0
2016-07-20 10:30:00	QQQ	ETF	113.12	113.4	113.09	113.3742	1943204.0
2016-07-20 11:00:00	QQQ	ETF	113.375	113.495	113.295	113.4707	1122131.0
2016-07-20 11:30:00	QQQ	ETF	113.47	113.5	113.37	113.45	693535.0
2016-07-20 12:00:00	QQQ	ETF	113.45	113.48	113.381	113.43	682121.0
2016-07-20 12:30:00	QQQ	ETF	113.43	113.45	113.39	113.41	592092.0

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

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