PREVIEW / etf_1min / 2019-09-03

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-09-03.parquet
  size:    3.2 MB
  rows:    169,711

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-03 04:00:00	SPY	ETF	290.04	290.04	289.91	289.91	4426.0
2019-09-03 04:01:00	SPY	ETF	290.1	290.1	290.1	290.1	686.0
2019-09-03 04:02:00	SPY	ETF	290.21	290.21	290.14	290.14	700.0
2019-09-03 04:03:00	SPY	ETF	290.21	290.21	290.2	290.2	830.0
2019-09-03 04:04:00	SPY	ETF	290.2	290.2	290.2	290.2	100.0
2019-09-03 04:05:00	SPY	ETF	290.18	290.3	290.15	290.3	952.0
2019-09-03 04:06:00	SPY	ETF	290.28	290.28	290.25	290.28	700.0
2019-09-03 04:07:00	SPY	ETF	290.25	290.27	290.25	290.26	2200.0
2019-09-03 04:09:00	SPY	ETF	290.28	290.3	290.28	290.3	731.0
2019-09-03 04:10:00	SPY	ETF	290.35	290.35	290.35	290.35	104.0
2019-09-03 04:13:00	SPY	ETF	290.6	290.6	290.58	290.58	704.0
2019-09-03 04:14:00	SPY	ETF	291.16	291.18	291.1	291.1	1119.0
2019-09-03 04:15:00	SPY	ETF	291.12	291.13	291.12	291.13	700.0
2019-09-03 04:17:00	SPY	ETF	291.0	291.0	290.95	291.0	1500.0
2019-09-03 04:18:00	SPY	ETF	290.94	290.95	290.94	290.95	1000.0
2019-09-03 04:20:00	SPY	ETF	290.92	290.92	290.92	290.92	550.0
2019-09-03 04:21:00	SPY	ETF	290.83	290.83	290.83	290.83	300.0
2019-09-03 04:22:00	SPY	ETF	290.81	290.95	290.75	290.95	1650.0
2019-09-03 04:24:00	SPY	ETF	290.93	290.93	290.93	290.93	300.0
2019-09-03 04:25:00	SPY	ETF	290.89	290.89	290.89	290.89	150.0
2019-09-03 04:26:00	SPY	ETF	290.98	290.98	290.98	290.98	100.0
2019-09-03 04:27:00	SPY	ETF	290.91	290.91	290.91	290.91	150.0
2019-09-03 04:30:00	SPY	ETF	290.71	290.71	290.67	290.67	644.0
2019-09-03 04:32:00	SPY	ETF	290.57	290.57	290.43	290.43	2404.0
2019-09-03 04:33:00	SPY	ETF	290.42	290.42	290.36	290.38	1100.0
2019-09-03 04:34:00	SPY	ETF	290.36	290.36	290.36	290.36	290.0
2019-09-03 04:35:00	SPY	ETF	290.43	290.43	290.43	290.43	126.0
2019-09-03 04:37:00	SPY	ETF	290.61	290.62	290.6	290.62	1200.0
2019-09-03 04:40:00	SPY	ETF	290.61	290.61	290.61	290.61	100.0
2019-09-03 04:45:00	SPY	ETF	290.33	290.33	290.3	290.3	324.0
2019-09-03 04:46:00	SPY	ETF	290.38	290.38	290.38	290.38	1000.0
2019-09-03 04:47:00	SPY	ETF	290.41	290.41	290.41	290.41	300.0
2019-09-03 04:49:00	SPY	ETF	290.46	290.46	290.46	290.46	130.0
2019-09-03 04:51:00	SPY	ETF	290.43	290.43	290.43	290.43	4000.0
2019-09-03 04:54:00	SPY	ETF	290.59	290.61	290.59	290.61	1100.0
2019-09-03 04:55:00	SPY	ETF	290.58	290.59	290.58	290.59	1000.0
2019-09-03 04:58:00	SPY	ETF	290.81	290.85	290.81	290.85	2413.0
2019-09-03 05:02:00	SPY	ETF	290.79	290.81	290.79	290.81	1250.0
2019-09-03 05:03:00	SPY	ETF	290.86	290.86	290.79	290.81	1200.0
2019-09-03 05:04:00	SPY	ETF	290.81	290.89	290.81	290.89	1600.0
2019-09-03 05:05:00	SPY	ETF	290.94	290.94	290.89	290.89	1039.0
2019-09-03 05:06:00	SPY	ETF	290.89	290.9	290.85	290.9	2550.0
2019-09-03 05:07:00	SPY	ETF	290.93	291.04	290.93	290.99	7450.0
2019-09-03 05:08:00	SPY	ETF	290.99	290.99	290.9	290.91	3475.0
2019-09-03 05:09:00	SPY	ETF	290.88	290.88	290.84	290.86	6100.0
2019-09-03 05:10:00	SPY	ETF	290.81	290.86	290.81	290.83	4550.0
2019-09-03 05:11:00	SPY	ETF	290.83	290.84	290.83	290.84	1600.0
2019-09-03 05:12:00	SPY	ETF	290.86	290.86	290.86	290.86	500.0
2019-09-03 05:13:00	SPY	ETF	290.86	290.98	290.86	290.98	1951.0
2019-09-03 05:14:00	SPY	ETF	290.9	290.9	290.9	290.9	250.0

> showing 50 of 169,711 rows — these rows as CSV

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