PREVIEW / etf_5min / 2022-11-03

all etf 5-min files

  file:    by_date/etf_5min/2022/2022-11-03.parquet
  size:    2.0 MB
  rows:    98,072

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-03 04:00:00	SPY	ETF	375.05	375.28	374.58	374.93	44893.0
2022-11-03 04:05:00	SPY	ETF	374.92	375.52	374.85	375.52	5058.0
2022-11-03 04:10:00	SPY	ETF	375.6	375.64	375.31	375.31	3101.0
2022-11-03 04:15:00	SPY	ETF	375.77	375.77	375.21	375.21	1708.0
2022-11-03 04:20:00	SPY	ETF	375.3	375.37	374.77	374.81	7580.0
2022-11-03 04:25:00	SPY	ETF	374.7	374.73	374.3	374.39	5050.0
2022-11-03 04:30:00	SPY	ETF	374.56	374.68	374.05	374.17	21760.0
2022-11-03 04:35:00	SPY	ETF	374.13	374.43	374.13	374.14	1550.0
2022-11-03 04:40:00	SPY	ETF	374.2	374.5	374.2	374.38	3500.0
2022-11-03 04:45:00	SPY	ETF	374.37	374.37	374.28	374.28	800.0
2022-11-03 04:50:00	SPY	ETF	374.36	374.36	373.98	374.1	1750.0
2022-11-03 04:55:00	SPY	ETF	374.02	374.6	373.98	374.6	6500.0
2022-11-03 05:00:00	SPY	ETF	374.6	375.0	374.6	375.0	2500.0
2022-11-03 05:05:00	SPY	ETF	374.79	374.91	374.64	374.75	6400.0
2022-11-03 05:10:00	SPY	ETF	374.75	374.75	374.5	374.64	1975.0
2022-11-03 05:15:00	SPY	ETF	374.71	374.71	374.24	374.25	3500.0
2022-11-03 05:20:00	SPY	ETF	374.35	374.82	374.21	374.82	35275.0
2022-11-03 05:25:00	SPY	ETF	374.68	374.69	374.57	374.69	803.0
2022-11-03 05:30:00	SPY	ETF	374.69	374.77	374.65	374.65	3750.0
2022-11-03 05:35:00	SPY	ETF	374.62	374.62	374.46	374.46	550.0
2022-11-03 05:40:00	SPY	ETF	374.47	374.47	374.25	374.25	2088.0
2022-11-03 05:45:00	SPY	ETF	374.23	374.23	374.05	374.12	7445.0
2022-11-03 05:50:00	SPY	ETF	374.07	374.07	373.76	373.76	1250.0
2022-11-03 05:55:00	SPY	ETF	373.95	374.26	373.92	374.26	2750.0
2022-11-03 06:00:00	SPY	ETF	374.62	374.62	374.37	374.37	2175.0
2022-11-03 06:05:00	SPY	ETF	374.25	374.25	373.9	373.95	11150.0
2022-11-03 06:10:00	SPY	ETF	374.16	374.2	373.91	373.91	10350.0
2022-11-03 06:15:00	SPY	ETF	373.8	373.95	373.41	373.41	12293.0
2022-11-03 06:20:00	SPY	ETF	373.45	373.59	373.43	373.59	6316.0
2022-11-03 06:25:00	SPY	ETF	373.6	373.6	373.0	373.0	16326.0
2022-11-03 06:30:00	SPY	ETF	373.07	373.18	373.0	373.0	8194.0
2022-11-03 06:35:00	SPY	ETF	373.05	373.13	372.98	373.0	3174.0
2022-11-03 06:40:00	SPY	ETF	373.04	373.04	372.59	372.7	21335.0
2022-11-03 06:45:00	SPY	ETF	372.68	372.68	372.44	372.57	9695.0
2022-11-03 06:50:00	SPY	ETF	372.73	372.99	372.71	372.86	7329.0
2022-11-03 06:55:00	SPY	ETF	372.87	373.0	372.85	372.95	5507.0
2022-11-03 07:00:00	SPY	ETF	372.94	372.98	372.69	372.69	11327.0
2022-11-03 07:05:00	SPY	ETF	372.69	372.849	372.69	372.8	12580.0
2022-11-03 07:10:00	SPY	ETF	372.8	372.91	372.52	372.59	11605.0
2022-11-03 07:15:00	SPY	ETF	372.53	372.7	372.53	372.59	6190.0
2022-11-03 07:20:00	SPY	ETF	372.59	372.64	372.47	372.47	13933.0
2022-11-03 07:25:00	SPY	ETF	372.47	372.57	372.38	372.5	48565.0
2022-11-03 07:30:00	SPY	ETF	372.5	372.8	372.37	372.68	154197.0
2022-11-03 07:35:00	SPY	ETF	372.68	372.68	372.19	372.33	19181.0
2022-11-03 07:40:00	SPY	ETF	372.4	372.42	371.85	371.85	13766.0
2022-11-03 07:45:00	SPY	ETF	372.06	372.07	371.83	371.97	40457.0
2022-11-03 07:50:00	SPY	ETF	371.98	372.2	371.97	372.16	23260.0
2022-11-03 07:55:00	SPY	ETF	372.19	372.25	372.15	372.19	47013.0
2022-11-03 08:00:00	SPY	ETF	372.76	376.35	371.84	372.5	109920.0
2022-11-03 08:05:00	SPY	ETF	372.51	372.99	372.441	372.62	83757.0

> showing 50 of 98,072 rows — these rows as CSV

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