PREVIEW / etf_1min / 2019-07-30

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-07-30.parquet
  size:    3.0 MB
  rows:    157,779

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-07-30 04:00:00	SPY	ETF	301.36	301.36	301.36	301.36	200.0
2019-07-30 04:01:00	SPY	ETF	301.36	301.36	301.36	301.36	400.0
2019-07-30 04:03:00	SPY	ETF	301.35	301.35	301.35	301.35	240.0
2019-07-30 04:04:00	SPY	ETF	301.38	301.38	301.38	301.38	440.0
2019-07-30 04:05:00	SPY	ETF	301.35	301.35	301.35	301.35	300.0
2019-07-30 04:06:00	SPY	ETF	301.35	301.36	301.35	301.35	800.0
2019-07-30 04:07:00	SPY	ETF	301.35	301.35	301.35	301.35	600.0
2019-07-30 04:08:00	SPY	ETF	301.35	301.35	301.31	301.32	1690.0
2019-07-30 04:09:00	SPY	ETF	301.25	301.25	301.25	301.25	100.0
2019-07-30 04:17:00	SPY	ETF	301.36	301.36	301.36	301.36	1000.0
2019-07-30 04:21:00	SPY	ETF	301.28	301.28	301.28	301.28	200.0
2019-07-30 04:22:00	SPY	ETF	301.25	301.25	301.21	301.21	300.0
2019-07-30 04:23:00	SPY	ETF	301.27	301.27	301.2	301.2	600.0
2019-07-30 04:24:00	SPY	ETF	301.17	301.17	301.17	301.17	200.0
2019-07-30 04:25:00	SPY	ETF	301.22	301.23	301.22	301.23	5000.0
2019-07-30 04:26:00	SPY	ETF	301.23	301.23	301.23	301.23	1000.0
2019-07-30 04:27:00	SPY	ETF	301.22	301.22	301.22	301.22	100.0
2019-07-30 04:28:00	SPY	ETF	301.24	301.24	301.24	301.24	269.0
2019-07-30 04:29:00	SPY	ETF	301.22	301.22	301.22	301.22	338.0
2019-07-30 04:30:00	SPY	ETF	301.19	301.19	301.13	301.13	609.0
2019-07-30 04:32:00	SPY	ETF	301.09	301.09	301.03	301.03	1327.0
2019-07-30 04:33:00	SPY	ETF	301.07	301.07	301.07	301.07	100.0
2019-07-30 04:36:00	SPY	ETF	300.96	300.96	300.93	300.93	829.0
2019-07-30 04:37:00	SPY	ETF	300.94	300.94	300.85	300.85	600.0
2019-07-30 04:40:00	SPY	ETF	300.91	300.91	300.91	300.91	100.0
2019-07-30 04:42:00	SPY	ETF	300.93	301.0	300.93	301.0	807.0
2019-07-30 04:43:00	SPY	ETF	301.03	301.03	301.03	301.03	169.0
2019-07-30 04:44:00	SPY	ETF	300.99	300.99	300.99	300.99	169.0
2019-07-30 04:46:00	SPY	ETF	300.97	300.97	300.97	300.97	169.0
2019-07-30 04:47:00	SPY	ETF	300.97	300.97	300.96	300.96	269.0
2019-07-30 04:48:00	SPY	ETF	300.98	300.98	300.98	300.98	169.0
2019-07-30 04:49:00	SPY	ETF	301.01	301.01	301.01	301.01	100.0
2019-07-30 04:50:00	SPY	ETF	300.98	300.98	300.98	300.98	100.0
2019-07-30 04:59:00	SPY	ETF	300.81	300.81	300.8	300.8	310.0
2019-07-30 05:00:00	SPY	ETF	300.8	300.8	300.8	300.8	101.0
2019-07-30 05:05:00	SPY	ETF	300.86	300.86	300.86	300.86	800.0
2019-07-30 05:06:00	SPY	ETF	300.83	300.83	300.83	300.83	3000.0
2019-07-30 05:10:00	SPY	ETF	300.82	300.82	300.76	300.76	1500.0
2019-07-30 05:21:00	SPY	ETF	300.81	300.81	300.81	300.81	100.0
2019-07-30 05:22:00	SPY	ETF	300.73	300.73	300.68	300.68	7000.0
2019-07-30 05:23:00	SPY	ETF	300.68	300.68	300.65	300.65	3100.0
2019-07-30 05:24:00	SPY	ETF	300.65	300.65	300.6	300.6	8150.0
2019-07-30 05:25:00	SPY	ETF	300.57	300.62	300.57	300.62	2050.0
2019-07-30 05:26:00	SPY	ETF	300.6	300.64	300.6	300.6	5900.0
2019-07-30 05:27:00	SPY	ETF	300.72	300.72	300.72	300.72	100.0
2019-07-30 05:28:00	SPY	ETF	300.72	300.72	300.72	300.72	100.0
2019-07-30 05:31:00	SPY	ETF	300.7	300.7	300.7	300.7	514.0
2019-07-30 05:34:00	SPY	ETF	300.67	300.72	300.65	300.66	10500.0
2019-07-30 05:35:00	SPY	ETF	300.64	300.64	300.63	300.63	14700.0
2019-07-30 05:36:00	SPY	ETF	300.61	300.61	300.61	300.61	300.0

> showing 50 of 157,779 rows — these rows as CSV

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