PREVIEW / etf_5min / 2022-07-22

all etf 5-min files

  file:    by_date/etf_5min/2022/2022-07-22.parquet
  size:    1.9 MB
  rows:    89,600

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-22 04:00:00	SPY	ETF	397.24	397.24	396.97	396.97	1558.0
2022-07-22 04:05:00	SPY	ETF	396.94	396.94	396.67	396.8	1558.0
2022-07-22 04:10:00	SPY	ETF	397.04	397.31	397.04	397.31	635.0
2022-07-22 04:15:00	SPY	ETF	397.28	397.5	397.28	397.3	1400.0
2022-07-22 04:20:00	SPY	ETF	397.08	397.08	397.08	397.08	300.0
2022-07-22 04:25:00	SPY	ETF	397.25	397.41	397.25	397.41	753.0
2022-07-22 04:30:00	SPY	ETF	397.55	397.55	397.5	397.5	200.0
2022-07-22 04:35:00	SPY	ETF	397.51	397.51	397.51	397.51	100.0
2022-07-22 04:40:00	SPY	ETF	397.65	397.8	397.6	397.6	600.0
2022-07-22 04:45:00	SPY	ETF	397.6	397.6	397.6	397.6	600.0
2022-07-22 04:50:00	SPY	ETF	397.54	397.54	397.54	397.54	379.0
2022-07-22 04:55:00	SPY	ETF	397.4	397.4	397.4	397.4	100.0
2022-07-22 05:05:00	SPY	ETF	397.7	397.87	397.7	397.87	1131.0
2022-07-22 05:10:00	SPY	ETF	397.9	397.95	397.85	397.89	1901.0
2022-07-22 05:15:00	SPY	ETF	397.95	398.05	397.95	398.01	3200.0
2022-07-22 05:20:00	SPY	ETF	398.03	398.03	397.85	397.88	1600.0
2022-07-22 05:25:00	SPY	ETF	397.81	397.84	397.6	397.61	1600.0
2022-07-22 05:30:00	SPY	ETF	397.57	397.65	397.51	397.51	2878.0
2022-07-22 05:35:00	SPY	ETF	397.5	397.57	397.5	397.51	1200.0
2022-07-22 05:40:00	SPY	ETF	397.48	397.5	397.48	397.48	500.0
2022-07-22 05:45:00	SPY	ETF	397.44	397.7	397.44	397.7	1237.0
2022-07-22 05:50:00	SPY	ETF	397.78	397.8	397.71	397.71	1900.0
2022-07-22 05:55:00	SPY	ETF	397.68	397.68	397.45	397.45	4600.0
2022-07-22 06:00:00	SPY	ETF	397.44	397.87	397.44	397.87	3380.0
2022-07-22 06:05:00	SPY	ETF	397.95	397.95	397.95	397.95	150.0
2022-07-22 06:15:00	SPY	ETF	397.56	397.56	397.45	397.47	518.0
2022-07-22 06:20:00	SPY	ETF	397.43	397.44	397.43	397.44	900.0
2022-07-22 06:25:00	SPY	ETF	397.51	397.51	397.51	397.51	100.0
2022-07-22 06:30:00	SPY	ETF	397.61	397.89	397.61	397.89	13750.0
2022-07-22 06:35:00	SPY	ETF	397.89	398.0	397.88	397.9	7384.0
2022-07-22 06:40:00	SPY	ETF	398.02	398.13	397.86	398.12	7810.0
2022-07-22 06:45:00	SPY	ETF	398.12	398.21	398.1	398.1	2899.0
2022-07-22 06:50:00	SPY	ETF	398.1	398.19	398.0	398.0	4710.0
2022-07-22 06:55:00	SPY	ETF	397.97	398.03	397.77	397.77	12876.0
2022-07-22 07:00:00	SPY	ETF	397.82	397.86	397.49	397.68	28382.0
2022-07-22 07:05:00	SPY	ETF	397.65	397.71	397.59	397.66	6559.0
2022-07-22 07:10:00	SPY	ETF	397.62	397.65	397.53	397.59	5750.0
2022-07-22 07:15:00	SPY	ETF	397.59	397.7	397.52	397.59	39827.0
2022-07-22 07:20:00	SPY	ETF	397.59	397.66	397.56	397.66	6793.0
2022-07-22 07:25:00	SPY	ETF	397.63	397.8	397.63	397.77	11350.0
2022-07-22 07:30:00	SPY	ETF	397.82	397.84	397.54	397.7	30539.0
2022-07-22 07:35:00	SPY	ETF	397.65	397.8	397.61	397.8	6745.0
2022-07-22 07:40:00	SPY	ETF	397.85	398.09	397.85	397.99	15152.0
2022-07-22 07:45:00	SPY	ETF	397.98	398.2	397.96	398.09	18017.0
2022-07-22 07:50:00	SPY	ETF	398.09	398.19	398.05	398.19	4325.0
2022-07-22 07:55:00	SPY	ETF	398.23	398.38	398.16	398.32	21784.0
2022-07-22 08:00:00	SPY	ETF	398.31	398.36	397.07	398.04	51385.0
2022-07-22 08:05:00	SPY	ETF	398.02	398.2	398.02	398.09	16910.0
2022-07-22 08:10:00	SPY	ETF	398.13	398.25	398.05	398.25	7207.0
2022-07-22 08:15:00	SPY	ETF	398.22	398.5	398.22	398.48	33647.0

> showing 50 of 89,600 rows — these rows as CSV

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