PREVIEW / etf_1min / 2019-06-27

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-06-27.parquet
  size:    2.9 MB
  rows:    156,800

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
2019-06-27 04:00:00	SPY	ETF	291.79	291.79	291.79	291.79	1912.0
2019-06-27 04:02:00	SPY	ETF	291.8	291.8	291.8	291.8	320.0
2019-06-27 04:04:00	SPY	ETF	291.83	291.83	291.83	291.83	100.0
2019-06-27 04:07:00	SPY	ETF	291.83	291.83	291.82	291.82	615.0
2019-06-27 04:08:00	SPY	ETF	291.8	291.8	291.8	291.8	230.0
2019-06-27 04:10:00	SPY	ETF	291.67	291.67	291.66	291.66	1500.0
2019-06-27 04:14:00	SPY	ETF	291.67	291.67	291.67	291.67	212.0
2019-06-27 04:15:00	SPY	ETF	291.67	291.72	291.67	291.72	350.0
2019-06-27 04:20:00	SPY	ETF	291.71	291.71	291.71	291.71	110.0
2019-06-27 04:21:00	SPY	ETF	291.71	291.71	291.71	291.71	270.0
2019-06-27 04:22:00	SPY	ETF	291.77	291.77	291.77	291.77	100.0
2019-06-27 04:25:00	SPY	ETF	291.8	291.8	291.8	291.8	100.0
2019-06-27 04:27:00	SPY	ETF	291.8	291.8	291.8	291.8	100.0
2019-06-27 04:30:00	SPY	ETF	291.82	291.82	291.82	291.82	100.0
2019-06-27 04:35:00	SPY	ETF	291.8	291.8	291.8	291.8	500.0
2019-06-27 04:37:00	SPY	ETF	291.77	291.77	291.77	291.77	500.0
2019-06-27 04:38:00	SPY	ETF	291.72	291.72	291.72	291.72	200.0
2019-06-27 04:39:00	SPY	ETF	291.72	291.72	291.72	291.72	150.0
2019-06-27 04:41:00	SPY	ETF	291.54	291.54	291.54	291.54	810.0
2019-06-27 04:49:00	SPY	ETF	291.56	291.56	291.56	291.56	100.0
2019-06-27 04:52:00	SPY	ETF	291.56	291.6	291.56	291.6	4070.0
2019-06-27 04:55:00	SPY	ETF	291.64	291.64	291.64	291.64	633.0
2019-06-27 04:56:00	SPY	ETF	291.64	291.64	291.64	291.64	1080.0
2019-06-27 04:59:00	SPY	ETF	291.63	291.63	291.63	291.63	540.0
2019-06-27 05:03:00	SPY	ETF	291.61	291.61	291.61	291.61	500.0
2019-06-27 05:08:00	SPY	ETF	291.57	291.57	291.56	291.56	300.0
2019-06-27 05:12:00	SPY	ETF	291.57	291.57	291.57	291.57	260.0
2019-06-27 05:15:00	SPY	ETF	291.61	291.61	291.61	291.61	160.0
2019-06-27 05:16:00	SPY	ETF	291.64	291.64	291.64	291.64	160.0
2019-06-27 05:19:00	SPY	ETF	291.7	291.7	291.7	291.7	948.0
2019-06-27 05:21:00	SPY	ETF	291.69	291.69	291.69	291.69	1204.0
2019-06-27 05:26:00	SPY	ETF	291.8	291.8	291.8	291.8	200.0
2019-06-27 05:35:00	SPY	ETF	291.8	291.8	291.8	291.8	500.0
2019-06-27 05:39:00	SPY	ETF	291.74	291.74	291.72	291.74	1000.0
2019-06-27 05:40:00	SPY	ETF	291.74	291.74	291.74	291.74	500.0
2019-06-27 05:42:00	SPY	ETF	291.7	291.74	291.7	291.74	300.0
2019-06-27 05:46:00	SPY	ETF	291.6	291.6	291.55	291.55	10100.0
2019-06-27 05:47:00	SPY	ETF	291.55	292.26	291.53	291.53	28487.0
2019-06-27 05:51:00	SPY	ETF	291.48	291.48	291.48	291.48	574.0
2019-06-27 05:52:00	SPY	ETF	291.46	291.47	291.34	291.35	2000.0
2019-06-27 05:53:00	SPY	ETF	291.23	291.23	291.15	291.15	4084.0
2019-06-27 05:54:00	SPY	ETF	291.08	291.11	290.98	291.0	3704.0
2019-06-27 05:55:00	SPY	ETF	291.18	291.18	291.16	291.16	300.0
2019-06-27 05:56:00	SPY	ETF	291.13	291.13	291.02	291.02	2400.0
2019-06-27 06:00:00	SPY	ETF	291.04	291.11	291.0	291.0	7200.0
2019-06-27 06:01:00	SPY	ETF	290.98	291.0	290.98	291.0	2054.0
2019-06-27 06:02:00	SPY	ETF	290.8	290.8	290.68	290.68	347.0
2019-06-27 06:03:00	SPY	ETF	290.6	290.6	290.6	290.6	576.0
2019-06-27 06:04:00	SPY	ETF	290.6	290.6	290.45	290.45	5444.0
2019-06-27 06:05:00	SPY	ETF	290.51	290.51	290.51	290.51	4135.0

> showing 50 of 156,800 rows — these rows as CSV

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