PREVIEW / etf_5min / 2023-01-12

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-01-12.parquet
  size:    2.1 MB
  rows:    101,742

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-01-12 04:00:00	SPY	ETF	395.36	395.6	395.36	395.6	2650.0
2023-01-12 04:05:00	SPY	ETF	395.56	395.56	395.48	395.48	591.0
2023-01-12 04:10:00	SPY	ETF	395.56	395.56	395.4	395.41	2152.0
2023-01-12 04:15:00	SPY	ETF	395.75	395.78	395.7	395.75	1138.0
2023-01-12 04:20:00	SPY	ETF	395.79	395.79	395.75	395.78	814.0
2023-01-12 04:25:00	SPY	ETF	395.66	395.72	395.59	395.62	16350.0
2023-01-12 04:30:00	SPY	ETF	395.63	395.73	395.63	395.73	3670.0
2023-01-12 04:35:00	SPY	ETF	395.73	395.74	395.69	395.74	3073.0
2023-01-12 04:45:00	SPY	ETF	395.81	395.84	395.78	395.84	471.0
2023-01-12 04:50:00	SPY	ETF	395.85	395.87	395.74	395.74	4518.0
2023-01-12 04:55:00	SPY	ETF	395.78	395.82	395.78	395.8	11798.0
2023-01-12 05:00:00	SPY	ETF	395.78	395.78	395.57	395.57	600.0
2023-01-12 05:05:00	SPY	ETF	395.45	395.45	395.37	395.37	600.0
2023-01-12 05:10:00	SPY	ETF	395.45	395.45	395.34	395.35	1484.0
2023-01-12 05:15:00	SPY	ETF	395.31	395.31	395.3	395.3	350.0
2023-01-12 05:20:00	SPY	ETF	395.25	395.36	395.25	395.36	2800.0
2023-01-12 05:25:00	SPY	ETF	395.39	395.46	395.3	395.46	5730.0
2023-01-12 05:30:00	SPY	ETF	395.38	395.38	395.38	395.38	900.0
2023-01-12 05:35:00	SPY	ETF	395.33	395.47	395.33	395.46	761.0
2023-01-12 05:40:00	SPY	ETF	395.43	395.5	395.43	395.5	212.0
2023-01-12 05:45:00	SPY	ETF	395.54	395.56	395.54	395.56	1865.0
2023-01-12 05:50:00	SPY	ETF	395.65	395.65	395.65	395.65	250.0
2023-01-12 05:55:00	SPY	ETF	395.65	395.65	395.57	395.62	2320.0
2023-01-12 06:00:00	SPY	ETF	395.62	395.74	395.62	395.73	1036.0
2023-01-12 06:05:00	SPY	ETF	395.7	395.7	395.7	395.7	300.0
2023-01-12 06:10:00	SPY	ETF	395.53	395.56	395.53	395.53	385.0
2023-01-12 06:15:00	SPY	ETF	395.7	395.74	395.7	395.74	450.0
2023-01-12 06:20:00	SPY	ETF	395.76	395.8	395.67	395.67	1419.0
2023-01-12 06:25:00	SPY	ETF	395.65	395.7	395.65	395.7	550.0
2023-01-12 06:30:00	SPY	ETF	395.72	395.88	395.72	395.88	1889.0
2023-01-12 06:35:00	SPY	ETF	395.82	395.89	395.78	395.78	613.0
2023-01-12 06:40:00	SPY	ETF	395.75	395.9	395.75	395.78	2267.0
2023-01-12 06:45:00	SPY	ETF	395.77	395.8	395.74	395.8	2600.0
2023-01-12 06:50:00	SPY	ETF	395.79	395.86	395.77	395.83	18644.0
2023-01-12 06:55:00	SPY	ETF	395.77	395.78	395.74	395.75	3500.0
2023-01-12 07:00:00	SPY	ETF	395.74	395.9	395.71	395.85	19581.0
2023-01-12 07:05:00	SPY	ETF	395.81	395.95	395.81	395.95	4472.0
2023-01-12 07:10:00	SPY	ETF	395.95	396.09	395.95	396.09	6332.0
2023-01-12 07:15:00	SPY	ETF	396.14	396.2	396.05	396.18	11712.0
2023-01-12 07:20:00	SPY	ETF	396.11	396.27	396.11	396.21	17690.0
2023-01-12 07:25:00	SPY	ETF	396.23	396.27	396.09	396.09	2439.0
2023-01-12 07:30:00	SPY	ETF	396.08	396.2	396.05	396.19	12427.0
2023-01-12 07:35:00	SPY	ETF	396.1	396.25	396.1	396.24	15337.0
2023-01-12 07:40:00	SPY	ETF	396.23	396.35	396.15	396.34	43343.0
2023-01-12 07:45:00	SPY	ETF	396.36	396.4	396.33	396.36	5971.0
2023-01-12 07:50:00	SPY	ETF	396.38	396.6	396.33	396.6	8568.0
2023-01-12 07:55:00	SPY	ETF	396.57	396.68	396.5	396.67	112542.0
2023-01-12 08:00:00	SPY	ETF	396.66	396.92	395.41	396.84	111272.0
2023-01-12 08:05:00	SPY	ETF	396.84	397.08	396.75	396.94	228796.0
2023-01-12 08:10:00	SPY	ETF	396.95	396.95	395.58	396.88	64802.0

> showing 50 of 101,742 rows — these rows as CSV

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