PREVIEW / etf_5min / 2019-10-23

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-10-23.parquet
  size:    1.4 MB
  rows:    58,386

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-10-23 04:00:00	SPY	ETF	298.6	298.88	298.6	298.88	907.0
2019-10-23 04:05:00	SPY	ETF	298.9	299.0	298.9	298.98	2285.0
2019-10-23 04:10:00	SPY	ETF	298.85	298.91	298.85	298.9	2100.0
2019-10-23 04:15:00	SPY	ETF	298.92	298.92	298.9	298.9	640.0
2019-10-23 04:20:00	SPY	ETF	298.8	298.8	298.75	298.77	4029.0
2019-10-23 04:25:00	SPY	ETF	298.87	298.87	298.85	298.85	700.0
2019-10-23 04:30:00	SPY	ETF	298.75	298.75	298.75	298.75	100.0
2019-10-23 04:40:00	SPY	ETF	298.75	298.8	298.75	298.75	520.0
2019-10-23 04:45:00	SPY	ETF	298.77	298.77	298.7	298.7	900.0
2019-10-23 04:50:00	SPY	ETF	298.77	298.77	298.77	298.77	100.0
2019-10-23 04:55:00	SPY	ETF	298.75	298.75	298.75	298.75	100.0
2019-10-23 05:00:00	SPY	ETF	298.79	298.8	298.79	298.8	300.0
2019-10-23 05:10:00	SPY	ETF	298.77	298.83	298.73	298.83	1130.0
2019-10-23 05:25:00	SPY	ETF	298.75	298.76	298.75	298.76	1000.0
2019-10-23 05:30:00	SPY	ETF	298.68	298.68	298.65	298.65	660.0
2019-10-23 05:35:00	SPY	ETF	298.72	298.72	298.72	298.72	154.0
2019-10-23 05:40:00	SPY	ETF	298.68	298.69	298.68	298.69	200.0
2019-10-23 05:50:00	SPY	ETF	298.8	298.8	298.8	298.8	1005.0
2019-10-23 05:55:00	SPY	ETF	298.68	298.7	298.68	298.7	4700.0
2019-10-23 06:00:00	SPY	ETF	299.1	299.22	299.1	299.12	7070.0
2019-10-23 06:05:00	SPY	ETF	298.93	299.02	298.92	299.02	1100.0
2019-10-23 06:10:00	SPY	ETF	298.95	298.95	298.89	298.95	800.0
2019-10-23 06:15:00	SPY	ETF	298.98	299.03	298.95	298.95	1235.0
2019-10-23 06:20:00	SPY	ETF	298.88	298.88	298.88	298.88	1010.0
2019-10-23 06:25:00	SPY	ETF	298.96	299.0	298.94	298.94	3300.0
2019-10-23 06:30:00	SPY	ETF	298.87	298.87	298.65	298.65	4880.0
2019-10-23 06:35:00	SPY	ETF	298.69	298.7	298.56	298.66	27705.0
2019-10-23 06:40:00	SPY	ETF	298.7	298.71	298.62	298.62	16710.0
2019-10-23 06:45:00	SPY	ETF	298.62	298.62	298.41	298.41	4012.0
2019-10-23 06:50:00	SPY	ETF	298.41	298.41	298.24	298.3	8824.0
2019-10-23 06:55:00	SPY	ETF	298.27	298.37	298.27	298.3	7551.0
2019-10-23 07:00:00	SPY	ETF	298.35	298.4	298.32	298.34	15447.0
2019-10-23 07:05:00	SPY	ETF	298.42	298.49	298.42	298.46	11177.0
2019-10-23 07:10:00	SPY	ETF	298.48	298.49	298.47	298.48	3651.0
2019-10-23 07:15:00	SPY	ETF	298.47	298.47	298.17	298.19	14789.0
2019-10-23 07:20:00	SPY	ETF	298.2	298.2	298.01	298.08	40920.0
2019-10-23 07:25:00	SPY	ETF	298.05	298.2	298.05	298.09	8232.0
2019-10-23 07:30:00	SPY	ETF	298.06	298.18	297.92	298.13	73449.0
2019-10-23 07:35:00	SPY	ETF	298.13	298.24	298.13	298.18	29435.0
2019-10-23 07:40:00	SPY	ETF	298.18	298.32	298.18	298.32	9655.0
2019-10-23 07:45:00	SPY	ETF	298.34	298.42	298.31	298.39	29060.0
2019-10-23 07:50:00	SPY	ETF	298.45	298.51	298.39	298.44	30927.0
2019-10-23 07:55:00	SPY	ETF	298.43	298.44	298.35	298.44	3751.0
2019-10-23 08:00:00	SPY	ETF	298.46	298.65	297.97	298.44	35915.0
2019-10-23 08:05:00	SPY	ETF	298.4	298.5	298.28	298.49	8072.0
2019-10-23 08:10:00	SPY	ETF	298.52	298.56	298.49	298.51	28968.0
2019-10-23 08:15:00	SPY	ETF	298.51	298.51	298.42	298.42	11587.0
2019-10-23 08:20:00	SPY	ETF	298.43	298.46	298.42	298.46	1328.0
2019-10-23 08:25:00	SPY	ETF	298.45	298.7	298.44	298.69	26605.0
2019-10-23 08:30:00	SPY	ETF	298.72	298.72	298.63	298.68	26679.0

> showing 50 of 58,386 rows — these rows as CSV

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