PREVIEW / etf_5min / 2024-03-22

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-03-22.parquet
  size:    2.2 MB
  rows:    107,413

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
2024-03-22 04:00:00	SPY	ETF	522.22	522.38	522.16	522.26	4345.0
2024-03-22 04:10:00	SPY	ETF	522.14	522.49	522.11	522.49	3918.0
2024-03-22 04:15:00	SPY	ETF	522.5	522.5	522.33	522.33	1100.0
2024-03-22 04:20:00	SPY	ETF	522.49	522.59	522.49	522.58	3016.0
2024-03-22 04:25:00	SPY	ETF	522.49	522.49	522.49	522.49	300.0
2024-03-22 04:30:00	SPY	ETF	522.72	522.72	522.68	522.68	250.0
2024-03-22 04:35:00	SPY	ETF	522.57	522.66	522.57	522.66	276.0
2024-03-22 04:40:00	SPY	ETF	522.71	522.79	522.71	522.79	424.0
2024-03-22 04:45:00	SPY	ETF	522.87	522.87	522.8	522.8	1114.0
2024-03-22 04:50:00	SPY	ETF	522.78	522.81	522.7	522.81	2400.0
2024-03-22 04:55:00	SPY	ETF	522.82	522.84	522.82	522.84	687.0
2024-03-22 05:00:00	SPY	ETF	522.88	522.88	522.88	522.88	375.0
2024-03-22 05:05:00	SPY	ETF	522.97	523.09	522.96	523.06	4142.0
2024-03-22 05:15:00	SPY	ETF	523.05	523.05	522.98	522.98	700.0
2024-03-22 05:20:00	SPY	ETF	522.84	522.89	522.78	522.78	2534.0
2024-03-22 05:25:00	SPY	ETF	522.74	522.79	522.74	522.79	498.0
2024-03-22 05:30:00	SPY	ETF	522.83	522.83	522.83	522.83	200.0
2024-03-22 05:35:00	SPY	ETF	522.71	522.71	522.7	522.7	689.0
2024-03-22 05:40:00	SPY	ETF	522.77	522.79	522.77	522.79	823.0
2024-03-22 06:00:00	SPY	ETF	522.92	522.97	522.92	522.95	2699.0
2024-03-22 06:10:00	SPY	ETF	522.86	522.86	522.83	522.83	625.0
2024-03-22 06:15:00	SPY	ETF	522.84	522.86	522.84	522.86	268.0
2024-03-22 06:20:00	SPY	ETF	522.87	522.93	522.87	522.92	825.0
2024-03-22 06:25:00	SPY	ETF	522.88	522.93	522.87	522.93	1299.0
2024-03-22 06:30:00	SPY	ETF	522.97	522.98	522.85	522.86	5866.0
2024-03-22 06:35:00	SPY	ETF	522.99	522.99	522.99	522.99	125.0
2024-03-22 06:40:00	SPY	ETF	522.98	523.09	522.96	523.09	1799.0
2024-03-22 06:45:00	SPY	ETF	523.04	523.09	523.04	523.09	686.0
2024-03-22 06:50:00	SPY	ETF	523.05	523.05	523.05	523.05	100.0
2024-03-22 06:55:00	SPY	ETF	522.83	522.84	522.76	522.78	2453.0
2024-03-22 07:00:00	SPY	ETF	522.81	522.95	522.8	522.93	2072.0
2024-03-22 07:05:00	SPY	ETF	522.91	523.0	522.91	523.0	671.0
2024-03-22 07:10:00	SPY	ETF	522.99	523.08	522.99	523.08	9762.0
2024-03-22 07:15:00	SPY	ETF	523.04	523.04	522.95	522.95	912.0
2024-03-22 07:20:00	SPY	ETF	522.78	522.78	522.57	522.57	3614.0
2024-03-22 07:25:00	SPY	ETF	522.57	522.66	522.55	522.64	7771.0
2024-03-22 07:30:00	SPY	ETF	522.62	522.62	522.6	522.6	500.0
2024-03-22 07:35:00	SPY	ETF	522.62	522.62	522.36	522.36	15294.0
2024-03-22 07:40:00	SPY	ETF	522.35	522.35	522.17	522.2	5058.0
2024-03-22 07:45:00	SPY	ETF	522.2	522.2	521.6	521.6	33452.0
2024-03-22 07:50:00	SPY	ETF	521.6	521.63	521.44	521.6	41801.0
2024-03-22 07:55:00	SPY	ETF	521.58	521.6	521.39	521.51	13107.0
2024-03-22 08:00:00	SPY	ETF	521.52	523.09	521.26	521.35	66112.0
2024-03-22 08:05:00	SPY	ETF	521.3	521.57	521.27	521.56	24963.0
2024-03-22 08:10:00	SPY	ETF	521.59	521.75	521.55	521.62	9661.0
2024-03-22 08:15:00	SPY	ETF	521.59	521.65	521.32	521.54	10144.0
2024-03-22 08:20:00	SPY	ETF	521.59	521.69	521.4	521.4	6753.0
2024-03-22 08:25:00	SPY	ETF	521.4	521.51	521.32	521.44	20159.0
2024-03-22 08:30:00	SPY	ETF	521.44	521.46	521.28	521.39	16634.0
2024-03-22 08:35:00	SPY	ETF	521.39	521.54	521.25	521.53	37906.0

> showing 50 of 107,413 rows — these rows as CSV

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