PREVIEW / etf_5min / 2020-01-23

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-01-23.parquet
  size:    1.6 MB
  rows:    67,402

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-23 04:00:00	SPY	ETF	331.05	331.05	331.05	331.05	222.0
2020-01-23 04:10:00	SPY	ETF	331.13	331.13	330.98	331.03	1930.0
2020-01-23 04:20:00	SPY	ETF	331.09	331.09	331.09	331.09	10531.0
2020-01-23 04:25:00	SPY	ETF	331.09	331.09	331.08	331.08	13769.0
2020-01-23 04:30:00	SPY	ETF	331.15	331.15	331.14	331.14	400.0
2020-01-23 04:35:00	SPY	ETF	331.14	331.14	331.13	331.13	677.0
2020-01-23 04:40:00	SPY	ETF	331.06	331.06	331.02	331.06	2771.0
2020-01-23 04:45:00	SPY	ETF	331.06	331.12	331.02	331.12	920.0
2020-01-23 04:50:00	SPY	ETF	331.21	331.21	331.21	331.21	133.0
2020-01-23 04:55:00	SPY	ETF	331.14	331.14	331.12	331.12	400.0
2020-01-23 05:00:00	SPY	ETF	331.09	331.09	331.09	331.09	200.0
2020-01-23 05:05:00	SPY	ETF	331.09	331.1	331.09	331.1	10677.0
2020-01-23 05:10:00	SPY	ETF	331.1	331.1	331.1	331.1	673.0
2020-01-23 05:15:00	SPY	ETF	331.18	331.2	331.17	331.2	5892.0
2020-01-23 05:20:00	SPY	ETF	331.2	331.21	331.2	331.21	3193.0
2020-01-23 05:25:00	SPY	ETF	331.29	331.36	331.27	331.36	5493.0
2020-01-23 05:30:00	SPY	ETF	331.31	331.33	331.31	331.32	2578.0
2020-01-23 05:35:00	SPY	ETF	331.29	331.3	331.29	331.29	5851.0
2020-01-23 05:40:00	SPY	ETF	331.27	331.29	331.27	331.29	500.0
2020-01-23 05:45:00	SPY	ETF	331.27	331.27	331.27	331.27	1900.0
2020-01-23 05:50:00	SPY	ETF	331.24	331.26	331.24	331.26	4354.0
2020-01-23 05:55:00	SPY	ETF	331.26	331.3	331.26	331.3	3529.0
2020-01-23 06:00:00	SPY	ETF	331.31	331.33	331.31	331.32	5185.0
2020-01-23 06:05:00	SPY	ETF	331.37	331.38	331.26	331.26	2800.0
2020-01-23 06:15:00	SPY	ETF	331.23	331.24	331.2	331.2	1377.0
2020-01-23 06:20:00	SPY	ETF	331.16	331.21	331.16	331.2	1207.0
2020-01-23 06:25:00	SPY	ETF	331.2	331.21	331.2	331.2	5200.0
2020-01-23 06:30:00	SPY	ETF	331.2	331.22	331.2	331.22	1277.0
2020-01-23 06:35:00	SPY	ETF	331.22	331.22	331.22	331.22	4077.0
2020-01-23 06:40:00	SPY	ETF	331.15	331.15	331.15	331.15	800.0
2020-01-23 06:45:00	SPY	ETF	331.15	331.16	331.12	331.16	12206.0
2020-01-23 06:50:00	SPY	ETF	331.14	331.25	331.14	331.25	9423.0
2020-01-23 06:55:00	SPY	ETF	331.3	331.3	331.22	331.25	800.0
2020-01-23 07:00:00	SPY	ETF	331.25	331.35	331.24	331.31	52071.0
2020-01-23 07:05:00	SPY	ETF	331.29	331.34	331.26	331.26	1169.0
2020-01-23 07:10:00	SPY	ETF	331.23	331.25	331.15	331.2	10751.0
2020-01-23 07:15:00	SPY	ETF	331.13	331.2	331.12	331.2	7508.0
2020-01-23 07:20:00	SPY	ETF	331.17	331.2	331.15	331.15	4282.0
2020-01-23 07:25:00	SPY	ETF	331.08	331.1	331.0	331.04	6053.0
2020-01-23 07:30:00	SPY	ETF	331.02	331.02	330.7	330.71	30754.0
2020-01-23 07:35:00	SPY	ETF	330.86	330.86	330.78	330.78	13551.0
2020-01-23 07:40:00	SPY	ETF	330.78	330.83	330.75	330.82	23962.0
2020-01-23 07:45:00	SPY	ETF	330.78	330.95	330.77	330.9	25772.0
2020-01-23 07:50:00	SPY	ETF	330.81	330.81	330.74	330.77	5633.0
2020-01-23 07:55:00	SPY	ETF	330.75	330.82	330.72	330.8	38834.0
2020-01-23 08:00:00	SPY	ETF	331.3501	331.36	330.52	330.8	41882.0
2020-01-23 08:05:00	SPY	ETF	330.84	330.85	330.69	330.85	40181.0
2020-01-23 08:10:00	SPY	ETF	330.82	330.84	330.57	330.65	84768.0
2020-01-23 08:15:00	SPY	ETF	330.65	330.71	330.6	330.64	27290.0
2020-01-23 08:20:00	SPY	ETF	330.65	330.68	330.64	330.64	12802.0

> showing 50 of 67,402 rows — these rows as CSV

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