PREVIEW / etf_1min / 2018-12-26

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-12-26.parquet
  size:    4.6 MB
  rows:    223,571

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
2018-12-26 04:00:00	SPY	ETF	234.05	234.08	234.05	234.08	584.0
2018-12-26 04:02:00	SPY	ETF	233.83	233.83	233.83	233.83	200.0
2018-12-26 04:03:00	SPY	ETF	233.75	234.09	233.75	234.09	1202.0
2018-12-26 04:12:00	SPY	ETF	233.96	233.96	233.96	233.96	242.0
2018-12-26 04:13:00	SPY	ETF	233.98	233.98	233.96	233.96	750.0
2018-12-26 04:15:00	SPY	ETF	233.88	233.88	233.88	233.88	100.0
2018-12-26 04:17:00	SPY	ETF	233.94	233.94	233.94	233.94	200.0
2018-12-26 04:18:00	SPY	ETF	233.88	233.88	233.79	233.79	250.0
2018-12-26 04:19:00	SPY	ETF	233.74	233.74	233.71	233.71	1400.0
2018-12-26 04:25:00	SPY	ETF	233.96	234.0	233.94	234.0	4259.0
2018-12-26 04:26:00	SPY	ETF	234.05	234.08	234.05	234.08	1174.0
2018-12-26 04:28:00	SPY	ETF	234.15	234.15	234.15	234.15	100.0
2018-12-26 04:30:00	SPY	ETF	234.1	234.14	234.1	234.1	974.0
2018-12-26 04:31:00	SPY	ETF	234.06	234.06	234.06	234.06	100.0
2018-12-26 04:32:00	SPY	ETF	234.05	234.05	234.0	234.0	210.0
2018-12-26 04:33:00	SPY	ETF	233.83	233.83	233.83	233.83	250.0
2018-12-26 04:42:00	SPY	ETF	233.97	233.97	233.93	233.96	1050.0
2018-12-26 04:45:00	SPY	ETF	234.0	234.02	234.0	234.02	400.0
2018-12-26 04:46:00	SPY	ETF	233.99	234.0	233.99	234.0	200.0
2018-12-26 04:48:00	SPY	ETF	234.09	234.19	234.08	234.19	1300.0
2018-12-26 04:51:00	SPY	ETF	234.19	234.19	234.19	234.19	100.0
2018-12-26 04:53:00	SPY	ETF	234.3	234.3	234.28	234.28	2000.0
2018-12-26 04:54:00	SPY	ETF	234.34	234.5	234.34	234.5	3700.0
2018-12-26 04:55:00	SPY	ETF	234.5	234.9	234.5	234.9	2180.0
2018-12-26 04:56:00	SPY	ETF	234.9	235.05	234.89	235.05	1915.0
2018-12-26 04:57:00	SPY	ETF	235.0	235.0	234.97	234.97	603.0
2018-12-26 04:58:00	SPY	ETF	234.99	235.1	234.99	235.01	2400.0
2018-12-26 04:59:00	SPY	ETF	235.0	235.0	234.93	234.95	1650.0
2018-12-26 05:00:00	SPY	ETF	234.9	234.9	234.89	234.89	1200.0
2018-12-26 05:03:00	SPY	ETF	234.77	234.8	234.77	234.8	200.0
2018-12-26 05:04:00	SPY	ETF	234.88	235.2	234.88	235.2	4860.0
2018-12-26 05:05:00	SPY	ETF	234.9	234.9	234.89	234.9	2600.0
2018-12-26 05:06:00	SPY	ETF	234.77	234.77	234.77	234.77	107.0
2018-12-26 05:07:00	SPY	ETF	234.67	234.8	234.67	234.8	1100.0
2018-12-26 05:08:00	SPY	ETF	234.81	234.81	234.81	234.81	3500.0
2018-12-26 05:09:00	SPY	ETF	234.76	234.76	234.76	234.76	500.0
2018-12-26 05:10:00	SPY	ETF	234.7	234.92	234.7	234.78	12074.0
2018-12-26 05:11:00	SPY	ETF	234.8	234.8	234.75	234.8	7200.0
2018-12-26 05:12:00	SPY	ETF	234.77	234.77	234.6	234.6	10500.0
2018-12-26 05:13:00	SPY	ETF	234.6	234.64	234.6	234.64	1800.0
2018-12-26 05:14:00	SPY	ETF	234.65	234.65	234.6	234.6	7700.0
2018-12-26 05:15:00	SPY	ETF	234.48	234.48	234.13	234.13	11006.0
2018-12-26 05:16:00	SPY	ETF	234.3	234.45	234.3	234.45	5789.0
2018-12-26 05:17:00	SPY	ETF	234.45	234.47	234.45	234.47	200.0
2018-12-26 05:18:00	SPY	ETF	234.47	234.47	234.39	234.39	620.0
2018-12-26 05:19:00	SPY	ETF	234.39	234.39	234.39	234.39	3137.0
2018-12-26 05:20:00	SPY	ETF	234.3	234.36	234.3	234.35	300.0
2018-12-26 05:21:00	SPY	ETF	234.38	234.38	234.38	234.38	100.0
2018-12-26 05:22:00	SPY	ETF	234.54	234.54	234.54	234.54	201.0
2018-12-26 05:24:00	SPY	ETF	234.46	234.46	234.46	234.46	1010.0

> showing 50 of 223,571 rows — these rows as CSV

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