PREVIEW / etf_5min / 2019-08-26

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-08-26.parquet
  size:    1.4 MB
  rows:    62,977

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-26 04:00:00	SPY	ETF	286.7	287.0	286.48	286.48	17269.0
2019-08-26 04:05:00	SPY	ETF	286.57	286.58	286.37	286.49	6370.0
2019-08-26 04:10:00	SPY	ETF	286.55	286.91	286.5	286.88	15886.0
2019-08-26 04:15:00	SPY	ETF	286.9	287.17	286.86	287.01	6810.0
2019-08-26 04:20:00	SPY	ETF	287.3	287.36	287.28	287.28	1919.0
2019-08-26 04:25:00	SPY	ETF	287.19	287.19	287.1	287.1	1094.0
2019-08-26 04:30:00	SPY	ETF	287.01	287.2	286.99	287.2	1132.0
2019-08-26 04:35:00	SPY	ETF	287.31	287.94	287.31	287.93	9257.0
2019-08-26 04:40:00	SPY	ETF	287.94	288.08	287.87	287.9	6600.0
2019-08-26 04:45:00	SPY	ETF	287.9	287.9	287.65	287.71	7674.0
2019-08-26 04:50:00	SPY	ETF	287.73	287.88	287.73	287.88	1580.0
2019-08-26 04:55:00	SPY	ETF	287.98	287.98	287.88	287.91	4394.0
2019-08-26 05:00:00	SPY	ETF	287.98	287.98	287.7	287.7	5602.0
2019-08-26 05:05:00	SPY	ETF	287.92	287.92	287.72	287.76	3630.0
2019-08-26 05:10:00	SPY	ETF	287.73	288.01	287.73	288.0	18995.0
2019-08-26 05:15:00	SPY	ETF	287.9	287.9	287.85	287.86	3500.0
2019-08-26 05:20:00	SPY	ETF	287.77	287.87	287.75	287.87	9400.0
2019-08-26 05:25:00	SPY	ETF	287.84	287.84	287.54	287.62	3275.0
2019-08-26 05:30:00	SPY	ETF	287.62	287.84	287.5	287.84	2970.0
2019-08-26 05:35:00	SPY	ETF	287.87	288.73	287.87	288.4	17101.0
2019-08-26 05:40:00	SPY	ETF	288.19	288.48	288.19	288.48	6698.0
2019-08-26 05:45:00	SPY	ETF	288.37	288.67	288.37	288.54	6070.0
2019-08-26 05:50:00	SPY	ETF	288.6	288.62	286.54	286.94	50961.0
2019-08-26 05:55:00	SPY	ETF	287.11	287.31	286.76	286.9	27474.0
2019-08-26 06:00:00	SPY	ETF	287.02	287.02	286.66	286.89	10224.0
2019-08-26 06:05:00	SPY	ETF	286.95	287.02	286.9	287.02	6356.0
2019-08-26 06:10:00	SPY	ETF	287.0	287.39	287.0	287.21	20875.0
2019-08-26 06:15:00	SPY	ETF	287.18	287.5	287.18	287.5	9725.0
2019-08-26 06:20:00	SPY	ETF	287.49	287.49	286.95	287.11	18154.0
2019-08-26 06:25:00	SPY	ETF	287.03	287.11	286.97	286.97	4552.0
2019-08-26 06:30:00	SPY	ETF	287.08	287.1	286.86	286.91	10455.0
2019-08-26 06:35:00	SPY	ETF	286.97	286.97	286.71	286.86	9620.0
2019-08-26 06:40:00	SPY	ETF	286.9	287.22	286.66	287.15	41830.0
2019-08-26 06:45:00	SPY	ETF	287.32	287.32	286.87	286.96	25928.0
2019-08-26 06:50:00	SPY	ETF	286.95	287.24	286.93	287.1	46099.0
2019-08-26 06:55:00	SPY	ETF	286.91	287.01	286.79	287.01	11533.0
2019-08-26 07:00:00	SPY	ETF	286.93	286.98	286.71	286.95	54437.0
2019-08-26 07:05:00	SPY	ETF	286.9	286.98	286.88	286.98	18677.0
2019-08-26 07:10:00	SPY	ETF	286.9	286.97	286.85	286.87	73214.0
2019-08-26 07:15:00	SPY	ETF	286.9	286.98	286.85	286.9	112483.0
2019-08-26 07:20:00	SPY	ETF	286.92	287.16	286.88	287.08	31826.0
2019-08-26 07:25:00	SPY	ETF	287.17	287.35	287.16	287.35	13290.0
2019-08-26 07:30:00	SPY	ETF	287.33	287.4	287.2	287.33	49065.0
2019-08-26 07:35:00	SPY	ETF	287.34	287.77	287.34	287.57	67205.0
2019-08-26 07:40:00	SPY	ETF	287.58	287.87	287.58	287.68	36376.0
2019-08-26 07:45:00	SPY	ETF	287.64	287.64	287.27	287.32	80122.0
2019-08-26 07:50:00	SPY	ETF	287.32	287.37	287.15	287.2	48825.0
2019-08-26 07:55:00	SPY	ETF	287.2	287.28	287.08	287.1	81640.0
2019-08-26 08:00:00	SPY	ETF	287.05	287.8099	283.01	287.07	238315.0
2019-08-26 08:05:00	SPY	ETF	286.9	287.06	286.76	286.81	66378.0

> showing 50 of 62,977 rows — these rows as CSV

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