PREVIEW / etf_5min / 2021-07-14

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-07-14.parquet
  size:    1.7 MB
  rows:    79,891

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
2021-07-14 04:00:00	SPY	ETF	435.12	435.18	435.09	435.18	1140.0
2021-07-14 04:05:00	SPY	ETF	435.13	435.13	434.82	434.86	1200.0
2021-07-14 04:10:00	SPY	ETF	434.82	434.89	434.8	434.89	500.0
2021-07-14 04:15:00	SPY	ETF	435.06	435.08	435.06	435.08	1100.0
2021-07-14 04:20:00	SPY	ETF	435.21	435.49	435.21	435.49	2000.0
2021-07-14 04:25:00	SPY	ETF	435.5	435.5	435.32	435.32	2885.0
2021-07-14 04:30:00	SPY	ETF	435.42	435.42	435.33	435.4	710.0
2021-07-14 04:35:00	SPY	ETF	435.48	435.48	435.48	435.48	100.0
2021-07-14 04:40:00	SPY	ETF	435.51	435.51	435.45	435.47	3800.0
2021-07-14 04:45:00	SPY	ETF	435.14	435.14	435.14	435.14	100.0
2021-07-14 04:50:00	SPY	ETF	435.2	435.2	435.2	435.2	100.0
2021-07-14 04:55:00	SPY	ETF	435.26	435.26	435.26	435.26	400.0
2021-07-14 05:05:00	SPY	ETF	435.56	435.59	435.51	435.54	7599.0
2021-07-14 05:10:00	SPY	ETF	435.54	435.65	435.53	435.65	6925.0
2021-07-14 05:15:00	SPY	ETF	435.66	435.69	435.64	435.69	2298.0
2021-07-14 05:20:00	SPY	ETF	435.69	435.7	435.69	435.7	1500.0
2021-07-14 05:25:00	SPY	ETF	435.76	435.76	435.71	435.71	227.0
2021-07-14 05:30:00	SPY	ETF	435.83	436.0	435.79	436.0	8467.0
2021-07-14 05:35:00	SPY	ETF	435.87	435.97	435.8	435.8	2600.0
2021-07-14 05:45:00	SPY	ETF	435.99	435.99	435.85	435.85	1300.0
2021-07-14 05:50:00	SPY	ETF	435.9	435.97	435.85	435.86	11198.0
2021-07-14 05:55:00	SPY	ETF	435.76	435.78	435.68	435.69	2180.0
2021-07-14 06:00:00	SPY	ETF	435.69	435.69	435.69	435.69	300.0
2021-07-14 06:05:00	SPY	ETF	435.71	435.71	435.71	435.71	300.0
2021-07-14 06:10:00	SPY	ETF	435.73	435.73	435.73	435.73	100.0
2021-07-14 06:15:00	SPY	ETF	435.74	435.76	435.71	435.74	4500.0
2021-07-14 06:20:00	SPY	ETF	435.8	435.87	435.8	435.84	2783.0
2021-07-14 06:25:00	SPY	ETF	435.81	435.81	435.81	435.81	300.0
2021-07-14 06:30:00	SPY	ETF	435.82	435.82	435.82	435.82	200.0
2021-07-14 06:35:00	SPY	ETF	436.0	436.01	436.0	436.01	589.0
2021-07-14 06:40:00	SPY	ETF	435.93	435.93	435.86	435.87	1072.0
2021-07-14 06:45:00	SPY	ETF	435.88	435.92	435.88	435.9	1100.0
2021-07-14 06:50:00	SPY	ETF	435.85	435.85	435.8	435.8	1100.0
2021-07-14 06:55:00	SPY	ETF	435.87	435.87	435.87	435.87	100.0
2021-07-14 07:00:00	SPY	ETF	435.8	435.99	435.8	435.98	16342.0
2021-07-14 07:05:00	SPY	ETF	436.05	436.09	435.89	435.9	9627.0
2021-07-14 07:10:00	SPY	ETF	435.94	435.94	435.9	435.93	2920.0
2021-07-14 07:15:00	SPY	ETF	435.98	436.11	435.98	436.05	4334.0
2021-07-14 07:20:00	SPY	ETF	436.05	436.09	435.92	436.09	8316.0
2021-07-14 07:25:00	SPY	ETF	436.07	436.09	436.02	436.02	10412.0
2021-07-14 07:30:00	SPY	ETF	436.04	436.09	436.03	436.09	4165.0
2021-07-14 07:35:00	SPY	ETF	436.06	436.07	436.06	436.07	723.0
2021-07-14 07:40:00	SPY	ETF	436.02	436.04	435.97	435.97	1945.0
2021-07-14 07:45:00	SPY	ETF	435.99	436.08	435.99	436.06	19500.0
2021-07-14 07:50:00	SPY	ETF	436.05	436.28	435.99	436.26	18849.0
2021-07-14 07:55:00	SPY	ETF	436.25	436.38	436.23	436.33	26242.0
2021-07-14 08:00:00	SPY	ETF	435.9201	436.37	435.07	436.34	33608.0
2021-07-14 08:05:00	SPY	ETF	436.329	436.34	435.97	436.27	49544.0
2021-07-14 08:10:00	SPY	ETF	436.26	436.36	436.26	436.32	22367.0
2021-07-14 08:15:00	SPY	ETF	436.32	436.37	436.28	436.28	7024.0

> showing 50 of 79,891 rows — these rows as CSV

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