PREVIEW / etf_5min / 2018-04-18

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-04-18.parquet
  size:    1.3 MB
  rows:    58,461

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-04-18 04:00:00	SPY	ETF	270.63	270.63	270.63	270.63	1400.0
2018-04-18 04:05:00	SPY	ETF	270.8	270.8	270.77	270.77	1725.0
2018-04-18 04:10:00	SPY	ETF	270.82	270.82	270.8	270.8	1300.0
2018-04-18 04:25:00	SPY	ETF	270.88	270.88	270.88	270.88	100.0
2018-04-18 04:35:00	SPY	ETF	270.9	270.9	270.9	270.9	1500.0
2018-04-18 04:40:00	SPY	ETF	270.88	270.88	270.88	270.88	325.0
2018-04-18 04:45:00	SPY	ETF	270.9	270.9	270.83	270.83	3300.0
2018-04-18 04:55:00	SPY	ETF	270.8	270.8	270.77	270.77	500.0
2018-04-18 05:00:00	SPY	ETF	270.7	270.73	270.7	270.73	725.0
2018-04-18 05:05:00	SPY	ETF	270.7	270.7	270.7	270.7	500.0
2018-04-18 05:10:00	SPY	ETF	270.78	270.78	270.78	270.78	1000.0
2018-04-18 05:30:00	SPY	ETF	270.67	270.67	270.67	270.67	400.0
2018-04-18 05:50:00	SPY	ETF	270.68	270.68	270.68	270.68	330.0
2018-04-18 06:05:00	SPY	ETF	270.52	270.52	270.52	270.52	300.0
2018-04-18 06:10:00	SPY	ETF	270.59	270.62	270.59	270.62	650.0
2018-04-18 06:20:00	SPY	ETF	270.64	270.64	270.64	270.64	100.0
2018-04-18 06:25:00	SPY	ETF	270.72	270.73	270.72	270.72	3270.0
2018-04-18 06:35:00	SPY	ETF	270.73	270.73	270.73	270.73	100.0
2018-04-18 06:40:00	SPY	ETF	270.85	270.86	270.85	270.86	4040.0
2018-04-18 06:45:00	SPY	ETF	270.85	270.9	270.85	270.86	1705.0
2018-04-18 06:50:00	SPY	ETF	270.9	270.9	270.87	270.9	1855.0
2018-04-18 06:55:00	SPY	ETF	270.88	270.98	270.88	270.96	2429.0
2018-04-18 07:00:00	SPY	ETF	270.95	271.12	270.95	271.12	8483.0
2018-04-18 07:05:00	SPY	ETF	271.11	271.27	271.1	271.26	17009.0
2018-04-18 07:10:00	SPY	ETF	271.2	271.32	271.2	271.23	27628.0
2018-04-18 07:15:00	SPY	ETF	271.22	271.3	271.22	271.28	19725.0
2018-04-18 07:20:00	SPY	ETF	271.29	271.31	271.25	271.27	27289.0
2018-04-18 07:25:00	SPY	ETF	271.25	271.3	271.25	271.27	35324.0
2018-04-18 07:30:00	SPY	ETF	271.26	271.29	271.24	271.26	15835.0
2018-04-18 07:35:00	SPY	ETF	271.23	271.33	271.23	271.33	28119.0
2018-04-18 07:40:00	SPY	ETF	271.33	271.33	271.28	271.28	3680.0
2018-04-18 07:45:00	SPY	ETF	271.26	271.26	271.25	271.26	1985.0
2018-04-18 07:50:00	SPY	ETF	271.24	271.26	271.24	271.26	4250.0
2018-04-18 07:55:00	SPY	ETF	271.27	271.35	271.27	271.31	30047.0
2018-04-18 08:00:00	SPY	ETF	270.89	271.37	270.54	271.23	183919.0
2018-04-18 08:05:00	SPY	ETF	271.23	271.29	271.2	271.24	13474.0
2018-04-18 08:10:00	SPY	ETF	271.24	271.24	271.12	271.12	29423.0
2018-04-18 08:15:00	SPY	ETF	271.12	271.13	271.05	271.13	47278.0
2018-04-18 08:20:00	SPY	ETF	271.11	271.13	271.08	271.1	21229.0
2018-04-18 08:25:00	SPY	ETF	271.09	271.11	271.0	271.11	15159.0
2018-04-18 08:30:00	SPY	ETF	271.12	271.14	271.05	271.09	18321.0
2018-04-18 08:35:00	SPY	ETF	271.1	271.17	271.1	271.12	9064.0
2018-04-18 08:40:00	SPY	ETF	271.12	271.12	271.04	271.04	17290.0
2018-04-18 08:45:00	SPY	ETF	271.03	271.08	271.01	271.06	19113.0
2018-04-18 08:50:00	SPY	ETF	271.06	271.15	271.06	271.08	17869.0
2018-04-18 08:55:00	SPY	ETF	271.08	271.1	271.01	271.05	26214.0
2018-04-18 09:00:00	SPY	ETF	271.04	271.08	271.02	271.02	33036.0
2018-04-18 09:05:00	SPY	ETF	271.04	271.05	270.93	270.93	27017.0
2018-04-18 09:10:00	SPY	ETF	270.96	271.02	270.93	271.02	36324.0
2018-04-18 09:15:00	SPY	ETF	271.05	271.07	270.89	270.9	100203.0

> showing 50 of 58,461 rows — these rows as CSV

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