PREVIEW / stock_1min / 2018-04-30

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-04-30.parquet
  size:    14.4 MB
  rows:    1,043,996
  symbols: 2,387

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-04-30 04:00:00	AAPL	Stock	40.675	40.675	40.675	40.675	2128.0
2018-04-30 04:01:00	AAPL	Stock	40.675	40.675	40.675	40.675	3220.0
2018-04-30 04:02:00	AAPL	Stock	40.75	40.75	40.75	40.75	3900.0
2018-04-30 04:15:00	AAPL	Stock	40.7375	40.7375	40.7375	40.7375	400.0
2018-04-30 04:22:00	AAPL	Stock	40.74	40.74	40.74	40.74	400.0
2018-04-30 04:23:00	AAPL	Stock	40.7275	40.7275	40.7275	40.7275	1036.0
2018-04-30 04:24:00	AAPL	Stock	40.7275	40.7275	40.7275	40.7275	800.0
2018-04-30 04:30:00	AAPL	Stock	40.775	40.775	40.775	40.775	400.0
2018-04-30 04:34:00	AAPL	Stock	40.81	40.8125	40.81	40.8125	1800.0
2018-04-30 04:43:00	AAPL	Stock	40.7725	40.7725	40.7725	40.7725	1092.0
2018-04-30 05:14:00	AAPL	Stock	40.775	40.7875	40.775	40.7875	2512.0
2018-04-30 05:23:00	AAPL	Stock	40.775	40.775	40.775	40.775	2172.0
2018-04-30 05:24:00	AAPL	Stock	40.775	40.775	40.7725	40.7725	1148.0
2018-04-30 05:29:00	AAPL	Stock	40.75	40.75	40.75	40.75	5296.0
2018-04-30 05:37:00	AAPL	Stock	40.7875	40.7875	40.7875	40.7875	1200.0
2018-04-30 06:36:00	AAPL	Stock	40.815	40.815	40.815	40.815	400.0
2018-04-30 06:42:00	AAPL	Stock	40.8125	40.8125	40.8125	40.8125	800.0
2018-04-30 06:56:00	AAPL	Stock	40.8	40.8	40.8	40.8	800.0
2018-04-30 07:00:00	AAPL	Stock	40.76	40.825	40.76	40.825	7496.0
2018-04-30 07:01:00	AAPL	Stock	40.82	40.82	40.82	40.82	800.0
2018-04-30 07:03:00	AAPL	Stock	40.78	40.78	40.78	40.78	400.0
2018-04-30 07:04:00	AAPL	Stock	40.775	40.7875	40.775	40.7875	800.0
2018-04-30 07:05:00	AAPL	Stock	40.8	40.8125	40.8	40.8	5112.0
2018-04-30 07:06:00	AAPL	Stock	40.7875	40.7875	40.7875	40.7875	400.0
2018-04-30 07:07:00	AAPL	Stock	40.79	40.79	40.7875	40.7875	1000.0
2018-04-30 07:08:00	AAPL	Stock	40.8075	40.8075	40.8075	40.8075	6632.0
2018-04-30 07:09:00	AAPL	Stock	40.785	40.8075	40.7625	40.8075	9200.0
2018-04-30 07:10:00	AAPL	Stock	40.775	40.7975	40.775	40.7975	2044.0
2018-04-30 07:11:00	AAPL	Stock	40.765	40.765	40.75	40.75	5200.0
2018-04-30 07:15:00	AAPL	Stock	40.7525	40.7525	40.75	40.75	2000.0
2018-04-30 07:16:00	AAPL	Stock	40.75	40.75	40.75	40.75	400.0
2018-04-30 07:17:00	AAPL	Stock	40.75	40.75	40.75	40.75	1600.0
2018-04-30 07:18:00	AAPL	Stock	40.75	40.75	40.75	40.75	948.0
2018-04-30 07:19:00	AAPL	Stock	40.75	40.75	40.75	40.75	400.0
2018-04-30 07:20:00	AAPL	Stock	40.7375	40.7375	40.7375	40.7375	2856.0
2018-04-30 07:21:00	AAPL	Stock	40.75	40.775	40.75	40.775	4180.0
2018-04-30 07:22:00	AAPL	Stock	40.7675	40.775	40.7675	40.7725	6000.0
2018-04-30 07:23:00	AAPL	Stock	40.7725	40.775	40.7725	40.775	1200.0
2018-04-30 07:24:00	AAPL	Stock	40.795	40.795	40.79	40.795	2400.0
2018-04-30 07:26:00	AAPL	Stock	40.765	40.765	40.765	40.765	400.0
2018-04-30 07:27:00	AAPL	Stock	40.75	40.75	40.75	40.75	1092.0
2018-04-30 07:28:00	AAPL	Stock	40.7525	40.7525	40.75	40.75	4000.0
2018-04-30 07:29:00	AAPL	Stock	40.75	40.75	40.75	40.75	492.0
2018-04-30 07:30:00	AAPL	Stock	40.73	40.73	40.73	40.73	400.0
2018-04-30 07:31:00	AAPL	Stock	40.75	40.75	40.75	40.75	2056.0
2018-04-30 07:32:00	AAPL	Stock	40.75	40.75	40.75	40.75	704.0
2018-04-30 07:33:00	AAPL	Stock	40.75	40.75	40.75	40.75	400.0
2018-04-30 07:35:00	AAPL	Stock	40.75	40.75	40.75	40.75	400.0
2018-04-30 07:36:00	AAPL	Stock	40.7625	40.785	40.7625	40.785	4168.0
2018-04-30 07:37:00	AAPL	Stock	40.785	40.7875	40.785	40.7875	6000.0

> showing 50 of 1,043,996 rows — these rows as CSV

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