PREVIEW / etf_5min / 2018-03-21

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-03-21.parquet
  size:    1.3 MB
  rows:    56,681

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-03-21 04:00:00	SPY	ETF	271.35	271.36	271.3	271.33	3725.0
2018-03-21 04:05:00	SPY	ETF	271.32	271.32	271.18	271.18	1520.0
2018-03-21 04:10:00	SPY	ETF	271.15	271.15	271.15	271.15	400.0
2018-03-21 04:15:00	SPY	ETF	271.14	271.14	271.14	271.14	300.0
2018-03-21 04:35:00	SPY	ETF	271.07	271.07	271.07	271.07	300.0
2018-03-21 04:40:00	SPY	ETF	271.04	271.04	270.9	270.9	1978.0
2018-03-21 04:45:00	SPY	ETF	270.95	270.95	270.95	270.95	300.0
2018-03-21 04:50:00	SPY	ETF	270.95	270.97	270.95	270.97	800.0
2018-03-21 05:00:00	SPY	ETF	271.02	271.02	271.02	271.02	600.0
2018-03-21 05:05:00	SPY	ETF	270.92	270.95	270.92	270.95	400.0
2018-03-21 05:10:00	SPY	ETF	270.91	270.91	270.84	270.84	5320.0
2018-03-21 05:15:00	SPY	ETF	270.82	270.84	270.77	270.84	3106.0
2018-03-21 05:20:00	SPY	ETF	270.88	270.88	270.87	270.87	1220.0
2018-03-21 05:25:00	SPY	ETF	270.93	270.98	270.93	270.98	3320.0
2018-03-21 05:30:00	SPY	ETF	271.0	271.0	271.0	271.0	100.0
2018-03-21 05:40:00	SPY	ETF	271.0	271.0	271.0	271.0	100.0
2018-03-21 05:45:00	SPY	ETF	270.88	270.88	270.88	270.88	1500.0
2018-03-21 05:50:00	SPY	ETF	270.9	270.9	270.9	270.9	1788.0
2018-03-21 05:55:00	SPY	ETF	271.05	271.05	271.05	271.05	500.0
2018-03-21 06:00:00	SPY	ETF	271.07	271.14	271.07	271.14	1020.0
2018-03-21 06:05:00	SPY	ETF	271.08	271.08	270.96	270.96	300.0
2018-03-21 06:10:00	SPY	ETF	271.03	271.05	270.95	270.95	1420.0
2018-03-21 06:15:00	SPY	ETF	270.94	270.97	270.94	270.97	600.0
2018-03-21 06:20:00	SPY	ETF	271.05	271.05	271.05	271.05	200.0
2018-03-21 06:25:00	SPY	ETF	271.05	271.13	271.05	271.13	820.0
2018-03-21 06:30:00	SPY	ETF	271.17	271.25	271.17	271.25	720.0
2018-03-21 06:35:00	SPY	ETF	271.3	271.3	271.3	271.3	400.0
2018-03-21 06:40:00	SPY	ETF	271.32	271.32	271.27	271.28	20400.0
2018-03-21 06:45:00	SPY	ETF	271.3	271.36	271.3	271.36	1300.0
2018-03-21 06:50:00	SPY	ETF	271.31	271.31	271.31	271.31	1125.0
2018-03-21 06:55:00	SPY	ETF	271.34	271.35	271.23	271.25	2455.0
2018-03-21 07:00:00	SPY	ETF	271.24	271.27	271.23	271.27	2480.0
2018-03-21 07:05:00	SPY	ETF	271.23	271.23	271.16	271.16	2620.0
2018-03-21 07:10:00	SPY	ETF	271.16	271.27	271.13	271.18	26578.0
2018-03-21 07:15:00	SPY	ETF	271.29	271.37	271.29	271.36	10120.0
2018-03-21 07:20:00	SPY	ETF	271.34	271.34	271.34	271.34	140.0
2018-03-21 07:25:00	SPY	ETF	271.25	271.25	271.25	271.25	1000.0
2018-03-21 07:30:00	SPY	ETF	271.25	271.25	271.21	271.21	206.0
2018-03-21 07:35:00	SPY	ETF	271.25	271.26	271.25	271.25	660.0
2018-03-21 07:40:00	SPY	ETF	271.01	271.01	270.73	270.9	20764.0
2018-03-21 07:45:00	SPY	ETF	270.87	271.15	270.82	270.95	27230.0
2018-03-21 07:50:00	SPY	ETF	270.94	271.16	270.9	271.08	29995.0
2018-03-21 07:55:00	SPY	ETF	271.03	271.03	270.91	270.98	2940.0
2018-03-21 08:00:00	SPY	ETF	271.15	271.7	270.68	271.04	17219.0
2018-03-21 08:05:00	SPY	ETF	270.95	270.95	270.86	270.86	20862.0
2018-03-21 08:10:00	SPY	ETF	270.9	270.92	270.85	270.89	5152.0
2018-03-21 08:15:00	SPY	ETF	270.9	270.92	270.83	270.83	46650.0
2018-03-21 08:20:00	SPY	ETF	270.85	270.93	270.82	270.87	35811.0
2018-03-21 08:25:00	SPY	ETF	270.87	271.0	270.86	270.98	28340.0
2018-03-21 08:30:00	SPY	ETF	270.98	271.02	270.84	270.85	26376.0

> showing 50 of 56,681 rows — these rows as CSV

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