PREVIEW / etf_5min / 2020-01-31

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-01-31.parquet
  size:    1.7 MB
  rows:    72,287

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-01-31 04:00:00	SPY	ETF	327.33	327.48	327.21	327.44	1255.0
2020-01-31 04:05:00	SPY	ETF	327.39	327.4	327.29	327.38	1390.0
2020-01-31 04:10:00	SPY	ETF	327.27	327.36	327.27	327.28	780.0
2020-01-31 04:15:00	SPY	ETF	327.28	327.45	327.28	327.45	673.0
2020-01-31 04:20:00	SPY	ETF	327.42	327.42	327.42	327.42	421.0
2020-01-31 04:25:00	SPY	ETF	327.46	327.46	327.42	327.42	969.0
2020-01-31 04:30:00	SPY	ETF	327.48	327.48	327.23	327.23	3641.0
2020-01-31 04:35:00	SPY	ETF	327.16	327.16	326.94	326.94	9483.0
2020-01-31 04:40:00	SPY	ETF	326.95	327.08	326.95	327.07	1336.0
2020-01-31 04:45:00	SPY	ETF	327.11	327.16	327.11	327.16	1711.0
2020-01-31 04:50:00	SPY	ETF	327.16	327.16	327.14	327.14	601.0
2020-01-31 04:55:00	SPY	ETF	327.13	327.13	327.13	327.13	434.0
2020-01-31 05:00:00	SPY	ETF	327.11	327.16	326.89	327.16	6535.0
2020-01-31 05:05:00	SPY	ETF	327.16	327.26	327.16	327.26	1146.0
2020-01-31 05:10:00	SPY	ETF	327.15	327.16	326.85	326.96	6268.0
2020-01-31 05:15:00	SPY	ETF	326.98	326.98	326.89	326.89	1477.0
2020-01-31 05:20:00	SPY	ETF	326.83	326.85	326.43	326.43	15696.0
2020-01-31 05:25:00	SPY	ETF	326.5	326.58	326.31	326.38	7363.0
2020-01-31 05:30:00	SPY	ETF	326.31	326.31	326.03	326.06	6386.0
2020-01-31 05:35:00	SPY	ETF	326.08	326.28	326.08	326.21	9485.0
2020-01-31 05:40:00	SPY	ETF	326.21	326.21	326.15	326.2	3669.0
2020-01-31 05:45:00	SPY	ETF	326.23	326.5	326.23	326.5	977.0
2020-01-31 05:50:00	SPY	ETF	326.4	326.46	326.4	326.46	2000.0
2020-01-31 05:55:00	SPY	ETF	326.55	326.62	326.55	326.6	1277.0
2020-01-31 06:00:00	SPY	ETF	326.6	326.9	326.6	326.9	6137.0
2020-01-31 06:05:00	SPY	ETF	326.9	326.92	326.82	326.83	2290.0
2020-01-31 06:10:00	SPY	ETF	326.83	326.86	326.72	326.86	2105.0
2020-01-31 06:15:00	SPY	ETF	326.85	326.93	326.82	326.91	1255.0
2020-01-31 06:20:00	SPY	ETF	326.81	326.81	326.76	326.76	940.0
2020-01-31 06:25:00	SPY	ETF	326.7	326.7	326.43	326.55	24452.0
2020-01-31 06:30:00	SPY	ETF	326.52	326.83	326.45	326.83	22324.0
2020-01-31 06:35:00	SPY	ETF	326.74	326.74	326.57	326.63	27050.0
2020-01-31 06:40:00	SPY	ETF	326.71	326.72	326.71	326.72	1260.0
2020-01-31 06:45:00	SPY	ETF	326.61	326.7	326.5	326.7	1369.0
2020-01-31 06:50:00	SPY	ETF	326.71	326.77	326.7	326.77	2506.0
2020-01-31 06:55:00	SPY	ETF	326.75	326.87	326.75	326.82	1697.0
2020-01-31 07:00:00	SPY	ETF	326.82	327.1	326.77	327.0	39938.0
2020-01-31 07:05:00	SPY	ETF	327.02	327.02	326.93	327.0	11051.0
2020-01-31 07:10:00	SPY	ETF	327.17	327.27	327.14	327.269	15877.0
2020-01-31 07:15:00	SPY	ETF	327.32	327.32	327.28	327.32	3103.0
2020-01-31 07:20:00	SPY	ETF	327.31	327.35	327.23	327.24	7478.0
2020-01-31 07:25:00	SPY	ETF	327.18	327.27	327.1	327.12	29857.0
2020-01-31 07:30:00	SPY	ETF	327.22	327.3	327.22	327.29	18333.0
2020-01-31 07:35:00	SPY	ETF	327.28	327.39	327.26	327.37	25540.0
2020-01-31 07:40:00	SPY	ETF	327.36	327.45	327.31	327.35	12687.0
2020-01-31 07:45:00	SPY	ETF	327.3	327.3	327.06	327.08	12404.0
2020-01-31 07:50:00	SPY	ETF	327.09	327.09	326.95	326.99	48509.0
2020-01-31 07:55:00	SPY	ETF	327.02	327.04	327.0	327.04	13139.0
2020-01-31 08:00:00	SPY	ETF	326.92	329.0	326.72	326.84	59161.0
2020-01-31 08:05:00	SPY	ETF	326.84	326.92	326.75	326.85	18508.0

> showing 50 of 72,287 rows — these rows as CSV

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