PREVIEW / etf_5min / 2022-11-07

all etf 5-min files

  file:    by_date/etf_5min/2022/2022-11-07.parquet
  size:    2.0 MB
  rows:    97,908

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-11-07 04:00:00	SPY	ETF	375.0	377.79	375.0	377.7	20310.0
2022-11-07 04:05:00	SPY	ETF	377.6	377.89	377.54	377.81	12890.0
2022-11-07 04:10:00	SPY	ETF	377.71	377.71	377.24	377.28	3688.0
2022-11-07 04:15:00	SPY	ETF	377.34	377.64	377.34	377.64	1574.0
2022-11-07 04:20:00	SPY	ETF	377.64	377.72	377.47	377.71	7800.0
2022-11-07 04:25:00	SPY	ETF	377.66	377.72	377.43	377.69	2250.0
2022-11-07 04:30:00	SPY	ETF	377.7	377.78	377.6	377.6	700.0
2022-11-07 04:35:00	SPY	ETF	377.59	377.59	377.36	377.36	525.0
2022-11-07 04:40:00	SPY	ETF	377.4	377.53	377.13	377.53	3205.0
2022-11-07 04:45:00	SPY	ETF	377.46	377.46	377.45	377.45	1200.0
2022-11-07 04:50:00	SPY	ETF	377.16	377.37	377.16	377.27	1925.0
2022-11-07 04:55:00	SPY	ETF	377.15	377.16	377.05	377.05	1000.0
2022-11-07 05:00:00	SPY	ETF	377.1	377.2	377.06	377.2	3350.0
2022-11-07 05:05:00	SPY	ETF	377.35	377.53	377.34	377.45	3099.0
2022-11-07 05:10:00	SPY	ETF	377.6	377.88	377.6	377.85	4778.0
2022-11-07 05:15:00	SPY	ETF	377.81	377.96	377.81	377.89	10825.0
2022-11-07 05:20:00	SPY	ETF	377.94	378.23	377.93	378.2	19390.0
2022-11-07 05:25:00	SPY	ETF	378.05	378.18	378.05	378.18	1000.0
2022-11-07 05:30:00	SPY	ETF	378.17	378.17	377.97	378.04	1600.0
2022-11-07 05:35:00	SPY	ETF	378.0	378.0	377.82	377.83	4225.0
2022-11-07 05:40:00	SPY	ETF	377.83	378.08	377.83	378.08	1485.0
2022-11-07 05:45:00	SPY	ETF	378.0	378.19	377.99	378.19	2775.0
2022-11-07 05:50:00	SPY	ETF	377.99	378.13	377.93	378.13	1000.0
2022-11-07 05:55:00	SPY	ETF	378.08	378.35	378.08	378.27	3501.0
2022-11-07 06:00:00	SPY	ETF	378.35	378.78	378.35	378.76	7660.0
2022-11-07 06:05:00	SPY	ETF	378.68	378.79	378.62	378.62	1990.0
2022-11-07 06:10:00	SPY	ETF	378.68	378.73	378.4	378.4	11037.0
2022-11-07 06:15:00	SPY	ETF	378.41	378.41	378.32	378.37	5004.0
2022-11-07 06:20:00	SPY	ETF	378.23	378.23	378.18	378.21	2800.0
2022-11-07 06:25:00	SPY	ETF	378.28	378.55	378.28	378.39	4220.0
2022-11-07 06:30:00	SPY	ETF	378.44	378.65	378.44	378.59	2387.0
2022-11-07 06:35:00	SPY	ETF	378.65	378.85	378.53	378.53	2464.0
2022-11-07 06:40:00	SPY	ETF	378.5	378.75	378.5	378.64	9580.0
2022-11-07 06:45:00	SPY	ETF	378.65	378.73	378.6	378.73	11851.0
2022-11-07 06:50:00	SPY	ETF	378.76	378.78	378.61	378.61	3090.0
2022-11-07 06:55:00	SPY	ETF	378.5	378.5	378.28	378.28	2629.0
2022-11-07 07:00:00	SPY	ETF	378.22	378.29	377.94	378.07	21934.0
2022-11-07 07:05:00	SPY	ETF	378.11	378.44	378.08	378.42	33500.0
2022-11-07 07:10:00	SPY	ETF	378.44	378.85	378.44	378.7	15792.0
2022-11-07 07:15:00	SPY	ETF	378.77	378.81	378.4	378.4	14603.0
2022-11-07 07:20:00	SPY	ETF	378.37	378.5	378.09	378.11	12040.0
2022-11-07 07:25:00	SPY	ETF	378.33	378.43	378.14	378.15	8680.0
2022-11-07 07:30:00	SPY	ETF	378.01	378.18	378.01	378.1	5058.0
2022-11-07 07:35:00	SPY	ETF	378.1	378.1	377.9	378.07	44110.0
2022-11-07 07:40:00	SPY	ETF	378.08	378.08	377.61	377.71	20934.0
2022-11-07 07:45:00	SPY	ETF	377.77	377.95	377.63	377.76	61353.0
2022-11-07 07:50:00	SPY	ETF	377.87	377.98	377.8	377.84	29407.0
2022-11-07 07:55:00	SPY	ETF	377.81	378.0	377.67	377.9	29742.0
2022-11-07 08:00:00	SPY	ETF	378.78	378.82	374.5	378.12	196898.0
2022-11-07 08:05:00	SPY	ETF	378.07	378.43	377.53	377.53	60753.0

> showing 50 of 97,908 rows — these rows as CSV

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