PREVIEW / etf_1min / 2018-10-12

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-10-12.parquet
  size:    3.8 MB
  rows:    194,095

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-10-12 04:00:00	SPY	ETF	276.5	277.0	276.5	276.89	7270.0
2018-10-12 04:01:00	SPY	ETF	276.75	276.85	276.75	276.85	1310.0
2018-10-12 04:03:00	SPY	ETF	276.85	276.85	276.85	276.85	1430.0
2018-10-12 04:04:00	SPY	ETF	276.85	276.85	276.85	276.85	110.0
2018-10-12 04:05:00	SPY	ETF	276.8	276.8	276.8	276.8	300.0
2018-10-12 04:06:00	SPY	ETF	276.8	276.8	276.73	276.73	1700.0
2018-10-12 04:07:00	SPY	ETF	276.75	276.75	276.68	276.68	3800.0
2018-10-12 04:08:00	SPY	ETF	276.68	276.73	276.58	276.63	5100.0
2018-10-12 04:09:00	SPY	ETF	276.63	276.73	276.61	276.73	7400.0
2018-10-12 04:10:00	SPY	ETF	276.7	276.7	276.68	276.68	500.0
2018-10-12 04:11:00	SPY	ETF	276.6	276.63	276.58	276.59	2501.0
2018-10-12 04:12:00	SPY	ETF	276.63	276.63	276.63	276.63	2300.0
2018-10-12 04:13:00	SPY	ETF	276.58	276.58	276.58	276.58	5408.0
2018-10-12 04:14:00	SPY	ETF	276.58	276.58	276.51	276.57	2660.0
2018-10-12 04:15:00	SPY	ETF	276.63	276.68	276.56	276.63	6400.0
2018-10-12 04:16:00	SPY	ETF	276.74	276.74	276.72	276.72	1300.0
2018-10-12 04:17:00	SPY	ETF	276.53	276.53	276.5	276.5	800.0
2018-10-12 04:18:00	SPY	ETF	276.5	276.5	276.43	276.43	2072.0
2018-10-12 04:19:00	SPY	ETF	276.47	276.47	276.47	276.47	500.0
2018-10-12 04:20:00	SPY	ETF	276.45	276.45	276.43	276.43	680.0
2018-10-12 04:21:00	SPY	ETF	276.5	276.5	276.5	276.5	400.0
2018-10-12 04:22:00	SPY	ETF	276.39	276.39	276.18	276.18	2000.0
2018-10-12 04:24:00	SPY	ETF	276.18	276.18	276.08	276.08	1100.0
2018-10-12 04:25:00	SPY	ETF	276.09	276.09	276.08	276.08	500.0
2018-10-12 04:27:00	SPY	ETF	276.1	276.1	276.1	276.1	200.0
2018-10-12 04:28:00	SPY	ETF	276.24	276.33	276.24	276.27	1480.0
2018-10-12 04:29:00	SPY	ETF	276.3	276.33	276.3	276.33	2456.0
2018-10-12 04:30:00	SPY	ETF	276.13	276.13	276.11	276.11	400.0
2018-10-12 04:31:00	SPY	ETF	276.16	276.16	275.93	275.93	700.0
2018-10-12 04:32:00	SPY	ETF	276.03	276.03	276.03	276.03	100.0
2018-10-12 04:33:00	SPY	ETF	275.98	275.98	275.93	275.93	2230.0
2018-10-12 04:34:00	SPY	ETF	276.0	276.0	275.93	275.93	1100.0
2018-10-12 04:35:00	SPY	ETF	275.91	275.91	275.91	275.91	2150.0
2018-10-12 04:38:00	SPY	ETF	276.02	276.02	276.02	276.02	420.0
2018-10-12 04:39:00	SPY	ETF	276.11	276.2	276.11	276.2	635.0
2018-10-12 04:40:00	SPY	ETF	276.08	276.08	276.08	276.08	715.0
2018-10-12 04:41:00	SPY	ETF	275.98	276.05	275.98	276.05	2000.0
2018-10-12 04:42:00	SPY	ETF	276.09	276.1	276.09	276.1	410.0
2018-10-12 04:43:00	SPY	ETF	276.01	276.01	275.95	275.95	300.0
2018-10-12 04:44:00	SPY	ETF	275.99	275.99	275.99	275.99	10000.0
2018-10-12 04:45:00	SPY	ETF	276.08	276.09	276.06	276.09	900.0
2018-10-12 04:46:00	SPY	ETF	275.98	275.98	275.98	275.98	100.0
2018-10-12 04:51:00	SPY	ETF	275.93	276.11	275.93	276.11	10200.0
2018-10-12 04:52:00	SPY	ETF	276.14	276.16	276.14	276.16	1700.0
2018-10-12 04:53:00	SPY	ETF	276.1	276.13	276.04	276.04	700.0
2018-10-12 04:54:00	SPY	ETF	276.08	276.1	276.08	276.1	3150.0
2018-10-12 04:55:00	SPY	ETF	276.05	276.05	275.98	275.98	1400.0
2018-10-12 04:56:00	SPY	ETF	275.89	275.97	275.88	275.88	15735.0
2018-10-12 04:57:00	SPY	ETF	275.92	275.95	275.85	275.85	2200.0
2018-10-12 04:58:00	SPY	ETF	275.8	275.8	275.78	275.8	2550.0

> showing 50 of 194,095 rows — these rows as CSV

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