PREVIEW / etf_5min / 2020-07-14

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-07-14.parquet
  size:    1.6 MB
  rows:    76,779

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-14 04:00:00	SPY	ETF	314.91	315.31	314.9	315.3	4346.0
2020-07-14 04:05:00	SPY	ETF	315.35	315.65	315.3	315.65	4290.0
2020-07-14 04:10:00	SPY	ETF	315.72	316.15	315.71	315.86	16784.0
2020-07-14 04:15:00	SPY	ETF	316.01	316.01	315.81	315.81	4614.0
2020-07-14 04:20:00	SPY	ETF	315.93	315.93	315.86	315.86	337.0
2020-07-14 04:25:00	SPY	ETF	315.79	316.05	315.79	316.05	1447.0
2020-07-14 04:30:00	SPY	ETF	316.03	316.03	315.92	315.92	365.0
2020-07-14 04:35:00	SPY	ETF	316.08	316.08	316.05	316.05	415.0
2020-07-14 04:40:00	SPY	ETF	316.1	316.18	316.1	316.18	255.0
2020-07-14 04:45:00	SPY	ETF	316.25	316.25	316.11	316.12	3645.0
2020-07-14 04:50:00	SPY	ETF	316.06	316.06	315.85	315.85	1436.0
2020-07-14 04:55:00	SPY	ETF	315.86	316.0	315.86	315.93	1130.0
2020-07-14 05:00:00	SPY	ETF	315.93	316.06	315.93	316.06	2288.0
2020-07-14 05:05:00	SPY	ETF	315.98	315.98	315.7	315.7	1526.0
2020-07-14 05:10:00	SPY	ETF	315.65	315.9	315.5	315.9	4469.0
2020-07-14 05:15:00	SPY	ETF	316.25	316.25	316.23	316.23	745.0
2020-07-14 05:20:00	SPY	ETF	316.13	316.15	316.05	316.05	2206.0
2020-07-14 05:25:00	SPY	ETF	316.1	316.3	316.03	316.3	14670.0
2020-07-14 05:30:00	SPY	ETF	316.23	316.23	316.05	316.08	901.0
2020-07-14 05:35:00	SPY	ETF	316.17	316.17	316.17	316.17	215.0
2020-07-14 05:40:00	SPY	ETF	316.06	316.06	316.06	316.06	200.0
2020-07-14 05:45:00	SPY	ETF	316.02	316.1	316.01	316.07	835.0
2020-07-14 05:50:00	SPY	ETF	316.0	316.0	315.92	315.92	620.0
2020-07-14 05:55:00	SPY	ETF	315.87	315.96	315.81	315.96	4449.0
2020-07-14 06:00:00	SPY	ETF	315.96	316.12	315.82	316.0	51370.0
2020-07-14 06:05:00	SPY	ETF	316.0	316.04	315.9	315.9	1334.0
2020-07-14 06:10:00	SPY	ETF	315.97	316.06	315.94	316.06	50700.0
2020-07-14 06:15:00	SPY	ETF	315.94	315.94	315.67	315.67	3192.0
2020-07-14 06:20:00	SPY	ETF	315.75	316.04	315.75	315.91	17460.0
2020-07-14 06:25:00	SPY	ETF	315.94	315.94	315.81	315.83	6380.0
2020-07-14 06:30:00	SPY	ETF	315.8	315.8	315.54	315.55	8227.0
2020-07-14 06:35:00	SPY	ETF	315.63	315.76	315.62	315.76	6614.0
2020-07-14 06:40:00	SPY	ETF	315.75	315.98	315.75	315.91	37754.0
2020-07-14 06:45:00	SPY	ETF	315.94	316.02	315.83	316.02	11472.0
2020-07-14 06:50:00	SPY	ETF	315.86	316.03	315.86	315.95	12850.0
2020-07-14 06:55:00	SPY	ETF	316.01	316.07	316.01	316.06	9047.0
2020-07-14 07:00:00	SPY	ETF	316.18	316.37	316.11	316.37	44764.0
2020-07-14 07:05:00	SPY	ETF	316.35	316.37	316.05	316.05	45976.0
2020-07-14 07:10:00	SPY	ETF	315.98	315.98	315.55	315.7	19022.0
2020-07-14 07:15:00	SPY	ETF	315.751	315.91	315.6	315.89	27867.0
2020-07-14 07:20:00	SPY	ETF	315.85	316.05	315.85	315.99	5952.0
2020-07-14 07:25:00	SPY	ETF	315.98	316.27	315.96	316.27	15032.0
2020-07-14 07:30:00	SPY	ETF	316.24	316.3	316.19	316.29	18031.0
2020-07-14 07:35:00	SPY	ETF	316.28	316.31	316.18	316.21	16357.0
2020-07-14 07:40:00	SPY	ETF	316.2	316.33	316.2	316.2	40238.0
2020-07-14 07:45:00	SPY	ETF	316.21	316.25	315.81	315.83	22376.0
2020-07-14 07:50:00	SPY	ETF	315.95	316.44	315.92	316.44	73289.0
2020-07-14 07:55:00	SPY	ETF	316.46	316.48	316.2	316.2	28611.0
2020-07-14 08:00:00	SPY	ETF	315.9804	316.5	314.9	316.26	264322.0
2020-07-14 08:05:00	SPY	ETF	316.3	316.39	316.24	316.27	25675.0

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

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