PREVIEW / etf_5min / 2019-05-17

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-05-17.parquet
  size:    1.3 MB
  rows:    59,008

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
2019-05-17 04:00:00	SPY	ETF	287.01	287.01	286.78	286.78	6190.0
2019-05-17 04:05:00	SPY	ETF	286.68	286.68	286.62	286.62	4958.0
2019-05-17 04:10:00	SPY	ETF	286.72	286.72	286.7	286.7	239.0
2019-05-17 04:20:00	SPY	ETF	286.67	286.67	286.67	286.67	141.0
2019-05-17 04:25:00	SPY	ETF	286.51	286.51	286.35	286.35	3222.0
2019-05-17 04:30:00	SPY	ETF	286.32	286.32	286.23	286.23	2454.0
2019-05-17 04:35:00	SPY	ETF	286.24	286.25	286.22	286.25	852.0
2019-05-17 04:40:00	SPY	ETF	286.15	286.23	286.15	286.23	5501.0
2019-05-17 04:45:00	SPY	ETF	286.26	286.26	286.26	286.26	444.0
2019-05-17 04:50:00	SPY	ETF	286.07	286.07	285.99	285.99	837.0
2019-05-17 04:55:00	SPY	ETF	286.0	286.05	286.0	286.05	326.0
2019-05-17 05:00:00	SPY	ETF	286.25	286.25	286.25	286.25	100.0
2019-05-17 05:05:00	SPY	ETF	286.13	286.23	286.0	286.0	3379.0
2019-05-17 05:10:00	SPY	ETF	286.2	286.2	286.18	286.18	220.0
2019-05-17 05:15:00	SPY	ETF	286.2	286.3	286.18	286.28	6702.0
2019-05-17 05:20:00	SPY	ETF	286.28	286.41	286.24	286.41	2981.0
2019-05-17 05:25:00	SPY	ETF	286.44	286.44	286.41	286.44	1702.0
2019-05-17 05:30:00	SPY	ETF	286.41	286.43	286.36	286.43	2814.0
2019-05-17 05:35:00	SPY	ETF	286.49	286.78	286.49	286.72	2894.0
2019-05-17 05:40:00	SPY	ETF	286.68	286.88	286.68	286.88	745.0
2019-05-17 05:45:00	SPY	ETF	286.83	286.83	286.73	286.73	2254.0
2019-05-17 05:50:00	SPY	ETF	286.83	286.83	286.63	286.63	2615.0
2019-05-17 05:55:00	SPY	ETF	286.72	286.72	286.61	286.61	13512.0
2019-05-17 06:00:00	SPY	ETF	286.61	286.61	286.49	286.55	4096.0
2019-05-17 06:05:00	SPY	ETF	286.55	286.56	286.51	286.53	11600.0
2019-05-17 06:10:00	SPY	ETF	286.49	286.51	286.37	286.37	5108.0
2019-05-17 06:15:00	SPY	ETF	286.35	286.42	286.35	286.4	3201.0
2019-05-17 06:20:00	SPY	ETF	286.5	286.6	286.5	286.52	2245.0
2019-05-17 06:25:00	SPY	ETF	286.49	286.49	286.44	286.44	1202.0
2019-05-17 06:30:00	SPY	ETF	286.52	286.52	286.49	286.49	895.0
2019-05-17 06:35:00	SPY	ETF	286.27	286.33	286.24	286.33	2646.0
2019-05-17 06:40:00	SPY	ETF	286.27	286.41	286.27	286.3	41463.0
2019-05-17 06:45:00	SPY	ETF	286.32	286.33	286.3	286.32	8250.0
2019-05-17 06:50:00	SPY	ETF	286.41	286.41	286.32	286.35	3100.0
2019-05-17 06:55:00	SPY	ETF	286.38	286.44	286.38	286.44	5597.0
2019-05-17 07:00:00	SPY	ETF	286.47	286.53	286.33	286.44	33054.0
2019-05-17 07:05:00	SPY	ETF	286.41	286.41	286.15	286.17	24197.0
2019-05-17 07:10:00	SPY	ETF	286.14	286.19	286.08	286.17	12875.0
2019-05-17 07:15:00	SPY	ETF	286.16	286.25	286.13	286.25	5387.0
2019-05-17 07:20:00	SPY	ETF	286.23	286.32	286.23	286.31	4658.0
2019-05-17 07:25:00	SPY	ETF	286.28	286.4	285.99	286.0	182647.0
2019-05-17 07:30:00	SPY	ETF	286.0	286.0	285.83	285.97	67460.0
2019-05-17 07:35:00	SPY	ETF	285.97	286.01	285.86	286.0	43472.0
2019-05-17 07:40:00	SPY	ETF	285.88	285.98	285.76	285.93	34967.0
2019-05-17 07:45:00	SPY	ETF	285.93	285.93	285.76	285.83	40425.0
2019-05-17 07:50:00	SPY	ETF	285.82	285.82	285.55	285.76	53282.0
2019-05-17 07:55:00	SPY	ETF	285.74	285.8	285.66	285.73	88365.0
2019-05-17 08:00:00	SPY	ETF	285.71	286.95	285.55	285.57	121277.0
2019-05-17 08:05:00	SPY	ETF	285.64	285.64	285.38	285.41	258848.0
2019-05-17 08:10:00	SPY	ETF	285.38	285.56	285.34	285.34	69060.0

> showing 50 of 59,008 rows — these rows as CSV

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