PREVIEW / etf_1min / 2023-07-03

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-07-03.parquet
  size:    2.8 MB
  rows:    156,262

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-07-03 04:00:00	SPY	ETF	443.5	443.52	443.5	443.52	400.0
2023-07-03 04:01:00	SPY	ETF	443.6	443.6	443.6	443.6	650.0
2023-07-03 04:02:00	SPY	ETF	443.6	443.64	443.57	443.58	1900.0
2023-07-03 04:03:00	SPY	ETF	443.62	443.62	443.6	443.62	755.0
2023-07-03 04:04:00	SPY	ETF	443.63	443.63	443.63	443.63	115.0
2023-07-03 04:05:00	SPY	ETF	443.65	443.65	443.65	443.65	1278.0
2023-07-03 04:06:00	SPY	ETF	443.68	443.68	443.61	443.61	1262.0
2023-07-03 04:07:00	SPY	ETF	443.66	443.66	443.62	443.62	245.0
2023-07-03 04:08:00	SPY	ETF	443.6	443.6	443.57	443.57	934.0
2023-07-03 04:09:00	SPY	ETF	443.58	443.58	443.58	443.58	100.0
2023-07-03 04:11:00	SPY	ETF	443.63	443.68	443.63	443.68	1179.0
2023-07-03 04:12:00	SPY	ETF	443.7	443.75	443.69	443.75	353.0
2023-07-03 04:13:00	SPY	ETF	443.73	443.73	443.73	443.73	100.0
2023-07-03 04:14:00	SPY	ETF	443.67	443.74	443.66	443.74	7801.0
2023-07-03 04:19:00	SPY	ETF	443.65	443.67	443.64	443.67	831.0
2023-07-03 04:21:00	SPY	ETF	443.72	443.72	443.72	443.72	500.0
2023-07-03 04:24:00	SPY	ETF	443.58	443.6	443.58	443.6	400.0
2023-07-03 04:26:00	SPY	ETF	443.6	443.6	443.6	443.6	200.0
2023-07-03 04:27:00	SPY	ETF	443.65	443.67	443.65	443.67	404.0
2023-07-03 04:32:00	SPY	ETF	443.69	443.69	443.69	443.69	114.0
2023-07-03 04:34:00	SPY	ETF	443.79	443.79	443.79	443.79	500.0
2023-07-03 04:36:00	SPY	ETF	443.81	443.81	443.81	443.81	100.0
2023-07-03 04:38:00	SPY	ETF	443.76	443.77	443.76	443.77	980.0
2023-07-03 04:39:00	SPY	ETF	443.81	443.85	443.81	443.85	2300.0
2023-07-03 04:40:00	SPY	ETF	443.83	443.83	443.83	443.83	300.0
2023-07-03 04:44:00	SPY	ETF	443.8	443.8	443.8	443.8	200.0
2023-07-03 04:45:00	SPY	ETF	443.84	443.84	443.84	443.84	400.0
2023-07-03 04:46:00	SPY	ETF	443.8	443.8	443.8	443.8	721.0
2023-07-03 04:48:00	SPY	ETF	443.77	443.77	443.77	443.77	162.0
2023-07-03 04:53:00	SPY	ETF	443.77	443.8	443.77	443.8	382.0
2023-07-03 04:55:00	SPY	ETF	443.69	443.69	443.69	443.69	198.0
2023-07-03 04:57:00	SPY	ETF	443.68	443.68	443.67	443.67	2000.0
2023-07-03 04:58:00	SPY	ETF	443.71	443.71	443.71	443.71	161.0
2023-07-03 05:01:00	SPY	ETF	443.71	443.71	443.68	443.68	300.0
2023-07-03 05:02:00	SPY	ETF	443.7	443.7	443.7	443.7	100.0
2023-07-03 05:03:00	SPY	ETF	443.7	443.7	443.67	443.67	260.0
2023-07-03 05:04:00	SPY	ETF	443.67	443.69	443.67	443.69	300.0
2023-07-03 05:08:00	SPY	ETF	443.61	443.61	443.61	443.61	962.0
2023-07-03 05:12:00	SPY	ETF	443.66	443.66	443.66	443.66	400.0
2023-07-03 05:13:00	SPY	ETF	443.64	443.64	443.64	443.64	100.0
2023-07-03 05:14:00	SPY	ETF	443.62	443.62	443.59	443.59	3400.0
2023-07-03 05:15:00	SPY	ETF	443.65	443.65	443.65	443.65	195.0
2023-07-03 05:17:00	SPY	ETF	443.67	443.67	443.67	443.67	250.0
2023-07-03 05:19:00	SPY	ETF	443.69	443.69	443.69	443.69	100.0
2023-07-03 05:20:00	SPY	ETF	443.67	443.67	443.67	443.67	200.0
2023-07-03 05:21:00	SPY	ETF	443.59	443.59	443.59	443.59	100.0
2023-07-03 05:22:00	SPY	ETF	443.61	443.61	443.61	443.61	100.0
2023-07-03 05:29:00	SPY	ETF	443.65	443.65	443.63	443.63	271.0
2023-07-03 05:31:00	SPY	ETF	443.57	443.57	443.57	443.57	465.0
2023-07-03 05:34:00	SPY	ETF	443.55	443.63	443.55	443.57	5269.0

> showing 50 of 156,262 rows — these rows as CSV

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