PREVIEW / etf_5min / 2023-03-20

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-03-20.parquet
  size:    2.0 MB
  rows:    98,563

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-20 04:00:00	SPY	ETF	387.49	389.0	387.49	388.12	19878.0
2023-03-20 04:05:00	SPY	ETF	388.29	388.4	387.43	387.8	11443.0
2023-03-20 04:10:00	SPY	ETF	387.7	387.7	386.61	386.62	17093.0
2023-03-20 04:15:00	SPY	ETF	386.59	386.74	385.23	385.23	11804.0
2023-03-20 04:20:00	SPY	ETF	385.23	386.08	385.18	385.74	9472.0
2023-03-20 04:25:00	SPY	ETF	385.82	386.36	385.79	386.03	11929.0
2023-03-20 04:30:00	SPY	ETF	386.07	386.42	385.96	386.3	9248.0
2023-03-20 04:35:00	SPY	ETF	386.39	387.24	386.31	387.24	16389.0
2023-03-20 04:40:00	SPY	ETF	387.2	387.81	387.16	387.31	28537.0
2023-03-20 04:45:00	SPY	ETF	387.28	387.69	387.2	387.52	9116.0
2023-03-20 04:50:00	SPY	ETF	387.5	388.19	387.5	387.92	20317.0
2023-03-20 04:55:00	SPY	ETF	388.03	388.33	388.01	388.28	21275.0
2023-03-20 05:00:00	SPY	ETF	388.41	389.18	388.41	389.1	28440.0
2023-03-20 05:05:00	SPY	ETF	389.22	389.6	388.9	389.5	33800.0
2023-03-20 05:10:00	SPY	ETF	389.44	389.44	388.68	388.7	15806.0
2023-03-20 05:15:00	SPY	ETF	388.77	388.77	388.37	388.37	7909.0
2023-03-20 05:20:00	SPY	ETF	388.63	388.86	388.31	388.47	10306.0
2023-03-20 05:25:00	SPY	ETF	388.14	388.33	388.0	388.33	5920.0
2023-03-20 05:30:00	SPY	ETF	388.68	389.41	388.68	389.41	8901.0
2023-03-20 05:35:00	SPY	ETF	389.48	389.48	389.0	389.31	11355.0
2023-03-20 05:40:00	SPY	ETF	389.3	389.74	389.29	389.47	10075.0
2023-03-20 05:45:00	SPY	ETF	389.41	389.77	389.32	389.77	12735.0
2023-03-20 05:50:00	SPY	ETF	389.76	389.99	389.5	389.53	18275.0
2023-03-20 05:55:00	SPY	ETF	389.59	390.08	389.59	389.86	23440.0
2023-03-20 06:00:00	SPY	ETF	389.86	389.86	389.3	389.83	28500.0
2023-03-20 06:05:00	SPY	ETF	389.74	390.65	389.74	390.62	19729.0
2023-03-20 06:10:00	SPY	ETF	390.52	390.65	390.2	390.38	19519.0
2023-03-20 06:15:00	SPY	ETF	390.55	390.55	389.78	389.78	25205.0
2023-03-20 06:20:00	SPY	ETF	389.82	389.9	389.55	389.87	20695.0
2023-03-20 06:25:00	SPY	ETF	389.82	389.97	389.72	389.92	8651.0
2023-03-20 06:30:00	SPY	ETF	389.63	390.0	389.52	389.94	27984.0
2023-03-20 06:35:00	SPY	ETF	389.95	390.4	389.95	390.35	11656.0
2023-03-20 06:40:00	SPY	ETF	390.47	390.71	390.28	390.65	48144.0
2023-03-20 06:45:00	SPY	ETF	390.64	390.77	390.59	390.65	14021.0
2023-03-20 06:50:00	SPY	ETF	390.72	390.76	390.26	390.51	26267.0
2023-03-20 06:55:00	SPY	ETF	390.64	390.81	390.34	390.61	16240.0
2023-03-20 07:00:00	SPY	ETF	390.56	390.79	390.4	390.4	25977.0
2023-03-20 07:05:00	SPY	ETF	390.4	390.55	389.86	390.35	24663.0
2023-03-20 07:10:00	SPY	ETF	390.4	390.46	389.83	389.95	24788.0
2023-03-20 07:15:00	SPY	ETF	389.9	389.9	389.55	389.62	39998.0
2023-03-20 07:20:00	SPY	ETF	389.7	390.13	389.45	390.1	19830.0
2023-03-20 07:25:00	SPY	ETF	390.15	390.29	390.11	390.29	11575.0
2023-03-20 07:30:00	SPY	ETF	390.34	390.66	390.0	390.02	20706.0
2023-03-20 07:35:00	SPY	ETF	390.0	390.0	389.51	389.51	62510.0
2023-03-20 07:40:00	SPY	ETF	389.5	389.95	389.2	389.23	31345.0
2023-03-20 07:45:00	SPY	ETF	389.3	389.54	389.11	389.32	58277.0
2023-03-20 07:50:00	SPY	ETF	389.4	389.71	389.4	389.6	19815.0
2023-03-20 07:55:00	SPY	ETF	389.52	389.95	389.52	389.9	7908.0
2023-03-20 08:00:00	SPY	ETF	389.9099	390.81	385.68	389.89	117424.0
2023-03-20 08:05:00	SPY	ETF	389.93	389.93	389.21	389.34	157290.0

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

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