PREVIEW / etf_5min / 2019-08-13

all etf 5-min files

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

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-13 04:00:00	SPY	ETF	287.2	287.49	287.2	287.32	5033.0
2019-08-13 04:05:00	SPY	ETF	287.3	287.37	287.22	287.22	801.0
2019-08-13 04:10:00	SPY	ETF	287.15	287.43	287.12	287.43	2650.0
2019-08-13 04:15:00	SPY	ETF	287.6	287.6	287.6	287.6	100.0
2019-08-13 04:20:00	SPY	ETF	287.48	287.6	287.48	287.6	1830.0
2019-08-13 04:25:00	SPY	ETF	287.55	287.55	287.5	287.5	990.0
2019-08-13 04:30:00	SPY	ETF	287.47	287.7	287.4	287.7	1204.0
2019-08-13 04:35:00	SPY	ETF	287.69	287.77	287.69	287.77	350.0
2019-08-13 04:40:00	SPY	ETF	288.0	288.0	287.79	287.93	477.0
2019-08-13 04:50:00	SPY	ETF	287.98	288.02	287.88	288.02	350.0
2019-08-13 05:00:00	SPY	ETF	287.88	287.88	287.62	287.62	969.0
2019-08-13 05:10:00	SPY	ETF	287.7	287.7	287.1	287.19	2808.0
2019-08-13 05:15:00	SPY	ETF	287.16	287.16	286.96	287.08	4537.0
2019-08-13 05:20:00	SPY	ETF	286.93	286.93	286.88	286.88	1612.0
2019-08-13 05:25:00	SPY	ETF	286.88	286.88	286.78	286.88	1220.0
2019-08-13 05:30:00	SPY	ETF	286.72	286.72	286.5	286.53	3700.0
2019-08-13 05:35:00	SPY	ETF	286.5	286.8	286.5	286.8	9774.0
2019-08-13 05:40:00	SPY	ETF	286.68	286.9	286.66	286.8	6499.0
2019-08-13 05:45:00	SPY	ETF	286.88	286.93	286.88	286.93	200.0
2019-08-13 05:50:00	SPY	ETF	286.97	286.97	286.75	286.75	2708.0
2019-08-13 05:55:00	SPY	ETF	286.99	286.99	286.78	286.78	910.0
2019-08-13 06:00:00	SPY	ETF	286.82	286.98	286.82	286.98	714.0
2019-08-13 06:15:00	SPY	ETF	287.01	287.01	286.66	286.66	1131.0
2019-08-13 06:20:00	SPY	ETF	286.98	287.29	286.98	287.29	6389.0
2019-08-13 06:25:00	SPY	ETF	287.32	287.38	287.32	287.38	1554.0
2019-08-13 06:30:00	SPY	ETF	287.29	287.3	287.19	287.19	15050.0
2019-08-13 06:35:00	SPY	ETF	287.21	287.65	287.2	287.65	13909.0
2019-08-13 06:40:00	SPY	ETF	287.45	287.47	287.42	287.47	3410.0
2019-08-13 06:50:00	SPY	ETF	287.6	287.6	287.6	287.6	15020.0
2019-08-13 06:55:00	SPY	ETF	287.55	287.67	287.55	287.66	12760.0
2019-08-13 07:00:00	SPY	ETF	287.68	287.88	287.65	287.78	17962.0
2019-08-13 07:05:00	SPY	ETF	287.7	287.78	287.54	287.78	40946.0
2019-08-13 07:10:00	SPY	ETF	287.74	287.74	287.59	287.59	46518.0
2019-08-13 07:15:00	SPY	ETF	287.53	287.59	287.44	287.58	28604.0
2019-08-13 07:20:00	SPY	ETF	287.51	287.54	287.4	287.4	30119.0
2019-08-13 07:25:00	SPY	ETF	287.33	287.35	287.22	287.32	41997.0
2019-08-13 07:30:00	SPY	ETF	287.35	287.35	287.1	287.13	13150.0
2019-08-13 07:35:00	SPY	ETF	287.13	287.28	287.13	287.2	7295.0
2019-08-13 07:40:00	SPY	ETF	287.15	287.23	287.09	287.19	10087.0
2019-08-13 07:45:00	SPY	ETF	287.13	287.15	286.99	287.05	66809.0
2019-08-13 07:50:00	SPY	ETF	287.05	287.24	287.05	287.24	10892.0
2019-08-13 07:55:00	SPY	ETF	287.27	287.27	287.16	287.18	5100.0
2019-08-13 08:00:00	SPY	ETF	287.7799	288.43	286.99	287.03	50920.0
2019-08-13 08:05:00	SPY	ETF	287.03	287.1	287.0	287.05	51840.0
2019-08-13 08:10:00	SPY	ETF	287.04	287.14	286.98	287.1	27055.0
2019-08-13 08:15:00	SPY	ETF	287.1	287.27	286.99	287.25	77671.0
2019-08-13 08:20:00	SPY	ETF	287.25	287.25	287.05	287.21	29634.0
2019-08-13 08:25:00	SPY	ETF	287.19	287.4	287.19	287.4	54170.0
2019-08-13 08:30:00	SPY	ETF	287.4	287.4	286.82	287.0	171817.0
2019-08-13 08:35:00	SPY	ETF	287.0	287.0	286.55	286.94	112880.0

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

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