PREVIEW / etf_5min / 2022-05-27

all etf 5-min files

  file:    by_date/etf_5min/2022/2022-05-27.parquet
  size:    2.0 MB
  rows:    94,247

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-05-27 04:00:00	SPY	ETF	405.01	405.01	405.01	405.01	155.0
2022-05-27 04:05:00	SPY	ETF	405.16	405.39	405.16	405.39	4896.0
2022-05-27 04:10:00	SPY	ETF	405.36	405.47	405.13	405.47	3548.0
2022-05-27 04:15:00	SPY	ETF	405.57	405.87	405.41	405.43	11316.0
2022-05-27 04:20:00	SPY	ETF	405.73	405.73	405.73	405.73	200.0
2022-05-27 04:25:00	SPY	ETF	405.93	406.32	405.93	406.32	2200.0
2022-05-27 04:30:00	SPY	ETF	406.3	406.69	406.3	406.69	3915.0
2022-05-27 04:35:00	SPY	ETF	406.68	406.79	406.48	406.48	2472.0
2022-05-27 04:40:00	SPY	ETF	406.56	406.56	406.35	406.4	6790.0
2022-05-27 04:45:00	SPY	ETF	406.3	406.31	406.21	406.22	2100.0
2022-05-27 04:50:00	SPY	ETF	406.2	406.3	406.11	406.3	2826.0
2022-05-27 04:55:00	SPY	ETF	406.29	406.54	406.28	406.54	476.0
2022-05-27 05:00:00	SPY	ETF	406.3	406.3	406.2	406.2	495.0
2022-05-27 05:05:00	SPY	ETF	406.04	406.09	406.0	406.09	1800.0
2022-05-27 05:10:00	SPY	ETF	405.95	405.95	405.9	405.9	2700.0
2022-05-27 05:15:00	SPY	ETF	405.9	406.0	405.9	406.0	2997.0
2022-05-27 05:20:00	SPY	ETF	406.1	406.17	406.06	406.09	1775.0
2022-05-27 05:25:00	SPY	ETF	406.05	406.32	406.0	406.32	2417.0
2022-05-27 05:30:00	SPY	ETF	406.44	406.47	406.44	406.47	400.0
2022-05-27 05:35:00	SPY	ETF	406.38	406.46	406.38	406.45	3300.0
2022-05-27 05:40:00	SPY	ETF	406.68	406.69	406.64	406.67	736.0
2022-05-27 05:45:00	SPY	ETF	406.57	406.72	406.57	406.72	650.0
2022-05-27 05:50:00	SPY	ETF	406.8	406.98	406.8	406.98	4825.0
2022-05-27 05:55:00	SPY	ETF	407.03	407.37	407.03	407.17	6688.0
2022-05-27 06:00:00	SPY	ETF	406.89	406.89	406.52	406.52	1998.0
2022-05-27 06:05:00	SPY	ETF	406.5	406.5	406.37	406.37	1000.0
2022-05-27 06:10:00	SPY	ETF	406.67	406.67	406.67	406.67	250.0
2022-05-27 06:15:00	SPY	ETF	406.59	406.6	406.44	406.48	5900.0
2022-05-27 06:20:00	SPY	ETF	406.38	406.4	406.35	406.37	800.0
2022-05-27 06:30:00	SPY	ETF	406.52	406.55	406.34	406.34	7731.0
2022-05-27 06:35:00	SPY	ETF	406.45	406.45	406.35	406.4	1305.0
2022-05-27 06:40:00	SPY	ETF	406.57	406.57	406.5	406.5	1165.0
2022-05-27 06:45:00	SPY	ETF	406.51	406.51	406.4	406.4	800.0
2022-05-27 06:50:00	SPY	ETF	406.32	406.62	406.2	406.62	6650.0
2022-05-27 06:55:00	SPY	ETF	406.75	406.88	406.63	406.85	1000.0
2022-05-27 07:00:00	SPY	ETF	406.8	406.8	406.49	406.49	9841.0
2022-05-27 07:05:00	SPY	ETF	406.45	406.68	406.38	406.64	5296.0
2022-05-27 07:10:00	SPY	ETF	406.55	406.67	406.43	406.62	14826.0
2022-05-27 07:15:00	SPY	ETF	406.54	406.61	406.1	406.23	23313.0
2022-05-27 07:20:00	SPY	ETF	406.26	406.31	405.96	406.1	16616.0
2022-05-27 07:25:00	SPY	ETF	406.02	406.27	406.02	406.22	6100.0
2022-05-27 07:30:00	SPY	ETF	406.24	406.27	406.0	406.09	2597.0
2022-05-27 07:35:00	SPY	ETF	406.11	406.14	406.0	406.05	8585.0
2022-05-27 07:40:00	SPY	ETF	406.05	406.32	406.05	406.31	5450.0
2022-05-27 07:45:00	SPY	ETF	406.32	406.32	405.93	406.02	1361.0
2022-05-27 07:50:00	SPY	ETF	405.9	405.9	405.45	405.62	13478.0
2022-05-27 07:55:00	SPY	ETF	405.51	405.58	405.4	405.48	28551.0
2022-05-27 08:00:00	SPY	ETF	406.7001	407.0704	404.72	405.93	57787.0
2022-05-27 08:05:00	SPY	ETF	405.93	406.33	405.9	406.22	13405.0
2022-05-27 08:10:00	SPY	ETF	406.3	406.42	406.2	406.24	20000.0

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

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