PREVIEW / etf_1min / 2023-05-01

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-05-01.parquet
  size:    4.4 MB
  rows:    249,125

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-01 04:00:00	SPY	ETF	416.15	416.15	416.07	416.07	52697.0
2023-05-01 04:01:00	SPY	ETF	416.07	416.07	416.07	416.07	21900.0
2023-05-01 04:02:00	SPY	ETF	416.15	416.15	416.14	416.14	25150.0
2023-05-01 04:04:00	SPY	ETF	416.12	416.12	416.12	416.12	996.0
2023-05-01 04:05:00	SPY	ETF	416.1	416.11	416.1	416.11	18651.0
2023-05-01 04:06:00	SPY	ETF	416.11	416.11	416.11	416.11	6046.0
2023-05-01 04:07:00	SPY	ETF	415.99	415.99	415.93	415.93	4300.0
2023-05-01 04:08:00	SPY	ETF	415.93	416.0	415.9	416.0	10274.0
2023-05-01 04:09:00	SPY	ETF	415.9	415.94	415.9	415.9	16330.0
2023-05-01 04:10:00	SPY	ETF	415.95	415.95	415.9	415.9	5940.0
2023-05-01 04:11:00	SPY	ETF	415.9	415.92	415.89	415.92	5420.0
2023-05-01 04:12:00	SPY	ETF	415.83	415.85	415.83	415.85	4970.0
2023-05-01 04:13:00	SPY	ETF	415.8	415.85	415.8	415.85	4970.0
2023-05-01 04:14:00	SPY	ETF	415.75	415.75	415.75	415.75	200.0
2023-05-01 04:15:00	SPY	ETF	415.75	415.75	415.7	415.7	9807.0
2023-05-01 04:16:00	SPY	ETF	415.67	415.67	415.67	415.67	999.0
2023-05-01 04:17:00	SPY	ETF	415.73	415.73	415.72	415.72	500.0
2023-05-01 04:21:00	SPY	ETF	415.72	415.72	415.72	415.72	631.0
2023-05-01 04:22:00	SPY	ETF	415.78	415.85	415.78	415.85	10000.0
2023-05-01 04:23:00	SPY	ETF	415.78	415.78	415.78	415.78	700.0
2023-05-01 04:25:00	SPY	ETF	415.81	415.81	415.79	415.8	2800.0
2023-05-01 04:26:00	SPY	ETF	415.8	415.82	415.8	415.82	7639.0
2023-05-01 04:29:00	SPY	ETF	415.75	415.75	415.74	415.74	4000.0
2023-05-01 04:30:00	SPY	ETF	415.72	415.72	415.71	415.71	4240.0
2023-05-01 04:31:00	SPY	ETF	415.62	415.62	415.62	415.62	100.0
2023-05-01 04:32:00	SPY	ETF	415.62	415.62	415.58	415.6	700.0
2023-05-01 04:33:00	SPY	ETF	415.6	415.6	415.6	415.6	500.0
2023-05-01 04:35:00	SPY	ETF	415.63	415.63	415.63	415.63	500.0
2023-05-01 04:36:00	SPY	ETF	415.64	415.64	415.64	415.64	500.0
2023-05-01 04:38:00	SPY	ETF	415.66	415.66	415.66	415.66	155.0
2023-05-01 04:43:00	SPY	ETF	415.7	415.7	415.7	415.7	102.0
2023-05-01 04:45:00	SPY	ETF	415.71	415.71	415.71	415.71	200.0
2023-05-01 04:46:00	SPY	ETF	415.75	415.75	415.75	415.75	250.0
2023-05-01 04:47:00	SPY	ETF	415.79	415.79	415.79	415.79	100.0
2023-05-01 04:48:00	SPY	ETF	415.78	415.78	415.78	415.78	100.0
2023-05-01 04:49:00	SPY	ETF	415.78	415.78	415.78	415.78	115.0
2023-05-01 04:53:00	SPY	ETF	415.75	415.75	415.75	415.75	300.0
2023-05-01 04:54:00	SPY	ETF	415.78	415.78	415.78	415.78	100.0
2023-05-01 04:55:00	SPY	ETF	415.79	415.79	415.79	415.79	100.0
2023-05-01 04:57:00	SPY	ETF	415.7	415.7	415.7	415.7	500.0
2023-05-01 05:01:00	SPY	ETF	415.81	415.81	415.81	415.81	1000.0
2023-05-01 05:04:00	SPY	ETF	415.82	415.82	415.8	415.8	1100.0
2023-05-01 05:06:00	SPY	ETF	415.79	415.79	415.79	415.79	100.0
2023-05-01 05:10:00	SPY	ETF	415.8	415.81	415.8	415.81	602.0
2023-05-01 05:13:00	SPY	ETF	415.92	415.92	415.92	415.92	100.0
2023-05-01 05:16:00	SPY	ETF	416.01	416.01	416.0	416.01	523.0
2023-05-01 05:17:00	SPY	ETF	416.01	416.01	415.99	416.01	800.0
2023-05-01 05:20:00	SPY	ETF	416.09	416.11	416.09	416.11	1017.0
2023-05-01 05:21:00	SPY	ETF	416.13	416.13	416.12	416.12	1298.0
2023-05-01 05:22:00	SPY	ETF	416.13	416.14	416.09	416.09	500.0

> showing 50 of 249,125 rows — these rows as CSV

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