PREVIEW / etf_5min / 2019-08-01

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-08-01.parquet
  size:    1.6 MB
  rows:    67,369

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
2019-08-01 04:00:00	SPY	ETF	297.76	297.9	297.74	297.83	8020.0
2019-08-01 04:05:00	SPY	ETF	297.8	297.8	297.7	297.7	3340.0
2019-08-01 04:10:00	SPY	ETF	297.65	297.84	297.65	297.84	2000.0
2019-08-01 04:15:00	SPY	ETF	297.87	297.9	297.84	297.87	1281.0
2019-08-01 04:20:00	SPY	ETF	297.82	297.82	297.72	297.72	500.0
2019-08-01 04:30:00	SPY	ETF	297.64	297.64	297.64	297.64	340.0
2019-08-01 04:35:00	SPY	ETF	297.43	297.58	297.39	297.54	1160.0
2019-08-01 04:40:00	SPY	ETF	297.76	297.76	297.74	297.74	450.0
2019-08-01 04:45:00	SPY	ETF	297.71	297.78	297.71	297.78	1410.0
2019-08-01 04:50:00	SPY	ETF	297.68	297.81	297.66	297.79	1920.0
2019-08-01 04:55:00	SPY	ETF	297.81	297.81	297.76	297.76	6800.0
2019-08-01 05:00:00	SPY	ETF	297.73	297.81	297.73	297.8	5320.0
2019-08-01 05:05:00	SPY	ETF	297.89	298.35	297.89	298.35	3047.0
2019-08-01 05:10:00	SPY	ETF	298.25	298.3	298.23	298.3	3640.0
2019-08-01 05:15:00	SPY	ETF	298.26	298.3	298.15	298.16	29530.0
2019-08-01 05:20:00	SPY	ETF	298.11	298.12	298.11	298.11	600.0
2019-08-01 05:25:00	SPY	ETF	298.16	298.2	298.16	298.18	4745.0
2019-08-01 05:30:00	SPY	ETF	298.18	298.18	298.08	298.08	600.0
2019-08-01 05:35:00	SPY	ETF	298.16	298.16	298.16	298.16	1700.0
2019-08-01 05:40:00	SPY	ETF	298.18	298.21	298.18	298.18	1300.0
2019-08-01 05:45:00	SPY	ETF	298.28	298.28	298.28	298.28	200.0
2019-08-01 05:50:00	SPY	ETF	298.29	298.31	298.2	298.31	860.0
2019-08-01 05:55:00	SPY	ETF	298.35	298.38	298.28	298.32	4500.0
2019-08-01 06:00:00	SPY	ETF	298.31	298.33	298.31	298.33	750.0
2019-08-01 06:05:00	SPY	ETF	298.26	298.31	298.24	298.24	1450.0
2019-08-01 06:10:00	SPY	ETF	298.25	298.25	298.25	298.25	300.0
2019-08-01 06:15:00	SPY	ETF	298.25	298.31	298.25	298.31	1340.0
2019-08-01 06:20:00	SPY	ETF	298.23	298.28	298.23	298.28	650.0
2019-08-01 06:25:00	SPY	ETF	298.3	298.3	298.23	298.23	1700.0
2019-08-01 06:30:00	SPY	ETF	298.34	298.37	298.33	298.35	4133.0
2019-08-01 06:40:00	SPY	ETF	298.35	298.35	298.3	298.3	300.0
2019-08-01 06:45:00	SPY	ETF	298.22	298.22	298.13	298.13	875.0
2019-08-01 06:50:00	SPY	ETF	298.13	298.13	298.08	298.09	5532.0
2019-08-01 06:55:00	SPY	ETF	298.1	298.11	298.1	298.11	2250.0
2019-08-01 07:00:00	SPY	ETF	298.05	298.17	298.04	298.13	35931.0
2019-08-01 07:05:00	SPY	ETF	298.12	298.12	298.0	298.05	13085.0
2019-08-01 07:10:00	SPY	ETF	298.05	298.08	297.97	297.97	5025.0
2019-08-01 07:15:00	SPY	ETF	297.97	298.05	297.94	298.05	35617.0
2019-08-01 07:20:00	SPY	ETF	298.02	298.1	298.01	298.02	4485.0
2019-08-01 07:25:00	SPY	ETF	297.93	298.03	297.89	298.03	13913.0
2019-08-01 07:30:00	SPY	ETF	298.03	298.29	298.0	298.29	39291.0
2019-08-01 07:35:00	SPY	ETF	298.19	298.26	298.18	298.21	47251.0
2019-08-01 07:40:00	SPY	ETF	298.18	298.18	297.86	297.86	4215.0
2019-08-01 07:45:00	SPY	ETF	297.86	297.96	297.81	297.85	4122.0
2019-08-01 07:50:00	SPY	ETF	297.81	297.88	297.8	297.88	5579.0
2019-08-01 07:55:00	SPY	ETF	297.9	297.93	297.85	297.93	8607.0
2019-08-01 08:00:00	SPY	ETF	297.913	298.26	297.3	297.85	84852.0
2019-08-01 08:05:00	SPY	ETF	297.85	297.95	297.74	297.74	21648.0
2019-08-01 08:10:00	SPY	ETF	297.76	297.82	297.76	297.8	66993.0
2019-08-01 08:15:00	SPY	ETF	297.73	297.83	297.68	297.83	72932.0

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

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