PREVIEW / etf_5min / 2023-11-01

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-11-01.parquet
  size:    2.1 MB
  rows:    103,152

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
2023-11-01 04:00:00	SPY	ETF	417.5	417.5	417.29	417.32	1831.0
2023-11-01 04:05:00	SPY	ETF	417.48	417.6	417.34	417.58	2874.0
2023-11-01 04:10:00	SPY	ETF	417.48	417.8	417.48	417.72	1427.0
2023-11-01 04:15:00	SPY	ETF	417.61	417.61	417.3	417.3	414.0
2023-11-01 04:25:00	SPY	ETF	417.33	417.33	416.95	416.95	5858.0
2023-11-01 04:30:00	SPY	ETF	417.0	417.32	417.0	417.27	3195.0
2023-11-01 04:35:00	SPY	ETF	417.23	417.23	417.23	417.23	100.0
2023-11-01 04:40:00	SPY	ETF	417.26	417.26	416.91	416.91	588.0
2023-11-01 04:45:00	SPY	ETF	416.86	416.89	416.86	416.89	291.0
2023-11-01 04:50:00	SPY	ETF	416.99	416.99	416.65	416.65	653.0
2023-11-01 04:55:00	SPY	ETF	416.77	416.88	416.77	416.88	1254.0
2023-11-01 05:00:00	SPY	ETF	416.89	417.05	416.8	417.05	1500.0
2023-11-01 05:05:00	SPY	ETF	417.14	417.2	417.14	417.2	1100.0
2023-11-01 05:10:00	SPY	ETF	417.11	417.11	417.07	417.07	1100.0
2023-11-01 05:15:00	SPY	ETF	416.94	416.94	416.94	416.94	830.0
2023-11-01 05:20:00	SPY	ETF	416.77	416.77	416.65	416.65	2230.0
2023-11-01 05:30:00	SPY	ETF	416.93	416.93	416.93	416.93	168.0
2023-11-01 05:35:00	SPY	ETF	416.68	416.82	416.68	416.82	200.0
2023-11-01 05:40:00	SPY	ETF	416.77	416.77	416.77	416.77	388.0
2023-11-01 05:45:00	SPY	ETF	416.7	416.77	416.65	416.77	620.0
2023-11-01 05:50:00	SPY	ETF	416.65	416.65	416.51	416.53	1700.0
2023-11-01 05:55:00	SPY	ETF	416.54	416.7	416.53	416.66	1500.0
2023-11-01 06:00:00	SPY	ETF	416.71	416.71	416.55	416.59	900.0
2023-11-01 06:05:00	SPY	ETF	416.56	416.56	416.51	416.51	400.0
2023-11-01 06:10:00	SPY	ETF	416.43	416.45	416.39	416.39	931.0
2023-11-01 06:15:00	SPY	ETF	416.52	416.55	416.52	416.55	200.0
2023-11-01 06:20:00	SPY	ETF	416.5	416.5	416.45	416.45	443.0
2023-11-01 06:25:00	SPY	ETF	416.43	416.68	416.43	416.68	1731.0
2023-11-01 06:30:00	SPY	ETF	416.68	416.74	416.58	416.66	9738.0
2023-11-01 06:35:00	SPY	ETF	416.8	416.9	416.8	416.9	2443.0
2023-11-01 06:40:00	SPY	ETF	416.86	417.02	416.85	417.02	40719.0
2023-11-01 06:45:00	SPY	ETF	417.0	417.08	416.95	416.96	28900.0
2023-11-01 06:50:00	SPY	ETF	416.89	416.93	416.87	416.93	3936.0
2023-11-01 06:55:00	SPY	ETF	416.92	416.92	416.85	416.86	1116.0
2023-11-01 07:00:00	SPY	ETF	416.86	416.99	416.86	416.99	7006.0
2023-11-01 07:05:00	SPY	ETF	416.99	417.0	416.8	416.8	2793.0
2023-11-01 07:10:00	SPY	ETF	416.8	416.9	416.79	416.79	2100.0
2023-11-01 07:15:00	SPY	ETF	416.78	416.79	416.74	416.74	14209.0
2023-11-01 07:20:00	SPY	ETF	416.74	416.74	416.5	416.57	23188.0
2023-11-01 07:25:00	SPY	ETF	416.57	416.69	416.57	416.58	10684.0
2023-11-01 07:30:00	SPY	ETF	416.54	416.8	416.5	416.8	94959.0
2023-11-01 07:35:00	SPY	ETF	416.8	416.84	416.62	416.66	10757.0
2023-11-01 07:40:00	SPY	ETF	416.65	416.65	416.48	416.48	4169.0
2023-11-01 07:45:00	SPY	ETF	416.47	416.47	416.3	416.3	32472.0
2023-11-01 07:50:00	SPY	ETF	416.28	416.35	416.24	416.32	15148.0
2023-11-01 07:55:00	SPY	ETF	416.33	416.5	416.3	416.5	14792.0
2023-11-01 08:00:00	SPY	ETF	416.68	418.13	416.28	416.77	55430.0
2023-11-01 08:05:00	SPY	ETF	416.75	416.84	416.65	416.81	27422.0
2023-11-01 08:10:00	SPY	ETF	416.82	416.96	416.79	416.91	26039.0
2023-11-01 08:15:00	SPY	ETF	416.88	417.17	416.88	417.1	70094.0

> showing 50 of 103,152 rows — these rows as CSV

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