PREVIEW / etf_5min / 2020-05-01

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-05-01.parquet
  size:    1.7 MB
  rows:    76,786

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-01 04:00:00	SPY	ETF	284.39	284.42	284.0	284.0	19947.0
2020-05-01 04:05:00	SPY	ETF	283.99	284.14	283.68	284.14	7924.0
2020-05-01 04:10:00	SPY	ETF	284.21	284.44	284.14	284.44	9457.0
2020-05-01 04:15:00	SPY	ETF	284.4	284.67	284.4	284.63	7881.0
2020-05-01 04:20:00	SPY	ETF	284.63	284.9	284.58	284.82	14587.0
2020-05-01 04:25:00	SPY	ETF	284.8	284.86	284.8	284.85	795.0
2020-05-01 04:30:00	SPY	ETF	284.8	285.0	284.8	285.0	2252.0
2020-05-01 04:35:00	SPY	ETF	284.84	285.14	284.83	284.99	17492.0
2020-05-01 04:40:00	SPY	ETF	284.88	284.9	284.55	284.72	17129.0
2020-05-01 04:45:00	SPY	ETF	284.8	284.8	284.62	284.62	537.0
2020-05-01 04:50:00	SPY	ETF	284.95	285.26	284.94	285.08	27945.0
2020-05-01 04:55:00	SPY	ETF	285.08	285.33	285.02	285.18	25007.0
2020-05-01 05:00:00	SPY	ETF	285.24	285.31	285.01	285.21	8462.0
2020-05-01 05:05:00	SPY	ETF	285.16	285.29	285.07	285.07	4270.0
2020-05-01 05:10:00	SPY	ETF	285.11	285.11	284.93	285.06	1629.0
2020-05-01 05:15:00	SPY	ETF	284.8	284.81	284.76	284.81	2705.0
2020-05-01 05:20:00	SPY	ETF	284.72	284.76	284.58	284.62	6156.0
2020-05-01 05:25:00	SPY	ETF	284.6	284.91	284.6	284.82	13110.0
2020-05-01 05:30:00	SPY	ETF	284.87	284.87	284.39	284.39	899.0
2020-05-01 05:35:00	SPY	ETF	284.55	284.76	284.52	284.76	2331.0
2020-05-01 05:40:00	SPY	ETF	284.66	284.7	284.6	284.6	961.0
2020-05-01 05:45:00	SPY	ETF	284.56	284.56	284.42	284.52	1630.0
2020-05-01 05:50:00	SPY	ETF	284.57	284.72	284.57	284.72	335.0
2020-05-01 05:55:00	SPY	ETF	284.85	284.85	284.78	284.78	739.0
2020-05-01 06:00:00	SPY	ETF	284.64	285.1	284.64	285.1	33388.0
2020-05-01 06:05:00	SPY	ETF	285.05	285.05	284.87	284.99	1365.0
2020-05-01 06:10:00	SPY	ETF	284.98	285.08	284.98	285.06	2316.0
2020-05-01 06:15:00	SPY	ETF	285.15	285.32	285.04	285.32	1237.0
2020-05-01 06:20:00	SPY	ETF	285.36	285.36	285.19	285.19	2440.0
2020-05-01 06:25:00	SPY	ETF	285.14	285.26	285.08	285.16	42571.0
2020-05-01 06:30:00	SPY	ETF	285.09	285.26	285.07	285.26	17271.0
2020-05-01 06:35:00	SPY	ETF	285.2	285.26	284.95	284.95	12467.0
2020-05-01 06:40:00	SPY	ETF	284.94	285.05	284.9	285.0	13537.0
2020-05-01 06:45:00	SPY	ETF	285.0	285.23	284.7	284.7	31750.0
2020-05-01 06:50:00	SPY	ETF	284.78	284.86	284.63	284.73	16800.0
2020-05-01 06:55:00	SPY	ETF	284.71	284.96	284.66	284.96	17122.0
2020-05-01 07:00:00	SPY	ETF	284.97	285.02	284.86	284.93	31206.0
2020-05-01 07:05:00	SPY	ETF	284.94	285.0	284.5	284.83	38656.0
2020-05-01 07:10:00	SPY	ETF	284.76	284.81	284.6	284.65	25604.0
2020-05-01 07:15:00	SPY	ETF	284.65	284.83	284.57	284.64	19492.0
2020-05-01 07:20:00	SPY	ETF	284.62	284.62	284.1	284.1	32746.0
2020-05-01 07:25:00	SPY	ETF	284.08	284.3	284.03	284.25	38186.0
2020-05-01 07:30:00	SPY	ETF	284.09	284.36	283.97	284.22	77899.0
2020-05-01 07:35:00	SPY	ETF	284.29	284.43	284.24	284.4	38570.0
2020-05-01 07:40:00	SPY	ETF	284.39	284.8	284.39	284.71	77285.0
2020-05-01 07:45:00	SPY	ETF	284.7	285.01	284.68	284.94	49617.0
2020-05-01 07:50:00	SPY	ETF	284.91	285.0	284.8	284.95	61903.0
2020-05-01 07:55:00	SPY	ETF	284.88	284.88	284.66	284.78	53225.0
2020-05-01 08:00:00	SPY	ETF	284.79	286.88	283.79	284.43	147123.0
2020-05-01 08:05:00	SPY	ETF	284.43	284.77	284.37	284.67	61288.0

> showing 50 of 76,786 rows — these rows as CSV

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