PREVIEW / etf_5min / 2019-08-08

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-08-08.parquet
  size:    1.5 MB
  rows:    65,197

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-08-08 04:00:00	SPY	ETF	288.7	288.71	288.68	288.71	7956.0
2019-08-08 04:05:00	SPY	ETF	288.67	288.67	288.57	288.57	1005.0
2019-08-08 04:10:00	SPY	ETF	288.23	288.23	288.18	288.18	672.0
2019-08-08 04:15:00	SPY	ETF	287.89	287.97	287.88	287.97	1920.0
2019-08-08 04:20:00	SPY	ETF	288.23	288.3	288.23	288.3	1470.0
2019-08-08 04:25:00	SPY	ETF	288.27	288.42	288.2	288.42	2986.0
2019-08-08 04:30:00	SPY	ETF	288.55	288.6	288.55	288.6	724.0
2019-08-08 04:40:00	SPY	ETF	288.4	288.49	288.4	288.49	1505.0
2019-08-08 04:45:00	SPY	ETF	288.64	288.82	288.64	288.78	2253.0
2019-08-08 04:50:00	SPY	ETF	288.7	288.7	288.55	288.63	1100.0
2019-08-08 05:00:00	SPY	ETF	288.62	288.62	288.4	288.54	2005.0
2019-08-08 05:05:00	SPY	ETF	288.7	288.86	288.7	288.82	7146.0
2019-08-08 05:10:00	SPY	ETF	288.71	288.78	288.71	288.78	400.0
2019-08-08 05:15:00	SPY	ETF	288.79	288.94	288.75	288.87	2880.0
2019-08-08 05:20:00	SPY	ETF	288.95	289.04	288.87	288.87	2662.0
2019-08-08 05:25:00	SPY	ETF	288.74	288.74	288.6	288.6	815.0
2019-08-08 05:30:00	SPY	ETF	288.6	288.64	288.58	288.63	2900.0
2019-08-08 05:35:00	SPY	ETF	288.82	288.82	288.82	288.82	101.0
2019-08-08 05:40:00	SPY	ETF	288.9	288.9	288.9	288.9	100.0
2019-08-08 05:45:00	SPY	ETF	288.74	288.78	288.74	288.78	1200.0
2019-08-08 05:50:00	SPY	ETF	288.79	288.8	288.79	288.8	1500.0
2019-08-08 05:55:00	SPY	ETF	288.74	288.74	288.74	288.74	300.0
2019-08-08 06:00:00	SPY	ETF	288.87	288.89	288.87	288.89	619.0
2019-08-08 06:05:00	SPY	ETF	289.0	289.0	288.99	288.99	295.0
2019-08-08 06:10:00	SPY	ETF	288.97	288.97	288.94	288.94	1400.0
2019-08-08 06:15:00	SPY	ETF	289.0	289.1	289.0	289.1	2400.0
2019-08-08 06:20:00	SPY	ETF	289.07	289.07	289.07	289.07	232.0
2019-08-08 06:30:00	SPY	ETF	288.95	288.95	288.8	288.8	1080.0
2019-08-08 06:35:00	SPY	ETF	288.83	288.83	288.65	288.65	720.0
2019-08-08 06:40:00	SPY	ETF	288.45	288.57	288.45	288.53	2658.0
2019-08-08 06:45:00	SPY	ETF	288.57	288.6	288.57	288.6	570.0
2019-08-08 06:50:00	SPY	ETF	288.5	288.5	288.44	288.44	2879.0
2019-08-08 06:55:00	SPY	ETF	288.4	288.49	288.4	288.45	6200.0
2019-08-08 07:00:00	SPY	ETF	288.41	288.45	288.35	288.45	12151.0
2019-08-08 07:05:00	SPY	ETF	288.42	288.47	288.2	288.28	7925.0
2019-08-08 07:10:00	SPY	ETF	288.24	288.32	288.19	288.19	10871.0
2019-08-08 07:15:00	SPY	ETF	288.16	288.22	288.1	288.15	15280.0
2019-08-08 07:20:00	SPY	ETF	288.27	288.29	288.22	288.22	8135.0
2019-08-08 07:25:00	SPY	ETF	288.26	288.48	288.19	288.46	65933.0
2019-08-08 07:30:00	SPY	ETF	288.39	288.54	288.39	288.5	11837.0
2019-08-08 07:35:00	SPY	ETF	288.45	288.5	288.42	288.48	71766.0
2019-08-08 07:40:00	SPY	ETF	288.46	288.59	288.21	288.21	30441.0
2019-08-08 07:45:00	SPY	ETF	288.21	288.35	288.15	288.15	13845.0
2019-08-08 07:50:00	SPY	ETF	288.18	288.28	288.1	288.15	16875.0
2019-08-08 07:55:00	SPY	ETF	288.18	288.41	288.1	288.4	12353.0
2019-08-08 08:00:00	SPY	ETF	288.41	289.14	288.1001	288.62	164640.0
2019-08-08 08:05:00	SPY	ETF	288.69	288.8699	288.59	288.81	106575.0
2019-08-08 08:10:00	SPY	ETF	288.83	288.83	288.75	288.81	15671.0
2019-08-08 08:15:00	SPY	ETF	288.8	288.8	288.66	288.74	23958.0
2019-08-08 08:20:00	SPY	ETF	288.76	288.79	288.55	288.56	40424.0

> showing 50 of 65,197 rows — these rows as CSV

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