PREVIEW / etf_5min / 2020-05-06

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-05-06.parquet
  size:    1.6 MB
  rows:    72,926

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
2020-05-06 04:00:00	SPY	ETF	287.76	288.14	287.74	288.14	9040.0
2020-05-06 04:05:00	SPY	ETF	288.1	288.3	288.08	288.17	3975.0
2020-05-06 04:10:00	SPY	ETF	288.26	288.26	288.0	288.09	2374.0
2020-05-06 04:15:00	SPY	ETF	288.12	288.12	288.02	288.09	1450.0
2020-05-06 04:20:00	SPY	ETF	288.13	288.21	287.83	287.83	646.0
2020-05-06 04:25:00	SPY	ETF	287.89	287.89	287.68	287.68	755.0
2020-05-06 04:30:00	SPY	ETF	287.87	287.9	287.87	287.9	770.0
2020-05-06 04:35:00	SPY	ETF	288.0	288.15	288.0	288.09	1469.0
2020-05-06 04:40:00	SPY	ETF	287.68	287.68	287.67	287.67	1474.0
2020-05-06 04:45:00	SPY	ETF	287.58	287.58	287.58	287.58	525.0
2020-05-06 04:50:00	SPY	ETF	287.48	287.64	287.48	287.64	428.0
2020-05-06 04:55:00	SPY	ETF	287.63	287.94	287.63	287.94	3206.0
2020-05-06 05:00:00	SPY	ETF	288.03	288.03	287.92	287.92	1000.0
2020-05-06 05:05:00	SPY	ETF	287.87	288.04	287.87	288.04	1738.0
2020-05-06 05:10:00	SPY	ETF	288.21	288.21	288.06	288.06	776.0
2020-05-06 05:15:00	SPY	ETF	288.11	288.45	288.11	288.42	34705.0
2020-05-06 05:20:00	SPY	ETF	288.35	288.49	288.3	288.48	4607.0
2020-05-06 05:25:00	SPY	ETF	288.5	288.5	288.13	288.26	5670.0
2020-05-06 05:30:00	SPY	ETF	288.28	288.63	288.28	288.52	12898.0
2020-05-06 05:35:00	SPY	ETF	288.39	288.42	288.32	288.42	1413.0
2020-05-06 05:40:00	SPY	ETF	288.45	288.45	288.32	288.35	2710.0
2020-05-06 05:45:00	SPY	ETF	288.46	288.55	288.46	288.55	5100.0
2020-05-06 05:50:00	SPY	ETF	288.51	288.51	288.22	288.22	11340.0
2020-05-06 05:55:00	SPY	ETF	288.4	288.71	288.4	288.71	9884.0
2020-05-06 06:00:00	SPY	ETF	288.75	288.75	288.73	288.73	5271.0
2020-05-06 06:05:00	SPY	ETF	288.8	288.96	288.8	288.8	5416.0
2020-05-06 06:10:00	SPY	ETF	288.78	288.8	288.66	288.76	23146.0
2020-05-06 06:15:00	SPY	ETF	288.7	288.7	288.5	288.5	7076.0
2020-05-06 06:20:00	SPY	ETF	288.54	288.54	288.54	288.54	745.0
2020-05-06 06:25:00	SPY	ETF	288.5	288.7	288.5	288.6	2311.0
2020-05-06 06:30:00	SPY	ETF	288.6	288.6	288.57	288.57	1300.0
2020-05-06 06:35:00	SPY	ETF	288.65	288.85	288.65	288.81	7067.0
2020-05-06 06:40:00	SPY	ETF	288.72	288.72	288.62	288.7	5901.0
2020-05-06 06:45:00	SPY	ETF	288.6	288.87	288.6	288.85	8374.0
2020-05-06 06:50:00	SPY	ETF	288.66	288.66	288.55	288.59	13874.0
2020-05-06 06:55:00	SPY	ETF	288.56	288.65	288.56	288.65	1196.0
2020-05-06 07:00:00	SPY	ETF	288.66	288.75	288.38	288.47	72381.0
2020-05-06 07:05:00	SPY	ETF	288.38	288.52	288.33	288.34	8450.0
2020-05-06 07:10:00	SPY	ETF	288.3	288.44	288.3	288.39	17222.0
2020-05-06 07:15:00	SPY	ETF	288.4	288.45	288.4	288.42	7821.0
2020-05-06 07:20:00	SPY	ETF	288.4	288.4	288.35	288.4	1442.0
2020-05-06 07:25:00	SPY	ETF	288.4	288.4	288.35	288.37	30420.0
2020-05-06 07:30:00	SPY	ETF	288.38	288.43	288.36	288.38	3326.0
2020-05-06 07:35:00	SPY	ETF	288.36	288.36	288.04	288.15	22217.0
2020-05-06 07:40:00	SPY	ETF	288.15	288.21	287.96	287.97	39156.0
2020-05-06 07:45:00	SPY	ETF	288.0	288.1	287.94	288.04	15478.0
2020-05-06 07:50:00	SPY	ETF	288.08	288.09	287.95	287.95	19596.0
2020-05-06 07:55:00	SPY	ETF	287.97	287.99	287.78	287.78	18610.0
2020-05-06 08:00:00	SPY	ETF	288.35	288.7204	286.06	287.74	153281.0
2020-05-06 08:05:00	SPY	ETF	287.7	287.8	287.61	287.8	38633.0

> showing 50 of 72,926 rows — these rows as CSV

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