PREVIEW / etf_1min / 2018-11-14

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-11-14.parquet
  size:    3.4 MB
  rows:    179,619

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-11-14 04:00:00	SPY	ETF	271.1	271.85	270.85	271.01	19329.0
2018-11-14 04:01:00	SPY	ETF	271.01	271.01	270.95	270.95	1000.0
2018-11-14 04:02:00	SPY	ETF	271.02	271.02	271.02	271.02	400.0
2018-11-14 04:03:00	SPY	ETF	271.02	271.02	270.93	270.93	650.0
2018-11-14 04:04:00	SPY	ETF	271.02	271.04	271.0	271.04	2270.0
2018-11-14 04:05:00	SPY	ETF	271.0	271.09	271.0	271.09	310.0
2018-11-14 04:06:00	SPY	ETF	270.97	271.0	270.97	271.0	1200.0
2018-11-14 04:07:00	SPY	ETF	271.0	271.0	271.0	271.0	700.0
2018-11-14 04:08:00	SPY	ETF	271.0	271.0	270.95	270.95	2000.0
2018-11-14 04:09:00	SPY	ETF	270.92	270.94	270.9	270.94	615.0
2018-11-14 04:10:00	SPY	ETF	270.9	270.99	270.9	270.99	2500.0
2018-11-14 04:13:00	SPY	ETF	271.19	271.2	271.19	271.2	669.0
2018-11-14 04:14:00	SPY	ETF	271.22	271.27	271.22	271.27	2129.0
2018-11-14 04:15:00	SPY	ETF	271.29	271.33	271.29	271.33	1069.0
2018-11-14 04:19:00	SPY	ETF	271.22	271.25	271.22	271.25	547.0
2018-11-14 04:20:00	SPY	ETF	271.25	271.25	271.24	271.24	500.0
2018-11-14 04:21:00	SPY	ETF	271.27	271.27	271.27	271.27	460.0
2018-11-14 04:22:00	SPY	ETF	271.2	271.21	271.2	271.2	10190.0
2018-11-14 04:23:00	SPY	ETF	271.19	271.19	271.16	271.16	2269.0
2018-11-14 04:24:00	SPY	ETF	271.23	271.23	271.23	271.23	100.0
2018-11-14 04:25:00	SPY	ETF	271.29	271.38	271.29	271.35	1138.0
2018-11-14 04:26:00	SPY	ETF	271.35	271.35	271.35	271.35	511.0
2018-11-14 04:27:00	SPY	ETF	271.35	271.35	271.35	271.35	270.0
2018-11-14 04:28:00	SPY	ETF	271.39	271.41	271.39	271.4	869.0
2018-11-14 04:29:00	SPY	ETF	271.44	271.44	271.44	271.44	369.0
2018-11-14 04:30:00	SPY	ETF	271.42	271.42	271.4	271.4	1000.0
2018-11-14 04:31:00	SPY	ETF	271.37	271.37	271.35	271.35	1000.0
2018-11-14 04:32:00	SPY	ETF	271.42	271.48	271.42	271.48	1500.0
2018-11-14 04:33:00	SPY	ETF	271.49	271.49	271.43	271.48	4169.0
2018-11-14 04:34:00	SPY	ETF	271.42	271.53	271.42	271.53	2900.0
2018-11-14 04:37:00	SPY	ETF	271.4	271.41	271.4	271.41	2169.0
2018-11-14 04:39:00	SPY	ETF	271.41	271.41	271.41	271.41	100.0
2018-11-14 04:40:00	SPY	ETF	271.54	271.63	271.54	271.55	1307.0
2018-11-14 04:41:00	SPY	ETF	271.53	271.53	271.53	271.53	100.0
2018-11-14 04:42:00	SPY	ETF	271.4	271.4	271.4	271.4	200.0
2018-11-14 04:43:00	SPY	ETF	271.4	271.4	271.38	271.38	569.0
2018-11-14 04:44:00	SPY	ETF	271.37	271.37	271.34	271.34	1369.0
2018-11-14 04:47:00	SPY	ETF	271.4	271.4	271.4	271.4	215.0
2018-11-14 04:48:00	SPY	ETF	271.4	271.4	271.4	271.4	5000.0
2018-11-14 04:52:00	SPY	ETF	271.41	271.41	271.41	271.41	169.0
2018-11-14 04:53:00	SPY	ETF	271.51	271.53	271.51	271.51	569.0
2018-11-14 04:54:00	SPY	ETF	271.53	271.53	271.53	271.53	230.0
2018-11-14 04:55:00	SPY	ETF	271.55	271.59	271.55	271.59	3169.0
2018-11-14 04:58:00	SPY	ETF	271.56	271.56	271.55	271.55	2800.0
2018-11-14 04:59:00	SPY	ETF	271.7	271.7	271.68	271.68	750.0
2018-11-14 05:00:00	SPY	ETF	271.68	271.68	271.65	271.65	550.0
2018-11-14 05:01:00	SPY	ETF	271.58	271.58	271.58	271.58	500.0
2018-11-14 05:04:00	SPY	ETF	271.55	271.55	271.55	271.55	300.0
2018-11-14 05:05:00	SPY	ETF	271.55	271.55	271.52	271.53	851.0
2018-11-14 05:07:00	SPY	ETF	271.5	271.5	271.48	271.48	3609.0

> showing 50 of 179,619 rows — these rows as CSV

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