PREVIEW / etf_1min / 2019-01-14

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-01-14.parquet
  size:    3.1 MB
  rows:    166,906

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-01-14 04:00:00	SPY	ETF	257.04	257.04	257.0	257.0	716.0
2019-01-14 04:01:00	SPY	ETF	256.95	256.95	256.84	256.84	1107.0
2019-01-14 04:03:00	SPY	ETF	256.91	256.93	256.86	256.93	1200.0
2019-01-14 04:04:00	SPY	ETF	256.93	256.93	256.79	256.88	3441.0
2019-01-14 04:05:00	SPY	ETF	256.83	256.87	256.83	256.87	300.0
2019-01-14 04:06:00	SPY	ETF	256.86	256.86	256.8	256.8	2529.0
2019-01-14 04:07:00	SPY	ETF	256.85	256.88	256.85	256.88	900.0
2019-01-14 04:08:00	SPY	ETF	256.87	256.93	256.87	256.93	300.0
2019-01-14 04:09:00	SPY	ETF	256.92	256.93	256.92	256.93	1908.0
2019-01-14 04:12:00	SPY	ETF	256.95	257.0	256.95	256.97	749.0
2019-01-14 04:13:00	SPY	ETF	257.0	257.0	256.97	256.97	1000.0
2019-01-14 04:15:00	SPY	ETF	256.86	256.91	256.86	256.91	469.0
2019-01-14 04:18:00	SPY	ETF	257.02	257.06	257.02	257.04	550.0
2019-01-14 04:19:00	SPY	ETF	257.01	257.03	257.01	257.03	1300.0
2019-01-14 04:20:00	SPY	ETF	256.98	256.98	256.98	256.98	1200.0
2019-01-14 04:21:00	SPY	ETF	256.98	256.98	256.98	256.98	1000.0
2019-01-14 04:23:00	SPY	ETF	257.06	257.06	257.06	257.06	400.0
2019-01-14 04:24:00	SPY	ETF	257.07	257.07	257.07	257.07	200.0
2019-01-14 04:25:00	SPY	ETF	257.01	257.01	257.01	257.01	100.0
2019-01-14 04:28:00	SPY	ETF	257.09	257.09	257.09	257.09	100.0
2019-01-14 04:30:00	SPY	ETF	257.06	257.06	257.01	257.01	335.0
2019-01-14 04:31:00	SPY	ETF	256.99	257.0	256.99	257.0	496.0
2019-01-14 04:32:00	SPY	ETF	256.96	256.96	256.96	256.96	286.0
2019-01-14 04:34:00	SPY	ETF	256.92	256.92	256.9	256.9	610.0
2019-01-14 04:37:00	SPY	ETF	256.87	256.87	256.8	256.83	2094.0
2019-01-14 04:38:00	SPY	ETF	256.81	256.81	256.79	256.79	1000.0
2019-01-14 04:39:00	SPY	ETF	256.78	256.78	256.72	256.73	3169.0
2019-01-14 04:40:00	SPY	ETF	256.7	256.7	256.7	256.7	1635.0
2019-01-14 04:42:00	SPY	ETF	256.76	256.76	256.76	256.76	200.0
2019-01-14 04:44:00	SPY	ETF	256.75	256.75	256.7	256.7	1150.0
2019-01-14 04:47:00	SPY	ETF	256.79	256.79	256.79	256.79	100.0
2019-01-14 04:48:00	SPY	ETF	256.77	256.77	256.71	256.71	1082.0
2019-01-14 04:49:00	SPY	ETF	256.74	256.74	256.74	256.74	1400.0
2019-01-14 04:53:00	SPY	ETF	256.69	256.69	256.69	256.69	351.0
2019-01-14 04:54:00	SPY	ETF	256.72	256.72	256.68	256.68	614.0
2019-01-14 04:55:00	SPY	ETF	256.74	256.74	256.74	256.74	220.0
2019-01-14 04:56:00	SPY	ETF	256.69	256.69	256.69	256.69	500.0
2019-01-14 04:57:00	SPY	ETF	256.65	256.65	256.65	256.65	151.0
2019-01-14 04:58:00	SPY	ETF	256.64	256.64	256.64	256.64	600.0
2019-01-14 04:59:00	SPY	ETF	256.6	256.67	256.6	256.67	1250.0
2019-01-14 05:01:00	SPY	ETF	256.59	256.59	256.58	256.58	660.0
2019-01-14 05:02:00	SPY	ETF	256.63	256.66	256.63	256.66	400.0
2019-01-14 05:04:00	SPY	ETF	256.66	256.66	256.66	256.66	100.0
2019-01-14 05:06:00	SPY	ETF	256.67	256.67	256.67	256.67	525.0
2019-01-14 05:10:00	SPY	ETF	256.59	256.59	256.59	256.59	200.0
2019-01-14 05:11:00	SPY	ETF	256.56	256.56	256.5	256.5	2165.0
2019-01-14 05:16:00	SPY	ETF	256.43	256.43	256.43	256.43	701.0
2019-01-14 05:17:00	SPY	ETF	256.35	256.35	256.29	256.29	1825.0
2019-01-14 05:18:00	SPY	ETF	256.33	256.33	256.23	256.23	2550.0
2019-01-14 05:19:00	SPY	ETF	256.21	256.21	256.11	256.11	553.0

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

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