PREVIEW / etf_1min / 2020-05-20

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-05-20.parquet
  size:    3.8 MB
  rows:    211,087

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
2020-05-20 04:00:00	SPY	ETF	293.38	293.46	293.38	293.44	2435.0
2020-05-20 04:01:00	SPY	ETF	293.51	293.51	293.49	293.49	462.0
2020-05-20 04:03:00	SPY	ETF	293.73	293.73	293.69	293.69	244.0
2020-05-20 04:04:00	SPY	ETF	293.63	293.63	293.63	293.63	3575.0
2020-05-20 04:05:00	SPY	ETF	293.62	293.63	293.62	293.63	430.0
2020-05-20 04:07:00	SPY	ETF	293.75	293.79	293.75	293.79	395.0
2020-05-20 04:08:00	SPY	ETF	293.83	293.83	293.82	293.82	218.0
2020-05-20 04:09:00	SPY	ETF	293.92	293.95	293.92	293.95	966.0
2020-05-20 04:10:00	SPY	ETF	293.97	293.97	293.97	293.97	540.0
2020-05-20 04:13:00	SPY	ETF	294.0	294.14	294.0	294.12	2535.0
2020-05-20 04:14:00	SPY	ETF	294.15	294.29	294.07	294.28	2485.0
2020-05-20 04:15:00	SPY	ETF	294.31	294.4	294.31	294.4	6365.0
2020-05-20 04:16:00	SPY	ETF	294.45	294.89	294.45	294.7	12122.0
2020-05-20 04:17:00	SPY	ETF	294.7	294.8	294.7	294.8	1100.0
2020-05-20 04:18:00	SPY	ETF	294.7	294.7	294.7	294.7	190.0
2020-05-20 04:19:00	SPY	ETF	294.68	294.73	294.68	294.73	1148.0
2020-05-20 04:20:00	SPY	ETF	294.92	295.05	294.92	295.03	6759.0
2020-05-20 04:21:00	SPY	ETF	294.92	294.94	294.9	294.9	1925.0
2020-05-20 04:22:00	SPY	ETF	294.92	294.92	294.92	294.92	589.0
2020-05-20 04:25:00	SPY	ETF	294.98	294.98	294.98	294.98	284.0
2020-05-20 04:26:00	SPY	ETF	294.9	294.9	294.88	294.88	1200.0
2020-05-20 04:27:00	SPY	ETF	294.92	294.92	294.85	294.85	3100.0
2020-05-20 04:29:00	SPY	ETF	295.0	295.0	294.97	294.97	435.0
2020-05-20 04:30:00	SPY	ETF	294.99	294.99	294.99	294.99	510.0
2020-05-20 04:31:00	SPY	ETF	295.0	295.0	294.93	294.93	700.0
2020-05-20 04:32:00	SPY	ETF	294.96	294.96	294.96	294.96	1020.0
2020-05-20 04:33:00	SPY	ETF	294.84	294.9	294.84	294.9	970.0
2020-05-20 04:34:00	SPY	ETF	294.8	294.86	294.76	294.76	2115.0
2020-05-20 04:35:00	SPY	ETF	294.7	294.88	294.7	294.84	1650.0
2020-05-20 04:36:00	SPY	ETF	294.86	294.97	294.86	294.93	1050.0
2020-05-20 04:37:00	SPY	ETF	294.84	294.84	294.84	294.84	330.0
2020-05-20 04:38:00	SPY	ETF	294.97	294.97	294.85	294.85	875.0
2020-05-20 04:40:00	SPY	ETF	294.87	294.91	294.87	294.91	700.0
2020-05-20 04:43:00	SPY	ETF	294.69	294.69	294.69	294.69	163.0
2020-05-20 04:44:00	SPY	ETF	294.67	294.7	294.67	294.7	606.0
2020-05-20 04:45:00	SPY	ETF	294.7	294.78	294.7	294.78	546.0
2020-05-20 04:46:00	SPY	ETF	294.66	294.66	294.66	294.66	300.0
2020-05-20 04:47:00	SPY	ETF	294.7	294.7	294.7	294.7	340.0
2020-05-20 04:48:00	SPY	ETF	294.76	294.76	294.76	294.76	100.0
2020-05-20 04:49:00	SPY	ETF	294.8	294.88	294.8	294.87	4508.0
2020-05-20 04:50:00	SPY	ETF	294.88	294.88	294.87	294.87	1253.0
2020-05-20 04:51:00	SPY	ETF	294.82	294.9	294.82	294.84	1332.0
2020-05-20 04:52:00	SPY	ETF	294.83	294.83	294.83	294.83	1025.0
2020-05-20 04:53:00	SPY	ETF	294.75	294.75	294.65	294.65	314.0
2020-05-20 04:54:00	SPY	ETF	294.65	294.7	294.63	294.7	1950.0
2020-05-20 04:55:00	SPY	ETF	294.73	294.73	294.73	294.73	275.0
2020-05-20 04:57:00	SPY	ETF	294.66	294.66	294.66	294.66	140.0
2020-05-20 04:58:00	SPY	ETF	294.71	294.76	294.71	294.76	800.0
2020-05-20 05:00:00	SPY	ETF	294.73	294.76	294.73	294.76	200.0
2020-05-20 05:01:00	SPY	ETF	294.78	294.8	294.78	294.8	250.0

> showing 50 of 211,087 rows — these rows as CSV

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