PREVIEW / etf_1min / 2018-04-04

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-04-04.parquet
  size:    3.3 MB
  rows:    168,014

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
2018-04-04 04:00:00	SPY	ETF	257.98	258.09	257.98	258.04	5468.0
2018-04-04 04:01:00	SPY	ETF	258.03	258.12	258.02	258.02	9145.0
2018-04-04 04:02:00	SPY	ETF	257.97	257.97	257.96	257.96	2742.0
2018-04-04 04:03:00	SPY	ETF	257.85	257.99	257.85	257.96	11460.0
2018-04-04 04:04:00	SPY	ETF	257.95	257.95	257.75	257.75	4150.0
2018-04-04 04:05:00	SPY	ETF	257.73	257.83	257.65	257.65	1300.0
2018-04-04 04:06:00	SPY	ETF	257.78	257.78	257.78	257.78	325.0
2018-04-04 04:07:00	SPY	ETF	257.63	257.63	257.47	257.47	1340.0
2018-04-04 04:08:00	SPY	ETF	257.49	257.58	257.3	257.55	5785.0
2018-04-04 04:09:00	SPY	ETF	257.48	257.48	257.23	257.23	6100.0
2018-04-04 04:10:00	SPY	ETF	257.33	257.43	256.81	256.81	3198.0
2018-04-04 04:11:00	SPY	ETF	256.73	256.73	256.5	256.58	21542.0
2018-04-04 04:12:00	SPY	ETF	256.44	256.5	256.39	256.5	5250.0
2018-04-04 04:13:00	SPY	ETF	256.78	256.78	256.78	256.78	1121.0
2018-04-04 04:14:00	SPY	ETF	257.0	257.22	257.0	257.17	3010.0
2018-04-04 04:15:00	SPY	ETF	257.11	257.11	257.05	257.05	1555.0
2018-04-04 04:16:00	SPY	ETF	257.29	257.33	257.23	257.33	4180.0
2018-04-04 04:17:00	SPY	ETF	257.25	257.25	257.02	257.02	5900.0
2018-04-04 04:18:00	SPY	ETF	257.2	257.2	257.2	257.2	1850.0
2018-04-04 04:19:00	SPY	ETF	257.4	257.57	257.4	257.53	7525.0
2018-04-04 04:20:00	SPY	ETF	257.53	257.53	257.32	257.32	1900.0
2018-04-04 04:21:00	SPY	ETF	257.17	257.22	257.17	257.19	3200.0
2018-04-04 04:22:00	SPY	ETF	256.93	256.97	256.93	256.95	400.0
2018-04-04 04:23:00	SPY	ETF	256.91	257.05	256.91	257.05	2100.0
2018-04-04 04:24:00	SPY	ETF	257.0	257.0	257.0	257.0	101.0
2018-04-04 04:25:00	SPY	ETF	257.18	257.18	257.18	257.18	500.0
2018-04-04 04:26:00	SPY	ETF	257.02	257.02	257.0	257.0	5100.0
2018-04-04 04:27:00	SPY	ETF	256.95	256.95	256.95	256.95	539.0
2018-04-04 04:28:00	SPY	ETF	257.18	257.18	257.18	257.18	560.0
2018-04-04 04:29:00	SPY	ETF	257.18	257.18	257.18	257.18	500.0
2018-04-04 04:30:00	SPY	ETF	257.22	257.22	256.97	256.97	1300.0
2018-04-04 04:32:00	SPY	ETF	256.89	256.89	256.89	256.89	100.0
2018-04-04 04:33:00	SPY	ETF	256.68	256.7	256.68	256.7	660.0
2018-04-04 04:34:00	SPY	ETF	256.75	256.78	256.73	256.73	2500.0
2018-04-04 04:35:00	SPY	ETF	256.69	256.8	256.69	256.8	350.0
2018-04-04 04:36:00	SPY	ETF	256.78	257.15	256.78	257.1	6800.0
2018-04-04 04:37:00	SPY	ETF	257.18	257.25	257.16	257.24	1550.0
2018-04-04 04:38:00	SPY	ETF	257.22	257.24	257.2	257.2	1500.0
2018-04-04 04:39:00	SPY	ETF	257.24	257.24	257.16	257.2	1725.0
2018-04-04 04:41:00	SPY	ETF	257.31	257.33	257.3	257.33	600.0
2018-04-04 04:42:00	SPY	ETF	257.18	257.23	257.18	257.23	200.0
2018-04-04 04:43:00	SPY	ETF	257.2	257.2	257.2	257.2	7125.0
2018-04-04 04:45:00	SPY	ETF	256.9	256.9	256.87	256.9	1200.0
2018-04-04 04:47:00	SPY	ETF	256.82	256.82	256.82	256.82	4000.0
2018-04-04 04:48:00	SPY	ETF	256.9	256.9	256.9	256.9	600.0
2018-04-04 04:49:00	SPY	ETF	256.94	256.94	256.94	256.94	202.0
2018-04-04 04:51:00	SPY	ETF	257.0	257.05	257.0	257.05	2540.0
2018-04-04 04:52:00	SPY	ETF	257.08	257.2	257.08	257.2	2040.0
2018-04-04 04:53:00	SPY	ETF	257.1	257.1	257.05	257.05	500.0
2018-04-04 04:54:00	SPY	ETF	257.1	257.16	257.1	257.16	200.0

> showing 50 of 168,014 rows — these rows as CSV

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