PREVIEW / etf_1min / 2021-05-11

all etf 1-min files

  file:    by_date/etf_1min/2021/2021-05-11.parquet
  size:    4.6 MB
  rows:    254,739

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-05-11 04:00:00	SPY	ETF	416.0	416.0	415.15	415.16	698.0
2021-05-11 04:01:00	SPY	ETF	415.0	415.0	414.98	414.98	932.0
2021-05-11 04:02:00	SPY	ETF	415.01	415.01	415.01	415.01	253.0
2021-05-11 04:03:00	SPY	ETF	414.88	414.89	414.85	414.85	1000.0
2021-05-11 04:04:00	SPY	ETF	414.74	414.74	414.44	414.44	3400.0
2021-05-11 04:05:00	SPY	ETF	414.32	414.32	414.2	414.2	2276.0
2021-05-11 04:06:00	SPY	ETF	414.26	414.26	414.25	414.25	200.0
2021-05-11 04:07:00	SPY	ETF	414.47	414.67	414.47	414.67	300.0
2021-05-11 04:08:00	SPY	ETF	414.58	414.71	414.58	414.71	3200.0
2021-05-11 04:09:00	SPY	ETF	414.86	414.9	414.84	414.9	1000.0
2021-05-11 04:10:00	SPY	ETF	414.92	414.94	414.77	414.86	5671.0
2021-05-11 04:11:00	SPY	ETF	414.7	414.72	414.7	414.72	1000.0
2021-05-11 04:12:00	SPY	ETF	414.69	414.69	414.63	414.63	900.0
2021-05-11 04:13:00	SPY	ETF	414.65	414.65	414.54	414.54	700.0
2021-05-11 04:14:00	SPY	ETF	414.42	414.47	414.41	414.47	500.0
2021-05-11 04:15:00	SPY	ETF	414.31	414.34	414.31	414.34	300.0
2021-05-11 04:16:00	SPY	ETF	414.39	414.48	414.39	414.48	700.0
2021-05-11 04:17:00	SPY	ETF	414.42	414.42	414.29	414.29	700.0
2021-05-11 04:18:00	SPY	ETF	414.23	414.29	414.23	414.23	600.0
2021-05-11 04:19:00	SPY	ETF	414.16	414.22	414.16	414.19	900.0
2021-05-11 04:20:00	SPY	ETF	414.18	414.34	414.16	414.34	7200.0
2021-05-11 04:21:00	SPY	ETF	414.42	414.44	414.42	414.44	200.0
2021-05-11 04:22:00	SPY	ETF	414.44	414.55	414.44	414.53	1400.0
2021-05-11 04:23:00	SPY	ETF	414.58	414.68	414.56	414.67	3200.0
2021-05-11 04:24:00	SPY	ETF	414.69	414.69	414.53	414.55	500.0
2021-05-11 04:25:00	SPY	ETF	414.48	414.48	414.38	414.38	500.0
2021-05-11 04:26:00	SPY	ETF	414.52	414.54	414.52	414.52	500.0
2021-05-11 04:27:00	SPY	ETF	414.61	414.61	414.61	414.61	200.0
2021-05-11 04:28:00	SPY	ETF	414.66	414.72	414.66	414.69	1200.0
2021-05-11 04:29:00	SPY	ETF	414.71	414.71	414.71	414.71	100.0
2021-05-11 04:30:00	SPY	ETF	414.61	414.62	414.6	414.61	3000.0
2021-05-11 04:31:00	SPY	ETF	414.73	414.73	414.73	414.73	310.0
2021-05-11 04:32:00	SPY	ETF	414.79	414.89	414.79	414.88	5399.0
2021-05-11 04:33:00	SPY	ETF	414.81	414.85	414.73	414.77	11951.0
2021-05-11 04:34:00	SPY	ETF	414.71	414.71	414.65	414.65	1800.0
2021-05-11 04:35:00	SPY	ETF	414.68	414.68	414.68	414.68	100.0
2021-05-11 04:36:00	SPY	ETF	414.73	414.74	414.73	414.74	200.0
2021-05-11 04:37:00	SPY	ETF	414.73	414.74	414.73	414.74	1800.0
2021-05-11 04:38:00	SPY	ETF	414.9	414.9	414.81	414.81	3200.0
2021-05-11 04:39:00	SPY	ETF	414.84	414.84	414.84	414.84	100.0
2021-05-11 04:40:00	SPY	ETF	414.76	414.89	414.76	414.89	1200.0
2021-05-11 04:41:00	SPY	ETF	414.96	415.04	414.96	415.04	2200.0
2021-05-11 04:42:00	SPY	ETF	414.93	414.94	414.93	414.94	300.0
2021-05-11 04:43:00	SPY	ETF	414.93	414.93	414.9	414.92	600.0
2021-05-11 04:44:00	SPY	ETF	414.86	414.88	414.82	414.88	700.0
2021-05-11 04:45:00	SPY	ETF	414.94	414.94	414.86	414.86	500.0
2021-05-11 04:47:00	SPY	ETF	415.05	415.05	415.05	415.05	100.0
2021-05-11 04:48:00	SPY	ETF	415.02	415.02	415.01	415.01	1000.0
2021-05-11 04:49:00	SPY	ETF	415.0	415.0	415.0	415.0	100.0
2021-05-11 04:50:00	SPY	ETF	414.99	415.0	414.99	414.99	700.0

> showing 50 of 254,739 rows — these rows as CSV

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