PREVIEW / etf_1min / 2018-03-23

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-03-23.parquet
  size:    3.4 MB
  rows:    173,207

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-03-23 04:00:00	SPY	ETF	263.39	263.86	263.3	263.52	1925.0
2018-03-23 04:01:00	SPY	ETF	263.43	263.44	263.43	263.44	350.0
2018-03-23 04:02:00	SPY	ETF	263.51	263.51	263.45	263.45	3140.0
2018-03-23 04:03:00	SPY	ETF	263.5	263.5	263.5	263.5	565.0
2018-03-23 04:04:00	SPY	ETF	263.44	263.44	263.37	263.37	5255.0
2018-03-23 04:06:00	SPY	ETF	263.49	263.52	263.49	263.49	3113.0
2018-03-23 04:07:00	SPY	ETF	263.42	263.42	263.27	263.27	375.0
2018-03-23 04:08:00	SPY	ETF	263.32	263.32	263.32	263.32	177.0
2018-03-23 04:09:00	SPY	ETF	263.24	263.38	263.24	263.38	3337.0
2018-03-23 04:11:00	SPY	ETF	263.47	263.53	263.47	263.53	625.0
2018-03-23 04:13:00	SPY	ETF	263.4	263.4	263.27	263.27	400.0
2018-03-23 04:14:00	SPY	ETF	263.27	263.27	263.27	263.27	300.0
2018-03-23 04:15:00	SPY	ETF	263.17	263.17	263.17	263.17	1050.0
2018-03-23 04:17:00	SPY	ETF	263.06	263.06	263.06	263.06	100.0
2018-03-23 04:18:00	SPY	ETF	263.01	263.01	263.01	263.01	1010.0
2018-03-23 04:19:00	SPY	ETF	263.16	263.16	263.16	263.16	125.0
2018-03-23 04:20:00	SPY	ETF	263.16	263.21	263.02	263.02	2300.0
2018-03-23 04:23:00	SPY	ETF	263.03	263.03	263.03	263.03	100.0
2018-03-23 04:24:00	SPY	ETF	262.97	263.0	262.97	263.0	2300.0
2018-03-23 04:25:00	SPY	ETF	262.89	262.89	262.89	262.89	301.0
2018-03-23 04:26:00	SPY	ETF	262.81	262.81	262.81	262.81	500.0
2018-03-23 04:27:00	SPY	ETF	262.8	262.8	262.79	262.79	2500.0
2018-03-23 04:32:00	SPY	ETF	262.86	262.86	262.86	262.86	1100.0
2018-03-23 04:35:00	SPY	ETF	262.56	262.56	262.56	262.56	1000.0
2018-03-23 04:36:00	SPY	ETF	262.65	262.75	262.65	262.75	4125.0
2018-03-23 04:38:00	SPY	ETF	262.79	262.79	262.79	262.79	1000.0
2018-03-23 04:39:00	SPY	ETF	262.68	262.7	262.68	262.7	400.0
2018-03-23 04:42:00	SPY	ETF	262.5	262.51	262.47	262.51	600.0
2018-03-23 04:43:00	SPY	ETF	262.54	262.65	262.54	262.65	800.0
2018-03-23 04:45:00	SPY	ETF	262.43	262.43	262.43	262.43	300.0
2018-03-23 04:46:00	SPY	ETF	262.6	262.66	262.6	262.66	1800.0
2018-03-23 04:49:00	SPY	ETF	262.59	262.59	262.45	262.45	1000.0
2018-03-23 04:52:00	SPY	ETF	262.5	262.5	262.5	262.5	500.0
2018-03-23 04:54:00	SPY	ETF	262.45	262.45	262.45	262.45	300.0
2018-03-23 04:55:00	SPY	ETF	262.45	262.45	262.45	262.45	100.0
2018-03-23 04:58:00	SPY	ETF	262.49	262.49	262.49	262.49	532.0
2018-03-23 04:59:00	SPY	ETF	262.55	262.56	262.55	262.56	500.0
2018-03-23 05:01:00	SPY	ETF	262.5	262.58	262.5	262.58	600.0
2018-03-23 05:02:00	SPY	ETF	262.6	262.61	262.6	262.61	1600.0
2018-03-23 05:03:00	SPY	ETF	262.66	262.66	262.62	262.62	800.0
2018-03-23 05:04:00	SPY	ETF	262.62	262.62	262.62	262.62	200.0
2018-03-23 05:05:00	SPY	ETF	262.5	262.5	262.47	262.47	1000.0
2018-03-23 05:06:00	SPY	ETF	262.47	262.47	262.35	262.35	1100.0
2018-03-23 05:07:00	SPY	ETF	262.42	262.56	262.42	262.56	633.0
2018-03-23 05:08:00	SPY	ETF	262.48	262.48	262.48	262.48	300.0
2018-03-23 05:09:00	SPY	ETF	262.63	262.71	262.63	262.71	1000.0
2018-03-23 05:10:00	SPY	ETF	262.55	262.55	262.5	262.5	400.0
2018-03-23 05:11:00	SPY	ETF	262.47	262.47	262.47	262.47	103.0
2018-03-23 05:12:00	SPY	ETF	262.42	262.42	262.42	262.42	300.0
2018-03-23 05:14:00	SPY	ETF	262.23	262.23	262.23	262.23	100.0

> showing 50 of 173,207 rows — these rows as CSV

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