PREVIEW / etf_1min / 2019-09-16

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-09-16.parquet
  size:    3.1 MB
  rows:    166,457

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-09-16 04:00:00	SPY	ETF	299.69	299.69	299.63	299.63	777.0
2019-09-16 04:01:00	SPY	ETF	299.61	299.61	299.58	299.58	1200.0
2019-09-16 04:03:00	SPY	ETF	299.71	299.71	299.71	299.71	1025.0
2019-09-16 04:04:00	SPY	ETF	299.78	299.78	299.78	299.78	500.0
2019-09-16 04:05:00	SPY	ETF	299.91	299.91	299.91	299.91	143.0
2019-09-16 04:06:00	SPY	ETF	299.93	299.93	299.93	299.93	300.0
2019-09-16 04:08:00	SPY	ETF	299.98	299.98	299.98	299.98	150.0
2019-09-16 04:11:00	SPY	ETF	299.94	299.94	299.94	299.94	500.0
2019-09-16 04:15:00	SPY	ETF	299.79	299.83	299.79	299.83	601.0
2019-09-16 04:16:00	SPY	ETF	299.88	299.88	299.88	299.88	145.0
2019-09-16 04:18:00	SPY	ETF	299.81	299.81	299.81	299.81	400.0
2019-09-16 04:19:00	SPY	ETF	299.86	299.86	299.86	299.86	300.0
2019-09-16 04:20:00	SPY	ETF	299.81	299.81	299.8	299.81	3050.0
2019-09-16 04:21:00	SPY	ETF	299.81	299.81	299.81	299.81	100.0
2019-09-16 04:23:00	SPY	ETF	299.8	299.8	299.8	299.8	3000.0
2019-09-16 04:24:00	SPY	ETF	299.86	299.86	299.86	299.86	210.0
2019-09-16 04:35:00	SPY	ETF	299.9	299.9	299.9	299.9	305.0
2019-09-16 04:36:00	SPY	ETF	299.9	299.9	299.9	299.9	125.0
2019-09-16 04:44:00	SPY	ETF	299.81	299.81	299.81	299.81	200.0
2019-09-16 04:58:00	SPY	ETF	299.71	299.71	299.71	299.71	1500.0
2019-09-16 04:59:00	SPY	ETF	299.71	299.71	299.7	299.7	4000.0
2019-09-16 05:01:00	SPY	ETF	299.58	299.58	299.58	299.58	1074.0
2019-09-16 05:02:00	SPY	ETF	299.59	299.59	299.3	299.38	4315.0
2019-09-16 05:04:00	SPY	ETF	299.57	299.57	299.57	299.57	1200.0
2019-09-16 05:05:00	SPY	ETF	299.64	299.64	299.64	299.64	1510.0
2019-09-16 05:06:00	SPY	ETF	299.68	299.68	299.63	299.63	1700.0
2019-09-16 05:09:00	SPY	ETF	299.69	299.69	299.69	299.69	800.0
2019-09-16 05:11:00	SPY	ETF	299.6	299.6	299.6	299.6	3000.0
2019-09-16 05:12:00	SPY	ETF	299.59	299.59	299.58	299.58	2600.0
2019-09-16 05:14:00	SPY	ETF	299.63	299.63	299.63	299.63	5000.0
2019-09-16 05:16:00	SPY	ETF	299.64	299.64	299.63	299.63	2800.0
2019-09-16 05:21:00	SPY	ETF	299.6	299.6	299.6	299.6	2600.0
2019-09-16 05:22:00	SPY	ETF	299.6	299.6	299.6	299.6	100.0
2019-09-16 05:28:00	SPY	ETF	299.76	299.76	299.76	299.76	100.0
2019-09-16 05:31:00	SPY	ETF	299.83	299.83	299.83	299.83	100.0
2019-09-16 05:36:00	SPY	ETF	299.56	299.56	299.44	299.45	2626.0
2019-09-16 05:37:00	SPY	ETF	299.45	299.45	299.45	299.45	100.0
2019-09-16 05:38:00	SPY	ETF	299.63	299.63	299.63	299.63	1500.0
2019-09-16 05:46:00	SPY	ETF	299.44	299.44	299.44	299.44	100.0
2019-09-16 05:47:00	SPY	ETF	299.53	299.54	299.53	299.53	2500.0
2019-09-16 05:48:00	SPY	ETF	299.49	299.49	299.49	299.49	105.0
2019-09-16 05:50:00	SPY	ETF	299.6	299.69	299.6	299.69	600.0
2019-09-16 05:51:00	SPY	ETF	299.68	299.68	299.68	299.68	102.0
2019-09-16 05:55:00	SPY	ETF	299.73	299.73	299.73	299.73	220.0
2019-09-16 05:56:00	SPY	ETF	299.66	299.68	299.66	299.67	3240.0
2019-09-16 05:58:00	SPY	ETF	299.62	299.62	299.62	299.62	200.0
2019-09-16 06:01:00	SPY	ETF	299.72	299.72	299.72	299.72	100.0
2019-09-16 06:02:00	SPY	ETF	299.69	299.69	299.69	299.69	160.0
2019-09-16 06:07:00	SPY	ETF	299.71	299.79	299.71	299.79	1100.0
2019-09-16 06:09:00	SPY	ETF	299.86	299.86	299.86	299.86	1000.0

> showing 50 of 166,457 rows — these rows as CSV

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