PREVIEW / etf_5min / 2017-05-17

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-05-17.parquet
  size:    1.4 MB
  rows:    60,087

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
2017-05-17 04:00:00	SPY	ETF	238.81	238.81	238.66	238.67	3319.0
2017-05-17 04:05:00	SPY	ETF	238.67	238.76	238.65	238.76	7150.0
2017-05-17 04:10:00	SPY	ETF	238.79	238.91	238.74	238.89	4415.0
2017-05-17 04:15:00	SPY	ETF	238.91	238.95	238.89	238.95	9540.0
2017-05-17 04:20:00	SPY	ETF	238.91	238.91	238.82	238.82	11060.0
2017-05-17 04:25:00	SPY	ETF	238.88	238.88	238.88	238.88	500.0
2017-05-17 04:30:00	SPY	ETF	238.84	238.88	238.84	238.88	200.0
2017-05-17 04:40:00	SPY	ETF	238.84	238.89	238.84	238.89	700.0
2017-05-17 04:50:00	SPY	ETF	238.9	238.9	238.9	238.9	400.0
2017-05-17 05:00:00	SPY	ETF	238.75	238.75	238.72	238.72	850.0
2017-05-17 05:05:00	SPY	ETF	238.67	238.7	238.64	238.7	1100.0
2017-05-17 05:10:00	SPY	ETF	238.73	238.73	238.65	238.65	500.0
2017-05-17 05:15:00	SPY	ETF	238.65	238.71	238.65	238.65	7750.0
2017-05-17 05:20:00	SPY	ETF	238.65	238.77	238.65	238.77	520.0
2017-05-17 05:25:00	SPY	ETF	238.72	238.72	238.65	238.67	1620.0
2017-05-17 05:30:00	SPY	ETF	238.67	238.67	238.67	238.67	2600.0
2017-05-17 05:35:00	SPY	ETF	238.64	238.64	238.6	238.6	1900.0
2017-05-17 05:40:00	SPY	ETF	238.61	238.66	238.61	238.66	8500.0
2017-05-17 05:50:00	SPY	ETF	238.65	238.65	238.65	238.65	500.0
2017-05-17 06:00:00	SPY	ETF	238.74	238.74	238.7	238.7	626.0
2017-05-17 06:10:00	SPY	ETF	238.75	238.75	238.71	238.71	720.0
2017-05-17 06:15:00	SPY	ETF	238.7	238.74	238.7	238.74	1500.0
2017-05-17 06:20:00	SPY	ETF	238.76	238.76	238.74	238.75	31221.0
2017-05-17 06:25:00	SPY	ETF	238.75	238.82	238.75	238.8	34475.0
2017-05-17 06:30:00	SPY	ETF	238.85	238.92	238.85	238.9	17210.0
2017-05-17 06:35:00	SPY	ETF	238.89	238.95	238.89	238.95	855.0
2017-05-17 06:40:00	SPY	ETF	239.0	239.0	238.89	238.9	42900.0
2017-05-17 06:45:00	SPY	ETF	238.9	238.91	238.87	238.91	1950.0
2017-05-17 06:50:00	SPY	ETF	238.93	238.97	238.93	238.97	9009.0
2017-05-17 06:55:00	SPY	ETF	238.97	239.02	238.95	239.02	10722.0
2017-05-17 07:00:00	SPY	ETF	239.0	239.04	238.94	239.02	100521.0
2017-05-17 07:05:00	SPY	ETF	239.03	239.09	239.01	239.07	30845.0
2017-05-17 07:10:00	SPY	ETF	239.07	239.14	239.03	239.14	26273.0
2017-05-17 07:15:00	SPY	ETF	239.12	239.13	239.08	239.11	10990.0
2017-05-17 07:20:00	SPY	ETF	239.11	239.13	239.09	239.12	5480.0
2017-05-17 07:25:00	SPY	ETF	239.13	239.15	239.03	239.04	38539.0
2017-05-17 07:30:00	SPY	ETF	239.06	239.06	239.03	239.04	3059.0
2017-05-17 07:35:00	SPY	ETF	239.02	239.02	238.95	238.95	20293.0
2017-05-17 07:40:00	SPY	ETF	238.98	239.0	238.95	238.97	20508.0
2017-05-17 07:45:00	SPY	ETF	238.96	238.98	238.96	238.98	19100.0
2017-05-17 07:50:00	SPY	ETF	238.95	239.0	238.95	239.0	4695.0
2017-05-17 07:55:00	SPY	ETF	239.0	239.01	238.95	238.95	10101.0
2017-05-17 08:00:00	SPY	ETF	239.0	239.12	238.9017	238.92	99959.0
2017-05-17 08:05:00	SPY	ETF	238.91	238.91	238.79	238.82	209407.0
2017-05-17 08:10:00	SPY	ETF	238.85	238.9	238.53	238.59	142419.0
2017-05-17 08:15:00	SPY	ETF	238.59	238.64	238.52	238.52	120181.0
2017-05-17 08:20:00	SPY	ETF	238.52	238.64	238.45	238.6	181312.0
2017-05-17 08:25:00	SPY	ETF	238.63	238.71	238.63	238.65	47981.0
2017-05-17 08:30:00	SPY	ETF	238.65	238.66	238.57	238.6	37415.0
2017-05-17 08:35:00	SPY	ETF	238.58	238.62	238.56	238.62	44436.0

> showing 50 of 60,087 rows — these rows as CSV

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