PREVIEW / etf_1min / 2018-12-31

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-12-31.parquet
  size:    4.3 MB
  rows:    218,434

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-31 04:00:00	SPY	ETF	249.62	249.62	249.62	249.62	13440.0
2018-12-31 04:01:00	SPY	ETF	249.6	249.6	249.6	249.6	116.0
2018-12-31 04:02:00	SPY	ETF	249.63	249.65	249.63	249.65	700.0
2018-12-31 04:03:00	SPY	ETF	249.72	249.72	249.7	249.7	357.0
2018-12-31 04:05:00	SPY	ETF	249.77	249.77	249.76	249.76	338.0
2018-12-31 04:06:00	SPY	ETF	249.74	249.74	249.65	249.71	1001.0
2018-12-31 04:07:00	SPY	ETF	249.71	249.71	249.7	249.7	669.0
2018-12-31 04:09:00	SPY	ETF	249.67	249.67	249.67	249.67	169.0
2018-12-31 04:10:00	SPY	ETF	249.64	249.64	249.64	249.64	200.0
2018-12-31 04:11:00	SPY	ETF	249.63	249.63	249.63	249.63	200.0
2018-12-31 04:12:00	SPY	ETF	249.6	249.6	249.57	249.57	1276.0
2018-12-31 04:13:00	SPY	ETF	249.59	249.59	249.59	249.59	379.0
2018-12-31 04:16:00	SPY	ETF	249.6	249.6	249.6	249.6	115.0
2018-12-31 04:18:00	SPY	ETF	249.64	249.64	249.64	249.64	171.0
2018-12-31 04:20:00	SPY	ETF	249.62	249.62	249.62	249.62	200.0
2018-12-31 04:25:00	SPY	ETF	249.62	249.62	249.62	249.62	168.0
2018-12-31 04:28:00	SPY	ETF	249.76	249.76	249.76	249.76	271.0
2018-12-31 04:29:00	SPY	ETF	249.73	249.73	249.68	249.68	338.0
2018-12-31 04:30:00	SPY	ETF	249.65	249.65	249.65	249.65	338.0
2018-12-31 04:33:00	SPY	ETF	249.72	249.74	249.72	249.74	383.0
2018-12-31 04:35:00	SPY	ETF	249.74	249.74	249.74	249.74	300.0
2018-12-31 04:36:00	SPY	ETF	249.74	249.78	249.74	249.78	1038.0
2018-12-31 04:37:00	SPY	ETF	249.79	249.85	249.79	249.79	1150.0
2018-12-31 04:39:00	SPY	ETF	249.74	249.74	249.7	249.7	766.0
2018-12-31 04:42:00	SPY	ETF	249.78	249.84	249.78	249.84	1088.0
2018-12-31 04:44:00	SPY	ETF	249.81	249.81	249.81	249.81	300.0
2018-12-31 04:45:00	SPY	ETF	249.78	249.78	249.78	249.78	469.0
2018-12-31 04:48:00	SPY	ETF	249.84	249.9	249.84	249.9	1173.0
2018-12-31 04:51:00	SPY	ETF	249.82	249.84	249.79	249.84	600.0
2018-12-31 04:52:00	SPY	ETF	249.85	249.85	249.85	249.85	1000.0
2018-12-31 04:54:00	SPY	ETF	249.79	249.79	249.79	249.79	479.0
2018-12-31 04:57:00	SPY	ETF	249.82	249.85	249.82	249.85	1638.0
2018-12-31 04:58:00	SPY	ETF	249.85	249.85	249.85	249.85	16020.0
2018-12-31 05:00:00	SPY	ETF	249.86	249.9	249.86	249.9	1276.0
2018-12-31 05:01:00	SPY	ETF	249.95	249.95	249.89	249.9	16769.0
2018-12-31 05:02:00	SPY	ETF	249.89	249.89	249.89	249.89	300.0
2018-12-31 05:08:00	SPY	ETF	249.9	249.9	249.9	249.9	1000.0
2018-12-31 05:14:00	SPY	ETF	249.86	249.86	249.82	249.82	369.0
2018-12-31 05:15:00	SPY	ETF	249.8	249.82	249.8	249.82	900.0
2018-12-31 05:16:00	SPY	ETF	249.82	249.84	249.82	249.84	700.0
2018-12-31 05:17:00	SPY	ETF	249.83	249.83	249.83	249.83	100.0
2018-12-31 05:19:00	SPY	ETF	249.82	249.82	249.82	249.82	100.0
2018-12-31 05:22:00	SPY	ETF	249.83	249.83	249.83	249.83	100.0
2018-12-31 05:25:00	SPY	ETF	249.82	249.82	249.82	249.82	200.0
2018-12-31 05:26:00	SPY	ETF	249.8	249.8	249.76	249.76	545.0
2018-12-31 05:27:00	SPY	ETF	249.76	249.76	249.74	249.75	1107.0
2018-12-31 05:28:00	SPY	ETF	249.74	249.74	249.74	249.74	469.0
2018-12-31 05:29:00	SPY	ETF	249.7	249.7	249.68	249.68	573.0
2018-12-31 05:30:00	SPY	ETF	249.66	249.66	249.66	249.66	238.0
2018-12-31 05:32:00	SPY	ETF	249.64	249.64	249.62	249.62	809.0

> showing 50 of 218,434 rows — these rows as CSV

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