PREVIEW / etf_5min / 2022-07-01

all etf 5-min files

  file:    by_date/etf_5min/2022/2022-07-01.parquet
  size:    1.9 MB
  rows:    94,340

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
2022-07-01 04:00:00	SPY	ETF	374.69	374.69	374.08	374.09	4303.0
2022-07-01 04:05:00	SPY	ETF	374.12	374.31	373.8	373.9	4850.0
2022-07-01 04:10:00	SPY	ETF	374.16	374.99	374.16	374.99	7200.0
2022-07-01 04:15:00	SPY	ETF	375.15	375.15	374.95	375.15	1400.0
2022-07-01 04:20:00	SPY	ETF	375.3	375.9	375.3	375.79	7685.0
2022-07-01 04:25:00	SPY	ETF	375.62	375.9	375.59	375.84	1750.0
2022-07-01 04:30:00	SPY	ETF	375.98	375.98	375.63	375.67	4844.0
2022-07-01 04:35:00	SPY	ETF	375.81	376.29	375.81	376.29	1500.0
2022-07-01 04:40:00	SPY	ETF	376.19	376.22	375.99	376.02	11460.0
2022-07-01 04:45:00	SPY	ETF	375.88	376.04	375.85	376.04	1500.0
2022-07-01 04:50:00	SPY	ETF	376.21	376.21	376.21	376.21	100.0
2022-07-01 04:55:00	SPY	ETF	376.16	376.34	376.11	376.11	2200.0
2022-07-01 05:00:00	SPY	ETF	376.11	376.31	375.82	376.31	1878.0
2022-07-01 05:05:00	SPY	ETF	376.35	376.92	376.35	376.77	8532.0
2022-07-01 05:10:00	SPY	ETF	376.68	376.68	376.52	376.56	16512.0
2022-07-01 05:15:00	SPY	ETF	376.69	376.79	376.65	376.65	3200.0
2022-07-01 05:20:00	SPY	ETF	376.7	376.88	376.6	376.78	7684.0
2022-07-01 05:25:00	SPY	ETF	376.89	376.89	376.46	376.48	5895.0
2022-07-01 05:30:00	SPY	ETF	376.6	376.64	376.54	376.57	7851.0
2022-07-01 05:35:00	SPY	ETF	376.61	376.71	376.6	376.6	2200.0
2022-07-01 05:40:00	SPY	ETF	376.38	376.47	376.38	376.38	741.0
2022-07-01 05:45:00	SPY	ETF	376.28	377.01	376.28	377.01	2872.0
2022-07-01 05:50:00	SPY	ETF	377.01	377.2	376.99	377.16	6290.0
2022-07-01 05:55:00	SPY	ETF	377.06	377.11	377.03	377.11	10100.0
2022-07-01 06:00:00	SPY	ETF	377.25	377.25	376.86	376.86	1707.0
2022-07-01 06:05:00	SPY	ETF	376.81	376.81	376.48	376.54	2000.0
2022-07-01 06:10:00	SPY	ETF	376.49	376.66	376.49	376.66	3200.0
2022-07-01 06:15:00	SPY	ETF	376.69	377.06	376.69	377.01	1200.0
2022-07-01 06:20:00	SPY	ETF	377.09	377.8	377.03	377.24	32898.0
2022-07-01 06:25:00	SPY	ETF	377.28	377.28	377.04	377.05	1250.0
2022-07-01 06:30:00	SPY	ETF	376.74	376.74	376.63	376.63	1850.0
2022-07-01 06:35:00	SPY	ETF	376.67	376.67	376.41	376.44	1399.0
2022-07-01 06:40:00	SPY	ETF	376.22	376.35	376.06	376.06	5885.0
2022-07-01 06:45:00	SPY	ETF	376.09	376.09	375.82	376.07	5550.0
2022-07-01 06:50:00	SPY	ETF	376.01	376.07	375.81	375.81	1100.0
2022-07-01 06:55:00	SPY	ETF	375.87	376.02	375.71	375.74	5848.0
2022-07-01 07:00:00	SPY	ETF	375.88	376.14	375.71	376.05	28639.0
2022-07-01 07:05:00	SPY	ETF	376.14	376.14	375.86	376.01	17135.0
2022-07-01 07:10:00	SPY	ETF	376.05	376.08	375.76	375.901	26099.0
2022-07-01 07:15:00	SPY	ETF	375.8	376.12	375.68	376.05	8060.0
2022-07-01 07:20:00	SPY	ETF	376.05	376.05	375.9	376.05	11651.0
2022-07-01 07:25:00	SPY	ETF	376.04	376.4	375.95	376.31	19995.0
2022-07-01 07:30:00	SPY	ETF	376.27	376.34	375.97	376.04	8075.0
2022-07-01 07:35:00	SPY	ETF	376.01	376.17	375.84	375.84	3600.0
2022-07-01 07:40:00	SPY	ETF	375.8	375.85	375.47	375.62	22264.0
2022-07-01 07:45:00	SPY	ETF	375.59	375.59	375.11	375.11	17676.0
2022-07-01 07:50:00	SPY	ETF	375.05	375.27	375.01	375.22	12596.0
2022-07-01 07:55:00	SPY	ETF	375.07	375.31	374.75	375.31	33590.0
2022-07-01 08:00:00	SPY	ETF	375.5801	377.19	373.5	375.68	95199.0
2022-07-01 08:05:00	SPY	ETF	375.7	375.85	375.64	375.8	22238.0

> showing 50 of 94,340 rows — these rows as CSV

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