PREVIEW / etf_5min / 2017-03-20

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-03-20.parquet
  size:    1.2 MB
  rows:    52,334

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-03-20 04:00:00	SPY	ETF	237.06	237.06	237.06	237.06	271.0
2017-03-20 04:10:00	SPY	ETF	236.94	236.94	236.94	236.94	100.0
2017-03-20 04:15:00	SPY	ETF	236.99	236.99	236.99	236.99	175.0
2017-03-20 04:35:00	SPY	ETF	237.07	237.07	237.07	237.07	300.0
2017-03-20 04:40:00	SPY	ETF	237.01	237.01	237.0	237.0	500.0
2017-03-20 04:50:00	SPY	ETF	236.96	236.96	236.95	236.95	824.0
2017-03-20 04:55:00	SPY	ETF	236.88	236.88	236.88	236.88	100.0
2017-03-20 05:05:00	SPY	ETF	236.91	236.91	236.91	236.91	199.0
2017-03-20 05:10:00	SPY	ETF	236.92	236.92	236.92	236.92	2600.0
2017-03-20 05:40:00	SPY	ETF	236.86	236.86	236.86	236.86	2500.0
2017-03-20 05:45:00	SPY	ETF	236.83	236.83	236.83	236.83	2000.0
2017-03-20 05:50:00	SPY	ETF	236.83	236.83	236.81	236.81	2500.0
2017-03-20 05:55:00	SPY	ETF	236.78	236.78	236.78	236.78	1000.0
2017-03-20 06:15:00	SPY	ETF	236.87	236.87	236.87	236.87	1402.0
2017-03-20 06:20:00	SPY	ETF	236.83	236.83	236.83	236.83	500.0
2017-03-20 06:25:00	SPY	ETF	236.85	236.85	236.85	236.85	600.0
2017-03-20 06:30:00	SPY	ETF	236.85	236.87	236.85	236.87	5700.0
2017-03-20 06:40:00	SPY	ETF	236.86	236.86	236.85	236.85	21000.0
2017-03-20 06:45:00	SPY	ETF	236.85	236.87	236.82	236.87	43405.0
2017-03-20 06:50:00	SPY	ETF	236.87	236.93	236.87	236.93	11907.0
2017-03-20 06:55:00	SPY	ETF	236.94	236.97	236.94	236.97	40094.0
2017-03-20 07:00:00	SPY	ETF	236.95	236.98	236.94	236.98	7000.0
2017-03-20 07:05:00	SPY	ETF	236.96	237.03	236.94	237.03	5721.0
2017-03-20 07:10:00	SPY	ETF	237.03	237.05	237.0	237.05	27271.0
2017-03-20 07:15:00	SPY	ETF	237.06	237.1	237.03	237.09	14855.0
2017-03-20 07:20:00	SPY	ETF	237.04	237.04	237.01	237.04	2401.0
2017-03-20 07:25:00	SPY	ETF	237.03	237.03	237.03	237.03	260.0
2017-03-20 07:30:00	SPY	ETF	237.04	237.04	237.01	237.01	1000.0
2017-03-20 07:35:00	SPY	ETF	237.02	237.02	236.99	236.99	16251.0
2017-03-20 07:40:00	SPY	ETF	237.01	237.03	237.01	237.03	450.0
2017-03-20 07:45:00	SPY	ETF	237.01	237.04	237.01	237.04	1891.0
2017-03-20 07:50:00	SPY	ETF	237.05	237.1	237.03	237.03	75109.0
2017-03-20 07:55:00	SPY	ETF	237.03	237.04	237.03	237.04	5800.0
2017-03-20 08:00:00	SPY	ETF	237.03	237.1	236.95	236.96	40348.0
2017-03-20 08:05:00	SPY	ETF	236.965	237.01	236.96	237.01	45692.0
2017-03-20 08:10:00	SPY	ETF	237.01	237.05	237.0	237.04	63989.0
2017-03-20 08:15:00	SPY	ETF	237.04	237.04	237.0	237.0	51820.0
2017-03-20 08:20:00	SPY	ETF	236.95	237.0	236.95	237.0	2502.0
2017-03-20 08:25:00	SPY	ETF	236.98	237.0	236.98	236.98	43502.0
2017-03-20 08:30:00	SPY	ETF	236.98	236.98	236.91	236.92	37997.0
2017-03-20 08:35:00	SPY	ETF	236.93	236.93	236.85	236.87	27593.0
2017-03-20 08:40:00	SPY	ETF	236.86	236.88	236.83	236.85	63634.0
2017-03-20 08:45:00	SPY	ETF	236.84	236.85	236.79	236.84	62175.0
2017-03-20 08:50:00	SPY	ETF	236.85	236.89	236.81	236.83	62950.0
2017-03-20 08:55:00	SPY	ETF	236.85	236.89	236.83	236.83	58841.0
2017-03-20 09:00:00	SPY	ETF	236.84	236.91	236.84	236.89	27551.0
2017-03-20 09:05:00	SPY	ETF	236.89	236.92	236.89	236.92	27591.0
2017-03-20 09:10:00	SPY	ETF	236.92	236.95	236.86	236.95	42340.0
2017-03-20 09:15:00	SPY	ETF	236.95	236.97	236.93	236.95	36096.0
2017-03-20 09:20:00	SPY	ETF	236.96	236.98	236.94	236.97	29053.0

> showing 50 of 52,334 rows — these rows as CSV

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