PREVIEW / etf_1min / 2020-07-27

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-07-27.parquet
  size:    3.6 MB
  rows:    203,300

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-07-27 04:00:00	SPY	ETF	321.52	321.69	321.52	321.69	1838.0
2020-07-27 04:01:00	SPY	ETF	321.67	321.72	321.67	321.68	1195.0
2020-07-27 04:02:00	SPY	ETF	321.65	321.7	321.65	321.7	1490.0
2020-07-27 04:03:00	SPY	ETF	321.68	321.77	321.64	321.77	1741.0
2020-07-27 04:04:00	SPY	ETF	321.84	321.86	321.79	321.79	3875.0
2020-07-27 04:05:00	SPY	ETF	321.78	321.78	321.78	321.78	174.0
2020-07-27 04:10:00	SPY	ETF	321.81	321.81	321.81	321.81	196.0
2020-07-27 04:11:00	SPY	ETF	321.82	321.82	321.81	321.81	704.0
2020-07-27 04:12:00	SPY	ETF	321.79	321.79	321.79	321.79	512.0
2020-07-27 04:13:00	SPY	ETF	321.81	321.81	321.81	321.81	540.0
2020-07-27 04:15:00	SPY	ETF	321.88	321.88	321.88	321.88	100.0
2020-07-27 04:16:00	SPY	ETF	321.86	321.88	321.86	321.88	800.0
2020-07-27 04:17:00	SPY	ETF	321.88	321.88	321.88	321.88	510.0
2020-07-27 04:18:00	SPY	ETF	321.86	321.86	321.86	321.86	1032.0
2020-07-27 04:19:00	SPY	ETF	321.96	321.96	321.96	321.96	5026.0
2020-07-27 04:21:00	SPY	ETF	321.86	321.86	321.86	321.86	129.0
2020-07-27 04:22:00	SPY	ETF	321.8	321.8	321.8	321.8	180.0
2020-07-27 04:23:00	SPY	ETF	321.74	321.74	321.7	321.7	300.0
2020-07-27 04:26:00	SPY	ETF	321.76	321.76	321.76	321.76	125.0
2020-07-27 04:27:00	SPY	ETF	321.7	321.7	321.7	321.7	125.0
2020-07-27 04:30:00	SPY	ETF	321.73	321.73	321.64	321.64	401.0
2020-07-27 04:31:00	SPY	ETF	321.84	321.84	321.81	321.81	296.0
2020-07-27 04:32:00	SPY	ETF	321.86	321.86	321.86	321.86	100.0
2020-07-27 04:35:00	SPY	ETF	321.93	321.93	321.93	321.93	300.0
2020-07-27 04:36:00	SPY	ETF	321.97	321.97	321.97	321.97	586.0
2020-07-27 04:39:00	SPY	ETF	321.91	321.91	321.86	321.86	1518.0
2020-07-27 04:41:00	SPY	ETF	321.85	321.85	321.85	321.85	510.0
2020-07-27 04:45:00	SPY	ETF	321.68	321.8	321.68	321.8	1300.0
2020-07-27 04:46:00	SPY	ETF	321.63	321.63	321.63	321.63	110.0
2020-07-27 04:47:00	SPY	ETF	321.6	321.6	321.56	321.56	710.0
2020-07-27 04:49:00	SPY	ETF	321.53	321.58	321.53	321.58	519.0
2020-07-27 04:54:00	SPY	ETF	321.65	321.65	321.65	321.65	200.0
2020-07-27 04:57:00	SPY	ETF	321.51	321.51	321.51	321.51	1008.0
2020-07-27 05:00:00	SPY	ETF	321.59	321.59	321.59	321.59	425.0
2020-07-27 05:01:00	SPY	ETF	321.65	321.65	321.65	321.65	801.0
2020-07-27 05:03:00	SPY	ETF	321.63	321.63	321.63	321.63	100.0
2020-07-27 05:04:00	SPY	ETF	321.47	321.47	321.47	321.47	222.0
2020-07-27 05:05:00	SPY	ETF	321.58	321.58	321.58	321.58	135.0
2020-07-27 05:06:00	SPY	ETF	321.61	321.61	321.61	321.61	100.0
2020-07-27 05:09:00	SPY	ETF	321.59	321.61	321.58	321.61	4000.0
2020-07-27 05:12:00	SPY	ETF	321.66	321.66	321.66	321.66	400.0
2020-07-27 05:15:00	SPY	ETF	321.54	321.54	321.54	321.54	500.0
2020-07-27 05:16:00	SPY	ETF	321.6	321.6	321.6	321.6	110.0
2020-07-27 05:17:00	SPY	ETF	321.76	321.76	321.76	321.76	200.0
2020-07-27 05:19:00	SPY	ETF	321.81	321.81	321.81	321.81	261.0
2020-07-27 05:20:00	SPY	ETF	321.93	321.93	321.93	321.93	430.0
2020-07-27 05:26:00	SPY	ETF	321.79	321.79	321.79	321.79	400.0
2020-07-27 05:27:00	SPY	ETF	321.95	321.95	321.95	321.95	160.0
2020-07-27 05:28:00	SPY	ETF	321.99	321.99	321.99	321.99	110.0
2020-07-27 05:29:00	SPY	ETF	322.0	322.1	322.0	322.1	284.0

> showing 50 of 203,300 rows — these rows as CSV

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