PREVIEW / etf_5min / 2023-09-20

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-09-20.parquet
  size:    2.0 MB
  rows:    96,260

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-09-20 04:00:00	SPY	ETF	442.98	442.98	442.72	442.72	1700.0
2023-09-20 04:05:00	SPY	ETF	442.65	442.78	442.65	442.78	625.0
2023-09-20 04:10:00	SPY	ETF	442.76	442.88	442.71	442.71	971.0
2023-09-20 04:15:00	SPY	ETF	442.77	442.99	442.76	442.99	5357.0
2023-09-20 04:20:00	SPY	ETF	443.05	443.25	443.05	443.25	5215.0
2023-09-20 04:25:00	SPY	ETF	443.2	443.24	443.15	443.15	4197.0
2023-09-20 04:30:00	SPY	ETF	443.16	443.3	443.16	443.3	3207.0
2023-09-20 04:35:00	SPY	ETF	443.3	443.3	443.26	443.27	1490.0
2023-09-20 04:40:00	SPY	ETF	443.26	443.35	443.26	443.35	4266.0
2023-09-20 04:45:00	SPY	ETF	443.35	443.44	443.35	443.36	2947.0
2023-09-20 04:50:00	SPY	ETF	443.35	443.37	443.25	443.33	3124.0
2023-09-20 04:55:00	SPY	ETF	443.36	443.43	443.36	443.39	1400.0
2023-09-20 05:00:00	SPY	ETF	443.45	443.56	443.43	443.53	10080.0
2023-09-20 05:05:00	SPY	ETF	443.49	443.49	443.35	443.35	4155.0
2023-09-20 05:10:00	SPY	ETF	443.33	443.35	443.27	443.27	1980.0
2023-09-20 05:15:00	SPY	ETF	443.29	443.29	443.24	443.24	1387.0
2023-09-20 05:20:00	SPY	ETF	443.34	443.4	443.34	443.4	3700.0
2023-09-20 05:25:00	SPY	ETF	443.4	443.4	443.34	443.34	1037.0
2023-09-20 05:35:00	SPY	ETF	443.4	443.49	443.38	443.44	1495.0
2023-09-20 05:40:00	SPY	ETF	443.41	443.41	443.39	443.39	475.0
2023-09-20 05:45:00	SPY	ETF	443.43	443.44	443.42	443.42	669.0
2023-09-20 05:50:00	SPY	ETF	443.41	443.5	443.41	443.5	975.0
2023-09-20 05:55:00	SPY	ETF	443.65	443.68	443.57	443.6	3199.0
2023-09-20 06:00:00	SPY	ETF	443.53	443.53	443.48	443.48	3947.0
2023-09-20 06:05:00	SPY	ETF	443.5	443.53	443.5	443.52	1999.0
2023-09-20 06:10:00	SPY	ETF	443.48	443.59	443.48	443.58	2133.0
2023-09-20 06:15:00	SPY	ETF	443.65	443.67	443.5	443.5	1377.0
2023-09-20 06:20:00	SPY	ETF	443.5	443.6	443.5	443.58	2980.0
2023-09-20 06:25:00	SPY	ETF	443.52	443.55	443.45	443.46	3941.0
2023-09-20 06:30:00	SPY	ETF	443.46	443.46	443.33	443.43	6821.0
2023-09-20 06:35:00	SPY	ETF	443.45	443.51	443.45	443.51	350.0
2023-09-20 06:40:00	SPY	ETF	443.55	443.6	443.53	443.6	1212.0
2023-09-20 06:45:00	SPY	ETF	443.6	443.61	443.41	443.41	3475.0
2023-09-20 06:50:00	SPY	ETF	443.53	443.54	443.53	443.54	3400.0
2023-09-20 06:55:00	SPY	ETF	443.59	443.63	443.51	443.63	1673.0
2023-09-20 07:00:00	SPY	ETF	443.59	443.64	443.55	443.64	2718.0
2023-09-20 07:05:00	SPY	ETF	443.62	443.71	443.62	443.66	1687.0
2023-09-20 07:10:00	SPY	ETF	443.69	443.75	443.64	443.64	6814.0
2023-09-20 07:15:00	SPY	ETF	443.68	443.7	443.66	443.7	18911.0
2023-09-20 07:20:00	SPY	ETF	443.7	443.79	443.65	443.65	20039.0
2023-09-20 07:25:00	SPY	ETF	443.64	443.64	443.5	443.51	11400.0
2023-09-20 07:30:00	SPY	ETF	443.55	443.57	443.51	443.57	5759.0
2023-09-20 07:35:00	SPY	ETF	443.57	443.76	443.57	443.75	10525.0
2023-09-20 07:40:00	SPY	ETF	443.77	443.8	443.72	443.73	19085.0
2023-09-20 07:45:00	SPY	ETF	443.77	443.77	443.67	443.72	12455.0
2023-09-20 07:50:00	SPY	ETF	443.73	443.735	443.65	443.65	7948.0
2023-09-20 07:55:00	SPY	ETF	443.7	443.74	443.67	443.69	6418.0
2023-09-20 08:00:00	SPY	ETF	443.5919	443.79	442.24	443.78	43911.0
2023-09-20 08:05:00	SPY	ETF	443.74	443.83	443.7	443.83	26494.0
2023-09-20 08:10:00	SPY	ETF	443.83	443.84	443.66	443.72	10531.0

> showing 50 of 96,260 rows — these rows as CSV

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