PREVIEW / etf_5min / 2020-04-17

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-04-17.parquet
  size:    1.8 MB
  rows:    79,633

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-04-17 04:00:00	SPY	ETF	286.15	286.7	286.15	286.67	25680.0
2020-04-17 04:05:00	SPY	ETF	286.58	287.52	286.51	287.52	12089.0
2020-04-17 04:10:00	SPY	ETF	287.54	287.54	286.88	286.88	30770.0
2020-04-17 04:15:00	SPY	ETF	286.93	287.05	286.66	287.0	24925.0
2020-04-17 04:20:00	SPY	ETF	286.95	287.01	286.55	286.6	10455.0
2020-04-17 04:25:00	SPY	ETF	286.55	286.61	286.21	286.32	21549.0
2020-04-17 04:30:00	SPY	ETF	286.3	286.41	286.01	286.41	16577.0
2020-04-17 04:35:00	SPY	ETF	286.32	286.63	286.09	286.14	37238.0
2020-04-17 04:40:00	SPY	ETF	286.11	286.5	286.0	286.46	5344.0
2020-04-17 04:45:00	SPY	ETF	286.46	286.64	286.46	286.64	2578.0
2020-04-17 04:50:00	SPY	ETF	286.81	286.84	286.33	286.43	16534.0
2020-04-17 04:55:00	SPY	ETF	286.29	286.52	285.95	285.98	19118.0
2020-04-17 05:00:00	SPY	ETF	285.97	286.16	285.7	286.01	29686.0
2020-04-17 05:05:00	SPY	ETF	286.16	286.24	285.79	285.82	22764.0
2020-04-17 05:10:00	SPY	ETF	286.24	286.69	286.1	286.51	18170.0
2020-04-17 05:15:00	SPY	ETF	286.51	286.62	286.05	286.12	6263.0
2020-04-17 05:20:00	SPY	ETF	286.17	286.43	285.97	285.97	6173.0
2020-04-17 05:25:00	SPY	ETF	285.97	286.09	285.88	285.91	4890.0
2020-04-17 05:30:00	SPY	ETF	285.9	286.04	285.56	285.86	11371.0
2020-04-17 05:35:00	SPY	ETF	285.92	286.32	285.92	286.3	4783.0
2020-04-17 05:40:00	SPY	ETF	286.41	286.6	286.36	286.36	16949.0
2020-04-17 05:45:00	SPY	ETF	286.5	286.74	286.1	286.67	12787.0
2020-04-17 05:50:00	SPY	ETF	286.79	287.41	286.79	287.29	33228.0
2020-04-17 05:55:00	SPY	ETF	287.04	287.07	286.76	286.81	14222.0
2020-04-17 06:00:00	SPY	ETF	286.98	287.13	286.68	286.68	15202.0
2020-04-17 06:05:00	SPY	ETF	286.7	287.0	286.7	287.0	8613.0
2020-04-17 06:10:00	SPY	ETF	287.1	287.42	287.06	287.18	19744.0
2020-04-17 06:15:00	SPY	ETF	287.14	287.68	287.1	287.68	15317.0
2020-04-17 06:20:00	SPY	ETF	287.75	287.85	287.56	287.81	9112.0
2020-04-17 06:25:00	SPY	ETF	287.83	287.87	287.48	287.56	22105.0
2020-04-17 06:30:00	SPY	ETF	287.52	287.7	287.45	287.6	59905.0
2020-04-17 06:35:00	SPY	ETF	287.55	287.85	287.41	287.83	48979.0
2020-04-17 06:40:00	SPY	ETF	287.8	287.83	287.44	287.44	63452.0
2020-04-17 06:45:00	SPY	ETF	287.38	287.51	287.2	287.51	14440.0
2020-04-17 06:50:00	SPY	ETF	287.6	287.81	287.45	287.7	44851.0
2020-04-17 06:55:00	SPY	ETF	287.7	287.7	287.45	287.65	102478.0
2020-04-17 07:00:00	SPY	ETF	287.56	288.05	287.54	287.98	57147.0
2020-04-17 07:05:00	SPY	ETF	287.98	288.13	287.74	287.78	83064.0
2020-04-17 07:10:00	SPY	ETF	287.77	287.82	287.46	287.5	95819.0
2020-04-17 07:15:00	SPY	ETF	287.52	287.6	287.16	287.16	63186.0
2020-04-17 07:20:00	SPY	ETF	287.16	287.37	287.1	287.1	104202.0
2020-04-17 07:25:00	SPY	ETF	287.13	287.34	287.09	287.17	31636.0
2020-04-17 07:30:00	SPY	ETF	287.25	287.25	286.64	286.7	133595.0
2020-04-17 07:35:00	SPY	ETF	286.74	287.0	286.64	286.8	203866.0
2020-04-17 07:40:00	SPY	ETF	286.81	286.89	286.64	286.89	49873.0
2020-04-17 07:45:00	SPY	ETF	286.99	287.25	286.99	287.12	40501.0
2020-04-17 07:50:00	SPY	ETF	287.13	287.37	287.07	287.37	75628.0
2020-04-17 07:55:00	SPY	ETF	287.39	287.45	287.13	287.13	33763.0
2020-04-17 08:00:00	SPY	ETF	288.0399	288.5	285.91	286.87	572291.0
2020-04-17 08:05:00	SPY	ETF	286.8802	287.1399	286.75	287.1	39532.0

> showing 50 of 79,633 rows — these rows as CSV

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