PREVIEW / etf_5min / 2021-07-01

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-07-01.parquet
  size:    1.7 MB
  rows:    81,871

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-01 04:00:00	SPY	ETF	429.65	429.93	429.65	429.93	1701.0
2021-07-01 04:05:00	SPY	ETF	429.95	429.95	429.9	429.9	401.0
2021-07-01 04:10:00	SPY	ETF	429.85	429.85	429.67	429.67	500.0
2021-07-01 04:15:00	SPY	ETF	429.66	429.68	429.66	429.68	200.0
2021-07-01 04:20:00	SPY	ETF	429.47	429.47	429.47	429.47	100.0
2021-07-01 04:40:00	SPY	ETF	429.41	429.46	429.41	429.42	1099.0
2021-07-01 04:45:00	SPY	ETF	429.37	429.37	429.37	429.37	100.0
2021-07-01 04:50:00	SPY	ETF	429.34	429.34	429.34	429.34	100.0
2021-07-01 04:55:00	SPY	ETF	429.28	429.28	429.28	429.28	100.0
2021-07-01 05:00:00	SPY	ETF	429.32	429.33	429.26	429.26	500.0
2021-07-01 05:05:00	SPY	ETF	429.11	429.11	429.05	429.05	276.0
2021-07-01 05:10:00	SPY	ETF	429.02	429.08	429.02	429.07	9782.0
2021-07-01 05:15:00	SPY	ETF	429.06	429.06	428.91	428.95	50496.0
2021-07-01 05:20:00	SPY	ETF	428.88	428.88	428.85	428.85	5077.0
2021-07-01 05:25:00	SPY	ETF	428.99	429.03	428.96	429.03	1176.0
2021-07-01 05:30:00	SPY	ETF	429.01	429.1	429.0	429.1	833.0
2021-07-01 05:35:00	SPY	ETF	429.09	429.09	429.09	429.09	100.0
2021-07-01 05:40:00	SPY	ETF	429.04	429.06	428.74	428.75	4500.0
2021-07-01 05:45:00	SPY	ETF	428.82	428.83	428.72	428.75	1800.0
2021-07-01 05:50:00	SPY	ETF	428.7	428.71	428.61	428.71	1662.0
2021-07-01 06:00:00	SPY	ETF	428.84	428.84	428.66	428.66	2400.0
2021-07-01 06:05:00	SPY	ETF	428.66	428.71	428.66	428.71	1381.0
2021-07-01 06:10:00	SPY	ETF	428.78	428.8	428.78	428.79	105291.0
2021-07-01 06:15:00	SPY	ETF	428.8	428.81	428.79	428.81	2000.0
2021-07-01 06:20:00	SPY	ETF	428.65	428.65	428.54	428.54	8099.0
2021-07-01 06:25:00	SPY	ETF	428.44	428.45	428.34	428.34	8002.0
2021-07-01 06:30:00	SPY	ETF	428.42	428.46	428.32	428.46	10500.0
2021-07-01 06:35:00	SPY	ETF	428.54	428.54	428.4	428.46	5100.0
2021-07-01 06:40:00	SPY	ETF	428.41	428.55	428.25	428.32	58600.0
2021-07-01 06:45:00	SPY	ETF	428.28	428.5	428.23	428.5	33200.0
2021-07-01 06:50:00	SPY	ETF	428.32	428.34	428.15	428.15	6400.0
2021-07-01 06:55:00	SPY	ETF	428.25	428.27	428.15	428.24	7900.0
2021-07-01 07:00:00	SPY	ETF	428.32	428.43	428.18	428.3	14257.0
2021-07-01 07:05:00	SPY	ETF	428.3	428.46	428.25	428.3	37930.0
2021-07-01 07:10:00	SPY	ETF	428.3	428.46	428.3	428.33	12593.0
2021-07-01 07:15:00	SPY	ETF	428.42	428.45	428.4	428.4	8185.0
2021-07-01 07:20:00	SPY	ETF	428.38	428.38	428.31	428.33	2328.0
2021-07-01 07:25:00	SPY	ETF	428.42	428.44	428.41	428.44	2775.0
2021-07-01 07:30:00	SPY	ETF	428.43	428.62	428.42	428.54	17406.0
2021-07-01 07:35:00	SPY	ETF	428.56	428.78	428.53	428.78	10344.0
2021-07-01 07:40:00	SPY	ETF	428.79	428.82	428.73	428.8	2075.0
2021-07-01 07:45:00	SPY	ETF	428.78	428.9	428.76	428.8	6317.0
2021-07-01 07:50:00	SPY	ETF	428.86	428.88	428.8	428.83	4621.0
2021-07-01 07:55:00	SPY	ETF	428.88	429.0	428.86	429.0	2229.0
2021-07-01 08:00:00	SPY	ETF	428.21	429.24	428.19	429.07	103256.0
2021-07-01 08:05:00	SPY	ETF	429.03	429.04	428.85	428.99	11925.0
2021-07-01 08:10:00	SPY	ETF	428.98	428.99	428.94	428.97	29876.0
2021-07-01 08:15:00	SPY	ETF	428.92	428.95	428.85	428.85	36228.0
2021-07-01 08:20:00	SPY	ETF	428.87	428.96	428.82	428.9	11908.0
2021-07-01 08:25:00	SPY	ETF	428.92	428.94	428.82	428.83	7158.0

> showing 50 of 81,871 rows — these rows as CSV

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