PREVIEW / etf_5min / 2023-05-03

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-05-03.parquet
  size:    2.0 MB
  rows:    97,208

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-05-03 04:00:00	SPY	ETF	411.34	411.5	411.34	411.39	1229.0
2023-05-03 04:05:00	SPY	ETF	411.29	411.32	411.29	411.32	498.0
2023-05-03 04:10:00	SPY	ETF	411.45	411.45	411.31	411.31	700.0
2023-05-03 04:20:00	SPY	ETF	411.38	411.38	411.29	411.29	1800.0
2023-05-03 04:30:00	SPY	ETF	411.28	411.37	411.27	411.37	8400.0
2023-05-03 04:35:00	SPY	ETF	411.26	411.41	411.26	411.39	525.0
2023-05-03 04:40:00	SPY	ETF	411.55	411.62	411.5	411.59	1601.0
2023-05-03 04:45:00	SPY	ETF	411.55	411.55	411.51	411.52	1025.0
2023-05-03 04:50:00	SPY	ETF	411.49	411.53	411.45	411.45	3021.0
2023-05-03 04:55:00	SPY	ETF	411.52	411.52	411.46	411.46	200.0
2023-05-03 05:00:00	SPY	ETF	411.44	411.62	411.42	411.5	1000.0
2023-05-03 05:10:00	SPY	ETF	411.56	411.61	411.51	411.61	1849.0
2023-05-03 05:15:00	SPY	ETF	411.54	411.54	411.5	411.5	430.0
2023-05-03 05:20:00	SPY	ETF	411.49	411.61	411.49	411.61	1050.0
2023-05-03 05:25:00	SPY	ETF	411.47	411.47	411.47	411.47	330.0
2023-05-03 05:30:00	SPY	ETF	411.38	411.38	411.38	411.38	1000.0
2023-05-03 05:35:00	SPY	ETF	411.38	411.38	411.26	411.26	3877.0
2023-05-03 05:40:00	SPY	ETF	411.21	411.21	411.21	411.21	300.0
2023-05-03 05:45:00	SPY	ETF	411.29	411.34	411.29	411.34	1204.0
2023-05-03 06:00:00	SPY	ETF	411.49	411.7	411.49	411.65	96874.0
2023-05-03 06:05:00	SPY	ETF	411.65	411.75	411.62	411.62	11799.0
2023-05-03 06:10:00	SPY	ETF	411.69	411.69	411.68	411.68	1100.0
2023-05-03 06:15:00	SPY	ETF	411.76	411.92	411.75	411.92	11536.0
2023-05-03 06:20:00	SPY	ETF	411.74	411.74	411.7	411.7	300.0
2023-05-03 06:25:00	SPY	ETF	411.71	411.71	411.71	411.71	700.0
2023-05-03 06:30:00	SPY	ETF	411.69	411.69	411.61	411.67	4438.0
2023-05-03 06:35:00	SPY	ETF	411.76	411.77	411.76	411.77	1200.0
2023-05-03 06:40:00	SPY	ETF	411.88	411.91	411.87	411.87	425.0
2023-05-03 06:45:00	SPY	ETF	411.71	411.71	411.71	411.71	200.0
2023-05-03 06:50:00	SPY	ETF	411.52	411.53	411.39	411.4	3150.0
2023-05-03 07:00:00	SPY	ETF	411.41	411.66	411.4	411.66	7907.0
2023-05-03 07:05:00	SPY	ETF	411.66	411.71	411.64	411.67	48847.0
2023-05-03 07:10:00	SPY	ETF	411.68	411.83	411.68	411.78	15419.0
2023-05-03 07:15:00	SPY	ETF	411.76	411.86	411.69	411.86	2956.0
2023-05-03 07:20:00	SPY	ETF	411.8	411.82	411.72	411.78	5546.0
2023-05-03 07:25:00	SPY	ETF	411.78	411.88	411.78	411.85	8003.0
2023-05-03 07:30:00	SPY	ETF	411.85	411.97	411.83	411.92	5968.0
2023-05-03 07:35:00	SPY	ETF	411.97	411.99	411.77	411.85	47250.0
2023-05-03 07:40:00	SPY	ETF	411.91	412.02	411.89	412.0	16068.0
2023-05-03 07:45:00	SPY	ETF	411.95	411.96	411.72	411.73	12275.0
2023-05-03 07:50:00	SPY	ETF	411.73	411.81	411.65	411.77	26840.0
2023-05-03 07:55:00	SPY	ETF	411.8	411.82	411.72	411.72	5544.0
2023-05-03 08:00:00	SPY	ETF	411.76	411.99	411.2604	411.79	40176.0
2023-05-03 08:05:00	SPY	ETF	411.82	411.89	411.76	411.77	6286.0
2023-05-03 08:10:00	SPY	ETF	411.77	411.86	411.67	411.81	20214.0
2023-05-03 08:15:00	SPY	ETF	411.67	412.19	411.53	412.01	69856.0
2023-05-03 08:20:00	SPY	ETF	412.0	412.17	411.84	411.88	39031.0
2023-05-03 08:25:00	SPY	ETF	411.9	411.93	411.78	411.89	29379.0
2023-05-03 08:30:00	SPY	ETF	411.92	412.03	411.67	411.67	39016.0
2023-05-03 08:35:00	SPY	ETF	411.68	411.76	411.59	411.59	20949.0

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

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