PREVIEW / etf_30min / 2016-11-29

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-11-29.parquet
  size:    427 KB
  rows:    14,543

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-11-29 04:00:00	SPY	ETF	220.84	221.05	220.84	221.04	12746.0
2016-11-29 04:30:00	SPY	ETF	221.1	221.1	220.97	220.97	2409.0
2016-11-29 05:00:00	SPY	ETF	221.0	221.0	220.8	220.8	1000.0
2016-11-29 05:30:00	SPY	ETF	220.8	220.83	220.79	220.83	4700.0
2016-11-29 06:00:00	SPY	ETF	220.83	220.9	220.83	220.89	2105.0
2016-11-29 06:30:00	SPY	ETF	220.98	220.98	220.89	220.89	3699.0
2016-11-29 07:00:00	SPY	ETF	220.89	221.05	220.86	221.04	72917.0
2016-11-29 07:30:00	SPY	ETF	221.04	221.04	220.82	220.85	183147.0
2016-11-29 08:00:00	SPY	ETF	220.83	221.0	220.71	220.85	1459672.0
2016-11-29 08:30:00	SPY	ETF	220.86	220.94	220.56	220.64	391398.0
2016-11-29 09:00:00	SPY	ETF	220.6	220.66	220.36	220.53	521797.0
2016-11-29 09:30:00	SPY	ETF	220.52	220.78	220.17	220.291	6981830.0
2016-11-29 10:00:00	SPY	ETF	220.3	220.7	220.3	220.57	5173167.0
2016-11-29 10:30:00	SPY	ETF	220.58	221.02	220.56	221.0	4810675.0
2016-11-29 11:00:00	SPY	ETF	221.01	221.05	220.82	221.01	4208022.0
2016-11-29 11:30:00	SPY	ETF	221.02	221.31	221.0	221.275	4942883.0
2016-11-29 12:00:00	SPY	ETF	221.27	221.275	221.0	221.0761	1931928.0
2016-11-29 12:30:00	SPY	ETF	221.08	221.27	221.03	221.27	2066744.0
2016-11-29 13:00:00	SPY	ETF	221.27	221.27	221.12	221.19	1452633.0
2016-11-29 13:30:00	SPY	ETF	221.19	221.37	221.14	221.31	2407708.0
2016-11-29 14:00:00	SPY	ETF	221.32	221.36	221.26	221.27	1921139.0
2016-11-29 14:30:00	SPY	ETF	221.278	221.44	221.21	221.2375	6019889.0
2016-11-29 15:00:00	SPY	ETF	221.24	221.25	220.84	220.92	4971632.0
2016-11-29 15:30:00	SPY	ETF	220.92	220.93	220.65	220.89	11856165.0
2016-11-29 16:00:00	SPY	ETF	220.88	220.93	220.82	220.82	6208176.0
2016-11-29 16:30:00	SPY	ETF	220.85	220.91	220.81	220.82	524631.0
2016-11-29 17:00:00	SPY	ETF	220.84	220.88	220.83	220.88	12536.0
2016-11-29 17:30:00	SPY	ETF	220.87	220.9	220.85	220.85	163115.0
2016-11-29 18:00:00	SPY	ETF	220.84	220.92	220.83	220.85	80600.0
2016-11-29 18:30:00	SPY	ETF	220.86	220.89	220.82	220.88	47138.0
2016-11-29 19:00:00	SPY	ETF	220.91	220.92	220.85	220.89	4830.0
2016-11-29 19:30:00	SPY	ETF	220.9	220.9	220.86	220.88	11679.0
2016-11-29 04:00:00	QQQ	ETF	118.79	118.8	118.79	118.79	1300.0
2016-11-29 05:00:00	QQQ	ETF	118.82	118.82	118.8	118.8	1497.0
2016-11-29 05:30:00	QQQ	ETF	118.76	118.76	118.75	118.75	1000.0
2016-11-29 06:30:00	QQQ	ETF	118.83	118.83	118.81	118.81	600.0
2016-11-29 07:00:00	QQQ	ETF	118.77	118.77	118.77	118.77	961.0
2016-11-29 07:30:00	QQQ	ETF	118.86	118.86	118.73	118.75	5328.0
2016-11-29 08:00:00	QQQ	ETF	118.75	118.75	118.68	118.75	7122.0
2016-11-29 08:30:00	QQQ	ETF	118.76	118.76	118.56	118.59	21030.0
2016-11-29 09:00:00	QQQ	ETF	118.58	118.62	118.54	118.62	27800.0
2016-11-29 09:30:00	QQQ	ETF	118.63	118.76	118.3	118.46	1607369.0
2016-11-29 10:00:00	QQQ	ETF	118.46	118.82	118.45	118.77	1078443.0
2016-11-29 10:30:00	QQQ	ETF	118.7799	119.06	118.76	119.04	1026778.0
2016-11-29 11:00:00	QQQ	ETF	119.04	119.09	118.9	119.06	535027.0
2016-11-29 11:30:00	QQQ	ETF	119.06	119.51	119.06	119.502	1585800.0
2016-11-29 12:00:00	QQQ	ETF	119.51	119.51	119.3001	119.36	1192944.0
2016-11-29 12:30:00	QQQ	ETF	119.36	119.45	119.32	119.43	938536.0
2016-11-29 13:00:00	QQQ	ETF	119.44	119.44	119.26	119.32	611590.0
2016-11-29 13:30:00	QQQ	ETF	119.33	119.465	119.28	119.412	681964.0

> showing 50 of 14,543 rows — these rows as CSV

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