PREVIEW / etf_5min / 2018-05-23

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-05-23.parquet
  size:    1.3 MB
  rows:    57,143

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
2018-05-23 04:00:00	SPY	ETF	271.18	271.18	271.01	271.01	1673.0
2018-05-23 04:05:00	SPY	ETF	271.21	271.27	271.09	271.12	9226.0
2018-05-23 04:10:00	SPY	ETF	271.11	271.21	271.01	271.18	3610.0
2018-05-23 04:15:00	SPY	ETF	271.09	271.2	271.09	271.11	1880.0
2018-05-23 04:20:00	SPY	ETF	271.02	271.02	270.76	270.76	5405.0
2018-05-23 04:25:00	SPY	ETF	270.7	270.89	270.7	270.86	2657.0
2018-05-23 04:30:00	SPY	ETF	270.76	270.86	270.76	270.8	2420.0
2018-05-23 04:35:00	SPY	ETF	270.89	270.89	270.89	270.89	2630.0
2018-05-23 04:40:00	SPY	ETF	271.09	271.09	271.09	271.09	400.0
2018-05-23 04:45:00	SPY	ETF	271.06	271.09	271.06	271.09	830.0
2018-05-23 04:50:00	SPY	ETF	270.97	271.02	270.97	271.02	450.0
2018-05-23 04:55:00	SPY	ETF	271.04	271.04	270.81	270.87	500.0
2018-05-23 05:00:00	SPY	ETF	270.86	270.86	270.71	270.74	1200.0
2018-05-23 05:05:00	SPY	ETF	270.71	270.91	270.71	270.91	1920.0
2018-05-23 05:10:00	SPY	ETF	271.01	271.07	270.96	270.96	4600.0
2018-05-23 05:15:00	SPY	ETF	270.97	271.02	270.93	270.99	7200.0
2018-05-23 05:20:00	SPY	ETF	270.9	270.9	270.8	270.8	3743.0
2018-05-23 05:25:00	SPY	ETF	270.8	270.8	270.8	270.8	400.0
2018-05-23 05:30:00	SPY	ETF	270.82	270.82	270.72	270.72	6613.0
2018-05-23 05:35:00	SPY	ETF	270.72	270.72	270.69	270.69	1300.0
2018-05-23 05:40:00	SPY	ETF	270.69	270.7	270.6	270.6	4849.0
2018-05-23 05:45:00	SPY	ETF	270.66	270.71	270.61	270.71	53200.0
2018-05-23 05:50:00	SPY	ETF	270.79	270.9	270.79	270.86	57505.0
2018-05-23 05:55:00	SPY	ETF	270.78	270.78	270.67	270.72	22846.0
2018-05-23 06:00:00	SPY	ETF	270.78	270.88	270.78	270.84	4685.0
2018-05-23 06:05:00	SPY	ETF	270.84	270.96	270.84	270.9	7500.0
2018-05-23 06:10:00	SPY	ETF	270.92	270.92	270.88	270.89	10000.0
2018-05-23 06:15:00	SPY	ETF	270.92	270.95	270.87	270.87	2250.0
2018-05-23 06:20:00	SPY	ETF	270.77	270.85	270.7	270.85	25171.0
2018-05-23 06:25:00	SPY	ETF	270.94	270.98	270.91	270.95	5200.0
2018-05-23 06:30:00	SPY	ETF	270.95	270.98	270.95	270.98	2700.0
2018-05-23 06:35:00	SPY	ETF	271.02	271.02	271.02	271.02	100.0
2018-05-23 06:40:00	SPY	ETF	271.02	271.02	270.95	270.97	4583.0
2018-05-23 06:45:00	SPY	ETF	270.96	271.07	270.96	271.05	7800.0
2018-05-23 06:50:00	SPY	ETF	271.09	271.1	271.0	271.0	5700.0
2018-05-23 06:55:00	SPY	ETF	271.02	271.06	271.02	271.02	11210.0
2018-05-23 07:00:00	SPY	ETF	271.04	271.12	271.0	271.12	24312.0
2018-05-23 07:05:00	SPY	ETF	271.12	271.12	271.09	271.12	14785.0
2018-05-23 07:10:00	SPY	ETF	271.12	271.12	271.01	271.02	41303.0
2018-05-23 07:15:00	SPY	ETF	271.02	271.02	270.94	270.94	51030.0
2018-05-23 07:20:00	SPY	ETF	270.93	271.03	270.9	271.03	36516.0
2018-05-23 07:25:00	SPY	ETF	271.03	271.11	271.03	271.09	17726.0
2018-05-23 07:30:00	SPY	ETF	271.08	271.11	271.0	271.0	9640.0
2018-05-23 07:35:00	SPY	ETF	270.98	271.03	270.98	270.98	2220.0
2018-05-23 07:40:00	SPY	ETF	270.97	271.0	270.95	270.99	11100.0
2018-05-23 07:45:00	SPY	ETF	270.99	271.0	270.76	270.83	28791.0
2018-05-23 07:50:00	SPY	ETF	270.81	270.85	270.75	270.81	11913.0
2018-05-23 07:55:00	SPY	ETF	270.77	270.96	270.75	270.96	13525.0
2018-05-23 08:00:00	SPY	ETF	270.95	272.18	270.76	270.77	17379.0
2018-05-23 08:05:00	SPY	ETF	270.87	270.99	270.84	270.98	63067.0

> showing 50 of 57,143 rows — these rows as CSV

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