PREVIEW / etf_1min / 2018-12-14

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-12-14.parquet
  size:    3.5 MB
  rows:    181,948

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-12-14 04:00:00	SPY	ETF	262.24	262.29	262.0	262.15	3449.0
2018-12-14 04:01:00	SPY	ETF	262.15	262.34	262.15	262.15	10805.0
2018-12-14 04:02:00	SPY	ETF	262.24	262.24	262.24	262.24	100.0
2018-12-14 04:03:00	SPY	ETF	262.35	262.35	262.24	262.3	2938.0
2018-12-14 04:04:00	SPY	ETF	262.3	262.3	262.29	262.29	7910.0
2018-12-14 04:05:00	SPY	ETF	262.22	262.22	262.2	262.2	369.0
2018-12-14 04:06:00	SPY	ETF	262.18	262.18	262.12	262.12	371.0
2018-12-14 04:07:00	SPY	ETF	262.12	262.15	262.1	262.15	10500.0
2018-12-14 04:09:00	SPY	ETF	262.2	262.2	262.2	262.2	200.0
2018-12-14 04:10:00	SPY	ETF	262.17	262.17	262.1	262.17	938.0
2018-12-14 04:12:00	SPY	ETF	262.14	262.14	262.05	262.05	407.0
2018-12-14 04:13:00	SPY	ETF	262.05	262.05	262.05	262.05	200.0
2018-12-14 04:14:00	SPY	ETF	262.15	262.23	262.15	262.23	469.0
2018-12-14 04:15:00	SPY	ETF	262.21	262.21	262.15	262.15	369.0
2018-12-14 04:16:00	SPY	ETF	262.12	262.12	262.12	262.12	500.0
2018-12-14 04:18:00	SPY	ETF	262.17	262.17	262.17	262.17	630.0
2018-12-14 04:19:00	SPY	ETF	262.12	262.12	262.1	262.1	675.0
2018-12-14 04:20:00	SPY	ETF	262.04	262.04	262.0	262.02	5269.0
2018-12-14 04:21:00	SPY	ETF	262.01	262.01	262.01	262.01	207.0
2018-12-14 04:22:00	SPY	ETF	261.97	261.97	261.92	261.92	569.0
2018-12-14 04:23:00	SPY	ETF	261.95	261.95	261.95	261.95	1100.0
2018-12-14 04:24:00	SPY	ETF	261.95	261.95	261.95	261.95	333.0
2018-12-14 04:26:00	SPY	ETF	261.93	261.94	261.9	261.94	2800.0
2018-12-14 04:28:00	SPY	ETF	261.9	261.9	261.9	261.9	100.0
2018-12-14 04:29:00	SPY	ETF	261.89	261.89	261.89	261.89	125.0
2018-12-14 04:31:00	SPY	ETF	261.93	261.93	261.93	261.93	100.0
2018-12-14 04:33:00	SPY	ETF	261.93	261.93	261.93	261.93	200.0
2018-12-14 04:35:00	SPY	ETF	261.89	261.9	261.89	261.9	2694.0
2018-12-14 04:36:00	SPY	ETF	261.92	261.92	261.92	261.92	510.0
2018-12-14 04:37:00	SPY	ETF	261.91	261.91	261.91	261.91	200.0
2018-12-14 04:39:00	SPY	ETF	261.95	261.95	261.95	261.95	2500.0
2018-12-14 04:41:00	SPY	ETF	261.95	261.97	261.92	261.92	1269.0
2018-12-14 04:42:00	SPY	ETF	261.86	261.9	261.86	261.87	4068.0
2018-12-14 04:43:00	SPY	ETF	261.87	261.87	261.86	261.86	6450.0
2018-12-14 04:44:00	SPY	ETF	261.87	261.87	261.85	261.85	609.0
2018-12-14 04:46:00	SPY	ETF	261.85	261.85	261.8	261.8	769.0
2018-12-14 04:48:00	SPY	ETF	261.85	261.85	261.85	261.85	1000.0
2018-12-14 04:49:00	SPY	ETF	261.82	261.82	261.82	261.82	1000.0
2018-12-14 04:50:00	SPY	ETF	262.0	262.05	262.0	262.05	4776.0
2018-12-14 04:51:00	SPY	ETF	262.07	262.1	262.01	262.1	869.0
2018-12-14 04:53:00	SPY	ETF	262.1	262.1	262.05	262.05	1444.0
2018-12-14 04:54:00	SPY	ETF	262.12	262.12	262.12	262.12	367.0
2018-12-14 04:55:00	SPY	ETF	262.1	262.1	262.1	262.1	2233.0
2018-12-14 04:56:00	SPY	ETF	262.15	262.15	262.15	262.15	194.0
2018-12-14 04:57:00	SPY	ETF	262.12	262.12	262.12	262.12	400.0
2018-12-14 04:58:00	SPY	ETF	262.1	262.1	262.1	262.1	269.0
2018-12-14 05:01:00	SPY	ETF	262.15	262.25	262.15	262.25	507.0
2018-12-14 05:02:00	SPY	ETF	262.3	262.46	262.3	262.44	4345.0
2018-12-14 05:03:00	SPY	ETF	262.5	262.67	262.5	262.63	7316.0
2018-12-14 05:04:00	SPY	ETF	262.66	262.66	262.6	262.62	1707.0

> showing 50 of 181,948 rows — these rows as CSV

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