PREVIEW / etf_1min / 2021-04-22

all etf 1-min files

  file:    by_date/etf_1min/2021/2021-04-22.parquet
  size:    4.1 MB
  rows:    223,001

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
2021-04-22 04:00:00	SPY	ETF	415.61	415.61	415.52	415.6	8890.0
2021-04-22 04:01:00	SPY	ETF	415.63	415.63	415.6	415.61	2700.0
2021-04-22 04:02:00	SPY	ETF	415.6	415.64	415.6	415.61	2900.0
2021-04-22 04:03:00	SPY	ETF	415.63	415.63	415.63	415.63	500.0
2021-04-22 04:04:00	SPY	ETF	415.63	415.66	415.61	415.65	999.0
2021-04-22 04:06:00	SPY	ETF	415.58	415.58	415.58	415.58	100.0
2021-04-22 04:07:00	SPY	ETF	415.61	415.63	415.61	415.63	1000.0
2021-04-22 04:08:00	SPY	ETF	415.63	415.74	415.62	415.74	1900.0
2021-04-22 04:09:00	SPY	ETF	415.76	415.76	415.74	415.74	1100.0
2021-04-22 04:10:00	SPY	ETF	415.71	415.72	415.69	415.72	1100.0
2021-04-22 04:11:00	SPY	ETF	415.76	415.81	415.76	415.81	2600.0
2021-04-22 04:12:00	SPY	ETF	415.82	415.82	415.82	415.82	3000.0
2021-04-22 04:13:00	SPY	ETF	415.87	415.87	415.87	415.87	100.0
2021-04-22 04:15:00	SPY	ETF	415.77	415.77	415.77	415.77	100.0
2021-04-22 04:16:00	SPY	ETF	415.68	415.68	415.68	415.68	100.0
2021-04-22 04:17:00	SPY	ETF	415.71	415.71	415.71	415.71	100.0
2021-04-22 04:18:00	SPY	ETF	415.68	415.68	415.64	415.64	500.0
2021-04-22 04:19:00	SPY	ETF	415.74	415.74	415.74	415.74	300.0
2021-04-22 04:20:00	SPY	ETF	415.73	415.73	415.73	415.73	172.0
2021-04-22 04:21:00	SPY	ETF	415.69	415.69	415.69	415.69	100.0
2021-04-22 04:22:00	SPY	ETF	415.67	415.67	415.67	415.67	100.0
2021-04-22 04:23:00	SPY	ETF	415.73	415.73	415.73	415.73	100.0
2021-04-22 04:25:00	SPY	ETF	415.74	415.74	415.74	415.74	100.0
2021-04-22 04:26:00	SPY	ETF	415.77	415.77	415.77	415.77	2500.0
2021-04-22 04:31:00	SPY	ETF	415.88	415.91	415.88	415.89	1200.0
2021-04-22 04:32:00	SPY	ETF	415.92	415.92	415.92	415.92	200.0
2021-04-22 04:35:00	SPY	ETF	415.84	415.84	415.84	415.84	300.0
2021-04-22 04:36:00	SPY	ETF	415.84	415.9	415.84	415.89	1400.0
2021-04-22 04:40:00	SPY	ETF	415.98	416.0	415.98	415.99	500.0
2021-04-22 04:41:00	SPY	ETF	416.01	416.01	416.0	416.0	1100.0
2021-04-22 04:42:00	SPY	ETF	416.02	416.02	416.02	416.02	100.0
2021-04-22 04:43:00	SPY	ETF	415.92	415.92	415.92	415.92	100.0
2021-04-22 04:44:00	SPY	ETF	415.86	415.86	415.86	415.86	200.0
2021-04-22 04:45:00	SPY	ETF	415.82	415.82	415.82	415.82	100.0
2021-04-22 04:48:00	SPY	ETF	415.74	415.74	415.74	415.74	200.0
2021-04-22 04:50:00	SPY	ETF	415.67	415.67	415.62	415.62	800.0
2021-04-22 04:53:00	SPY	ETF	415.59	415.62	415.59	415.62	3100.0
2021-04-22 04:59:00	SPY	ETF	415.6	415.6	415.6	415.6	500.0
2021-04-22 05:07:00	SPY	ETF	415.62	415.62	415.62	415.62	400.0
2021-04-22 05:08:00	SPY	ETF	415.62	415.62	415.62	415.62	100.0
2021-04-22 05:10:00	SPY	ETF	415.59	415.59	415.59	415.59	1300.0
2021-04-22 05:12:00	SPY	ETF	415.62	415.62	415.62	415.62	250.0
2021-04-22 05:13:00	SPY	ETF	415.65	415.69	415.65	415.69	250.0
2021-04-22 05:14:00	SPY	ETF	415.67	415.67	415.67	415.67	100.0
2021-04-22 05:15:00	SPY	ETF	415.67	415.67	415.67	415.67	100.0
2021-04-22 05:16:00	SPY	ETF	415.66	415.69	415.66	415.69	600.0
2021-04-22 05:18:00	SPY	ETF	415.74	415.74	415.74	415.74	100.0
2021-04-22 05:24:00	SPY	ETF	415.74	415.74	415.72	415.72	1600.0
2021-04-22 05:25:00	SPY	ETF	415.77	415.77	415.77	415.77	100.0
2021-04-22 05:31:00	SPY	ETF	415.69	415.69	415.69	415.69	210.0

> showing 50 of 223,001 rows — these rows as CSV

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