PREVIEW / etf_5min / 2023-03-13

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-03-13.parquet
  size:    2.1 MB
  rows:    106,924

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-03-13 04:00:00	SPY	ETF	391.75	391.78	390.97	391.01	16791.0
2023-03-13 04:05:00	SPY	ETF	391.01	391.02	390.8	390.9	26861.0
2023-03-13 04:10:00	SPY	ETF	390.9	391.5	390.9	391.49	13019.0
2023-03-13 04:15:00	SPY	ETF	391.34	391.75	391.08	391.08	18349.0
2023-03-13 04:20:00	SPY	ETF	391.1	391.42	390.99	391.3	2454.0
2023-03-13 04:25:00	SPY	ETF	391.45	391.45	390.39	390.4	8946.0
2023-03-13 04:30:00	SPY	ETF	390.38	390.42	389.89	389.97	11307.0
2023-03-13 04:35:00	SPY	ETF	390.0	390.13	389.67	389.84	15417.0
2023-03-13 04:40:00	SPY	ETF	389.91	390.0	389.52	389.6	38704.0
2023-03-13 04:45:00	SPY	ETF	389.53	389.53	388.98	389.1	22839.0
2023-03-13 04:50:00	SPY	ETF	388.96	388.96	388.0	388.59	14891.0
2023-03-13 04:55:00	SPY	ETF	388.83	388.83	388.1	388.23	55958.0
2023-03-13 05:00:00	SPY	ETF	388.09	388.27	387.29	387.43	11191.0
2023-03-13 05:05:00	SPY	ETF	387.37	388.02	387.34	387.66	22024.0
2023-03-13 05:10:00	SPY	ETF	387.54	388.27	387.29	388.21	9422.0
2023-03-13 05:15:00	SPY	ETF	388.11	388.19	387.28	387.28	7279.0
2023-03-13 05:20:00	SPY	ETF	387.28	387.34	385.95	386.34	33978.0
2023-03-13 05:25:00	SPY	ETF	386.28	386.44	385.99	386.08	16521.0
2023-03-13 05:30:00	SPY	ETF	386.08	386.08	385.24	385.84	45048.0
2023-03-13 05:35:00	SPY	ETF	385.53	386.02	384.83	385.72	73315.0
2023-03-13 05:40:00	SPY	ETF	385.87	386.78	385.72	386.61	50649.0
2023-03-13 05:45:00	SPY	ETF	387.09	387.6	387.01	387.06	15277.0
2023-03-13 05:50:00	SPY	ETF	387.28	387.29	386.5	386.75	19462.0
2023-03-13 05:55:00	SPY	ETF	386.5	386.5	385.8	385.89	20892.0
2023-03-13 06:00:00	SPY	ETF	385.96	386.8	385.96	386.79	19600.0
2023-03-13 06:05:00	SPY	ETF	386.9	387.0	385.8	386.0	90102.0
2023-03-13 06:10:00	SPY	ETF	385.99	386.28	385.56	385.56	53947.0
2023-03-13 06:15:00	SPY	ETF	385.63	385.83	385.3	385.78	31589.0
2023-03-13 06:20:00	SPY	ETF	385.76	386.42	385.76	386.0	17157.0
2023-03-13 06:25:00	SPY	ETF	386.01	386.57	385.98	386.31	44021.0
2023-03-13 06:30:00	SPY	ETF	386.29	386.88	386.0	386.44	56587.0
2023-03-13 06:35:00	SPY	ETF	386.51	386.57	386.22	386.42	9199.0
2023-03-13 06:40:00	SPY	ETF	386.4	386.55	385.96	385.96	37751.0
2023-03-13 06:45:00	SPY	ETF	385.91	386.7	385.63	386.7	31619.0
2023-03-13 06:50:00	SPY	ETF	386.59	387.0	386.19	386.92	23108.0
2023-03-13 06:55:00	SPY	ETF	386.87	388.2	386.87	387.73	50934.0
2023-03-13 07:00:00	SPY	ETF	387.61	389.19	387.51	389.05	170846.0
2023-03-13 07:05:00	SPY	ETF	389.02	389.14	388.35	388.56	151226.0
2023-03-13 07:10:00	SPY	ETF	388.38	388.39	387.61	387.91	137387.0
2023-03-13 07:15:00	SPY	ETF	387.8	387.88	387.38	387.53	68878.0
2023-03-13 07:20:00	SPY	ETF	387.53	387.53	386.93	386.93	51822.0
2023-03-13 07:25:00	SPY	ETF	386.9	387.02	386.2	386.69	123978.0
2023-03-13 07:30:00	SPY	ETF	386.64	387.2	386.42	386.5	47881.0
2023-03-13 07:35:00	SPY	ETF	386.62	386.75	386.2	386.49	166018.0
2023-03-13 07:40:00	SPY	ETF	386.37	386.59	385.8	385.82	99880.0
2023-03-13 07:45:00	SPY	ETF	385.91	386.29	385.78	386.15	64458.0
2023-03-13 07:50:00	SPY	ETF	386.16	386.24	385.86	385.91	113624.0
2023-03-13 07:55:00	SPY	ETF	385.92	386.9	385.78	386.16	140193.0
2023-03-13 08:00:00	SPY	ETF	387.9399	393.25	385.42	385.71	617699.0
2023-03-13 08:05:00	SPY	ETF	386.081	392.38	384.6	384.74	277503.0

> showing 50 of 106,924 rows — these rows as CSV

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