PREVIEW / stock_1min / 2018-07-23

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-07-23.parquet
  size:    14.2 MB
  rows:    1,025,184
  symbols: 2,328

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-07-23 04:06:00	AAPL	Stock	47.7125	47.7125	47.7125	47.7125	400.0
2018-07-23 04:30:00	AAPL	Stock	47.675	47.675	47.675	47.675	1228.0
2018-07-23 07:00:00	AAPL	Stock	47.6975	47.6975	47.6975	47.6975	1760.0
2018-07-23 07:01:00	AAPL	Stock	47.675	47.675	47.675	47.675	400.0
2018-07-23 07:05:00	AAPL	Stock	47.6875	47.6875	47.6875	47.6875	400.0
2018-07-23 07:06:00	AAPL	Stock	47.7	47.71	47.7	47.7	7064.0
2018-07-23 07:07:00	AAPL	Stock	47.715	47.715	47.715	47.715	2000.0
2018-07-23 07:08:00	AAPL	Stock	47.7	47.7	47.6875	47.69	3200.0
2018-07-23 07:09:00	AAPL	Stock	47.675	47.675	47.675	47.675	6600.0
2018-07-23 07:10:00	AAPL	Stock	47.675	47.675	47.675	47.675	3128.0
2018-07-23 07:11:00	AAPL	Stock	47.65	47.65	47.65	47.65	3768.0
2018-07-23 07:13:00	AAPL	Stock	47.65	47.675	47.65	47.675	1600.0
2018-07-23 07:14:00	AAPL	Stock	47.675	47.675	47.675	47.675	400.0
2018-07-23 07:15:00	AAPL	Stock	47.6875	47.6875	47.6875	47.6875	800.0
2018-07-23 07:16:00	AAPL	Stock	47.6875	47.6875	47.6875	47.6875	1200.0
2018-07-23 07:17:00	AAPL	Stock	47.6575	47.66	47.6575	47.66	3200.0
2018-07-23 07:18:00	AAPL	Stock	47.675	47.675	47.66	47.66	800.0
2018-07-23 07:19:00	AAPL	Stock	47.675	47.675	47.675	47.675	400.0
2018-07-23 07:20:00	AAPL	Stock	47.675	47.675	47.67	47.675	2000.0
2018-07-23 07:21:00	AAPL	Stock	47.675	47.675	47.675	47.675	1600.0
2018-07-23 07:23:00	AAPL	Stock	47.65	47.65	47.65	47.65	400.0
2018-07-23 07:26:00	AAPL	Stock	47.6725	47.6875	47.6725	47.6875	6072.0
2018-07-23 07:27:00	AAPL	Stock	47.6875	47.6875	47.6875	47.6875	400.0
2018-07-23 07:29:00	AAPL	Stock	47.6875	47.6875	47.6875	47.6875	6452.0
2018-07-23 07:30:00	AAPL	Stock	47.6875	47.7025	47.6875	47.7025	2280.0
2018-07-23 07:31:00	AAPL	Stock	47.7075	47.7075	47.7075	47.7075	7780.0
2018-07-23 07:34:00	AAPL	Stock	47.7125	47.715	47.6625	47.6775	9348.0
2018-07-23 07:35:00	AAPL	Stock	47.725	47.725	47.725	47.725	400.0
2018-07-23 07:36:00	AAPL	Stock	47.7125	47.7375	47.7125	47.7375	3420.0
2018-07-23 07:41:00	AAPL	Stock	47.7025	47.7025	47.7	47.7	1832.0
2018-07-23 07:48:00	AAPL	Stock	47.705	47.705	47.705	47.705	1200.0
2018-07-23 07:51:00	AAPL	Stock	47.7025	47.7325	47.7	47.7325	3668.0
2018-07-23 07:58:00	AAPL	Stock	47.75	47.75	47.7375	47.7375	3912.0
2018-07-23 07:59:00	AAPL	Stock	47.745	47.75	47.745	47.75	9880.0
2018-07-23 08:00:00	AAPL	Stock	47.6575	47.965	47.6575	47.965	38264.0
2018-07-23 08:07:00	AAPL	Stock	47.79	47.79	47.79	47.79	400.0
2018-07-23 08:10:00	AAPL	Stock	47.775	47.775	47.775	47.775	5600.0
2018-07-23 08:11:00	AAPL	Stock	47.755	47.775	47.755	47.7725	6304.0
2018-07-23 08:12:00	AAPL	Stock	47.7725	47.7725	47.7725	47.7725	2992.0
2018-07-23 08:15:00	AAPL	Stock	47.745	47.745	47.745	47.745	400.0
2018-07-23 08:16:00	AAPL	Stock	47.7375	47.7375	47.7375	47.7375	416.0
2018-07-23 08:17:00	AAPL	Stock	47.76	47.76	47.76	47.76	2000.0
2018-07-23 08:19:00	AAPL	Stock	47.73	47.73	47.73	47.73	3748.0
2018-07-23 08:21:00	AAPL	Stock	47.7325	47.7325	47.7325	47.7325	800.0
2018-07-23 08:22:00	AAPL	Stock	47.755	47.755	47.755	47.755	800.0
2018-07-23 08:24:00	AAPL	Stock	47.75	47.75	47.735	47.75	1600.0
2018-07-23 08:25:00	AAPL	Stock	47.775	47.785	47.775	47.785	8000.0
2018-07-23 08:27:00	AAPL	Stock	47.785	47.785	47.785	47.785	3296.0
2018-07-23 08:29:00	AAPL	Stock	47.7875	47.7875	47.7875	47.7875	400.0
2018-07-23 08:34:00	AAPL	Stock	47.7575	47.7575	47.7575	47.7575	400.0

> showing 50 of 1,025,184 rows — these rows as CSV

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