PREVIEW / etf_1min / 2019-07-16

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-07-16.parquet
  size:    3.0 MB
  rows:    160,083

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-07-16 04:01:00	SPY	ETF	300.82	300.82	300.82	300.82	350.0
2019-07-16 04:49:00	SPY	ETF	300.82	300.82	300.82	300.82	189.0
2019-07-16 04:58:00	SPY	ETF	300.9	300.9	300.9	300.9	150.0
2019-07-16 05:03:00	SPY	ETF	300.94	300.94	300.94	300.94	114.0
2019-07-16 05:06:00	SPY	ETF	300.97	300.97	300.97	300.97	400.0
2019-07-16 05:11:00	SPY	ETF	300.94	300.94	300.94	300.94	200.0
2019-07-16 05:16:00	SPY	ETF	300.82	300.82	300.82	300.82	700.0
2019-07-16 05:18:00	SPY	ETF	300.79	300.79	300.79	300.79	300.0
2019-07-16 05:29:00	SPY	ETF	300.74	300.74	300.74	300.74	300.0
2019-07-16 05:36:00	SPY	ETF	300.63	300.63	300.63	300.63	200.0
2019-07-16 05:41:00	SPY	ETF	300.65	300.65	300.65	300.65	270.0
2019-07-16 05:42:00	SPY	ETF	300.61	300.61	300.61	300.61	500.0
2019-07-16 05:43:00	SPY	ETF	300.64	300.64	300.64	300.64	300.0
2019-07-16 06:08:00	SPY	ETF	300.84	300.84	300.84	300.84	332.0
2019-07-16 06:20:00	SPY	ETF	300.82	300.82	300.82	300.82	820.0
2019-07-16 06:22:00	SPY	ETF	300.84	300.84	300.84	300.84	609.0
2019-07-16 06:23:00	SPY	ETF	300.82	300.82	300.82	300.82	1029.0
2019-07-16 06:28:00	SPY	ETF	300.82	300.82	300.82	300.82	169.0
2019-07-16 06:29:00	SPY	ETF	300.84	300.84	300.84	300.84	169.0
2019-07-16 06:30:00	SPY	ETF	300.85	300.85	300.85	300.85	169.0
2019-07-16 06:34:00	SPY	ETF	300.83	300.83	300.83	300.83	5000.0
2019-07-16 06:40:00	SPY	ETF	300.8	300.8	300.8	300.8	357.0
2019-07-16 06:46:00	SPY	ETF	300.79	300.86	300.79	300.8	4489.0
2019-07-16 06:49:00	SPY	ETF	300.75	300.75	300.67	300.67	2920.0
2019-07-16 06:50:00	SPY	ETF	300.72	300.72	300.72	300.72	100.0
2019-07-16 06:53:00	SPY	ETF	300.66	300.66	300.6	300.6	4348.0
2019-07-16 06:54:00	SPY	ETF	300.64	300.64	300.64	300.64	500.0
2019-07-16 06:55:00	SPY	ETF	300.62	300.62	300.62	300.62	248.0
2019-07-16 06:56:00	SPY	ETF	300.62	300.62	300.62	300.62	2000.0
2019-07-16 06:57:00	SPY	ETF	300.67	300.67	300.67	300.67	200.0
2019-07-16 06:58:00	SPY	ETF	300.65	300.65	300.63	300.63	338.0
2019-07-16 06:59:00	SPY	ETF	300.65	300.65	300.65	300.65	1070.0
2019-07-16 07:02:00	SPY	ETF	300.7	300.7	300.7	300.7	5000.0
2019-07-16 07:03:00	SPY	ETF	300.72	300.72	300.72	300.72	450.0
2019-07-16 07:04:00	SPY	ETF	300.69	300.69	300.69	300.69	175.0
2019-07-16 07:07:00	SPY	ETF	300.74	300.74	300.74	300.74	300.0
2019-07-16 07:09:00	SPY	ETF	300.74	300.74	300.74	300.74	213.0
2019-07-16 07:11:00	SPY	ETF	300.71	300.71	300.7	300.71	550.0
2019-07-16 07:13:00	SPY	ETF	300.72	300.72	300.72	300.72	400.0
2019-07-16 07:14:00	SPY	ETF	300.74	300.74	300.74	300.74	650.0
2019-07-16 07:15:00	SPY	ETF	300.76	300.76	300.71	300.71	650.0
2019-07-16 07:17:00	SPY	ETF	300.76	300.76	300.76	300.76	200.0
2019-07-16 07:22:00	SPY	ETF	300.76	300.76	300.76	300.76	10329.0
2019-07-16 07:23:00	SPY	ETF	300.76	300.76	300.76	300.76	9171.0
2019-07-16 07:25:00	SPY	ETF	300.75	300.84	300.75	300.79	16927.0
2019-07-16 07:26:00	SPY	ETF	300.89	300.89	300.81	300.81	469.0
2019-07-16 07:27:00	SPY	ETF	300.84	300.84	300.84	300.84	300.0
2019-07-16 07:30:00	SPY	ETF	300.83	300.9	300.83	300.9	17500.0
2019-07-16 07:31:00	SPY	ETF	300.9	300.91	300.83	300.86	16900.0
2019-07-16 07:33:00	SPY	ETF	300.87	300.87	300.87	300.87	366.0

> showing 50 of 160,083 rows — these rows as CSV

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