PREVIEW / etf_5min / 2020-07-22

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-07-22.parquet
  size:    1.6 MB
  rows:    73,745

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-07-22 04:00:00	SPY	ETF	324.5	324.5	324.26	324.26	5250.0
2020-07-22 04:05:00	SPY	ETF	324.21	324.24	324.13	324.24	3218.0
2020-07-22 04:10:00	SPY	ETF	324.24	324.46	324.1	324.46	3638.0
2020-07-22 04:15:00	SPY	ETF	324.16	324.28	324.16	324.26	1280.0
2020-07-22 04:20:00	SPY	ETF	324.26	324.36	324.26	324.36	303.0
2020-07-22 04:25:00	SPY	ETF	324.29	324.29	324.29	324.29	259.0
2020-07-22 04:30:00	SPY	ETF	324.34	324.34	324.01	324.1	2040.0
2020-07-22 04:35:00	SPY	ETF	324.04	324.04	323.66	323.68	8474.0
2020-07-22 04:40:00	SPY	ETF	323.64	323.71	323.49	323.5	12504.0
2020-07-22 04:45:00	SPY	ETF	323.36	323.54	323.33	323.51	8114.0
2020-07-22 04:50:00	SPY	ETF	323.41	323.46	323.36	323.38	7504.0
2020-07-22 04:55:00	SPY	ETF	323.61	323.66	323.56	323.57	4336.0
2020-07-22 05:00:00	SPY	ETF	323.61	323.61	323.36	323.37	4407.0
2020-07-22 05:05:00	SPY	ETF	323.56	323.56	323.11	323.11	4587.0
2020-07-22 05:10:00	SPY	ETF	323.06	323.12	322.79	322.79	10635.0
2020-07-22 05:15:00	SPY	ETF	322.97	323.25	322.97	323.22	4560.0
2020-07-22 05:20:00	SPY	ETF	323.18	323.34	323.18	323.32	1760.0
2020-07-22 05:25:00	SPY	ETF	323.15	323.15	323.05	323.15	5100.0
2020-07-22 05:30:00	SPY	ETF	323.12	323.64	323.12	323.62	9538.0
2020-07-22 05:40:00	SPY	ETF	323.7	323.82	323.7	323.75	3418.0
2020-07-22 05:45:00	SPY	ETF	323.79	323.94	323.79	323.94	2950.0
2020-07-22 05:50:00	SPY	ETF	323.89	323.95	323.83	323.94	2567.0
2020-07-22 05:55:00	SPY	ETF	323.91	324.11	323.91	324.11	11203.0
2020-07-22 06:00:00	SPY	ETF	324.16	324.16	323.97	323.98	23218.0
2020-07-22 06:05:00	SPY	ETF	323.81	323.93	323.81	323.86	3180.0
2020-07-22 06:10:00	SPY	ETF	323.91	323.91	323.69	323.76	4401.0
2020-07-22 06:15:00	SPY	ETF	323.81	323.9	323.62	323.9	4941.0
2020-07-22 06:20:00	SPY	ETF	323.93	324.12	323.93	324.02	6160.0
2020-07-22 06:25:00	SPY	ETF	324.0	324.0	323.92	323.92	19308.0
2020-07-22 06:30:00	SPY	ETF	323.92	324.03	323.89	324.03	16103.0
2020-07-22 06:35:00	SPY	ETF	324.11	324.11	324.01	324.05	38506.0
2020-07-22 06:40:00	SPY	ETF	324.18	324.18	324.14	324.15	24178.0
2020-07-22 06:45:00	SPY	ETF	324.11	324.15	324.11	324.15	704.0
2020-07-22 06:50:00	SPY	ETF	324.21	324.21	323.95	324.12	29978.0
2020-07-22 06:55:00	SPY	ETF	324.12	324.37	324.12	324.14	20571.0
2020-07-22 07:00:00	SPY	ETF	324.22	324.56	324.17	324.51	66920.0
2020-07-22 07:05:00	SPY	ETF	324.51	324.58	324.36	324.55	11242.0
2020-07-22 07:10:00	SPY	ETF	324.64	324.64	324.34	324.34	71726.0
2020-07-22 07:15:00	SPY	ETF	324.34	324.6	324.34	324.57	11997.0
2020-07-22 07:20:00	SPY	ETF	324.62	324.62	324.52	324.56	3557.0
2020-07-22 07:25:00	SPY	ETF	324.7	324.82	324.59	324.65	110068.0
2020-07-22 07:30:00	SPY	ETF	324.66	324.73	324.49	324.49	54578.0
2020-07-22 07:35:00	SPY	ETF	324.49	324.62	324.45	324.58	50953.0
2020-07-22 07:40:00	SPY	ETF	324.57	324.79	324.55	324.78	13357.0
2020-07-22 07:45:00	SPY	ETF	324.76	324.84	324.71	324.78	7655.0
2020-07-22 07:50:00	SPY	ETF	324.76	324.8	324.69	324.74	7462.0
2020-07-22 07:55:00	SPY	ETF	324.78	324.85	324.71	324.75	13830.0
2020-07-22 08:00:00	SPY	ETF	324.76	326.3	323.7	324.64	81332.0
2020-07-22 08:05:00	SPY	ETF	324.62	324.85	324.5199	324.85	23051.0
2020-07-22 08:10:00	SPY	ETF	324.75	324.9	324.75	324.8	7326.0

> showing 50 of 73,745 rows — these rows as CSV

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