PREVIEW / stock_1min / 2018-08-22

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-08-22.parquet
  size:    14.0 MB
  rows:    1,003,075
  symbols: 2,332

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-08-22 04:00:00	AAPL	Stock	53.5	53.5	53.5	53.5	428.0
2018-08-22 04:06:00	AAPL	Stock	53.525	53.525	53.525	53.525	400.0
2018-08-22 04:07:00	AAPL	Stock	53.525	53.525	53.525	53.525	400.0
2018-08-22 04:21:00	AAPL	Stock	53.6	53.6	53.6	53.6	600.0
2018-08-22 04:32:00	AAPL	Stock	53.55	53.55	53.55	53.55	800.0
2018-08-22 04:42:00	AAPL	Stock	53.59	53.59	53.59	53.59	600.0
2018-08-22 04:53:00	AAPL	Stock	53.6	53.6	53.6	53.6	3100.0
2018-08-22 06:05:00	AAPL	Stock	53.6125	53.62	53.6125	53.62	4028.0
2018-08-22 06:06:00	AAPL	Stock	53.62	53.62	53.5975	53.5975	3200.0
2018-08-22 06:13:00	AAPL	Stock	53.62	53.6225	53.62	53.6225	17848.0
2018-08-22 06:17:00	AAPL	Stock	53.6625	53.67	53.6575	53.67	4000.0
2018-08-22 06:20:00	AAPL	Stock	53.6675	53.6725	53.6675	53.6725	5176.0
2018-08-22 06:21:00	AAPL	Stock	53.6725	53.6725	53.6725	53.6725	400.0
2018-08-22 06:22:00	AAPL	Stock	53.67	53.6725	53.67	53.6725	6724.0
2018-08-22 06:23:00	AAPL	Stock	53.6825	53.6825	53.6825	53.6825	400.0
2018-08-22 06:50:00	AAPL	Stock	53.6575	53.6575	53.6575	53.6575	800.0
2018-08-22 06:51:00	AAPL	Stock	53.7	53.7	53.7	53.7	400.0
2018-08-22 07:00:00	AAPL	Stock	53.7	53.7	53.625	53.7	7892.0
2018-08-22 07:01:00	AAPL	Stock	53.7	53.7	53.695	53.695	1600.0
2018-08-22 07:02:00	AAPL	Stock	53.695	53.695	53.6875	53.6925	1800.0
2018-08-22 07:03:00	AAPL	Stock	53.7	53.7	53.6875	53.6875	1632.0
2018-08-22 07:04:00	AAPL	Stock	53.7125	53.7375	53.66	53.7375	46904.0
2018-08-22 07:05:00	AAPL	Stock	53.72	53.72	53.72	53.72	1224.0
2018-08-22 07:06:00	AAPL	Stock	53.7125	53.7125	53.7125	53.7125	400.0
2018-08-22 07:07:00	AAPL	Stock	53.71	53.71	53.71	53.71	1220.0
2018-08-22 07:08:00	AAPL	Stock	53.7	53.7	53.7	53.7	400.0
2018-08-22 07:09:00	AAPL	Stock	53.6875	53.695	53.6875	53.695	1600.0
2018-08-22 07:10:00	AAPL	Stock	53.6825	53.685	53.6825	53.6825	6392.0
2018-08-22 07:11:00	AAPL	Stock	53.69	53.6925	53.6825	53.6825	2000.0
2018-08-22 07:12:00	AAPL	Stock	53.6925	53.6925	53.6875	53.6875	1792.0
2018-08-22 07:14:00	AAPL	Stock	53.675	53.685	53.675	53.685	11768.0
2018-08-22 07:15:00	AAPL	Stock	53.665	53.665	53.65	53.65	5340.0
2018-08-22 07:18:00	AAPL	Stock	53.6575	53.6575	53.655	53.655	6400.0
2018-08-22 07:20:00	AAPL	Stock	53.655	53.655	53.655	53.655	400.0
2018-08-22 07:29:00	AAPL	Stock	53.67	53.67	53.67	53.67	1200.0
2018-08-22 07:31:00	AAPL	Stock	53.67	53.67	53.67	53.67	400.0
2018-08-22 07:32:00	AAPL	Stock	53.6625	53.6675	53.6625	53.6675	4072.0
2018-08-22 07:33:00	AAPL	Stock	53.67	53.67	53.67	53.67	1232.0
2018-08-22 07:35:00	AAPL	Stock	53.6675	53.6675	53.6675	53.6675	400.0
2018-08-22 07:36:00	AAPL	Stock	53.6675	53.6675	53.6675	53.6675	1000.0
2018-08-22 07:37:00	AAPL	Stock	53.6675	53.6675	53.6675	53.6675	1660.0
2018-08-22 07:38:00	AAPL	Stock	53.6675	53.6675	53.6675	53.6675	800.0
2018-08-22 07:40:00	AAPL	Stock	53.65	53.65	53.65	53.65	1600.0
2018-08-22 07:41:00	AAPL	Stock	53.65	53.65	53.645	53.645	800.0
2018-08-22 07:42:00	AAPL	Stock	53.66	53.6675	53.66	53.6675	860.0
2018-08-22 07:48:00	AAPL	Stock	53.63	53.63	53.625	53.625	2400.0
2018-08-22 07:49:00	AAPL	Stock	53.625	53.625	53.625	53.625	800.0
2018-08-22 07:50:00	AAPL	Stock	53.625	53.625	53.625	53.625	416.0
2018-08-22 07:52:00	AAPL	Stock	53.605	53.605	53.605	53.605	1828.0
2018-08-22 07:53:00	AAPL	Stock	53.6225	53.6225	53.6225	53.6225	436.0

> showing 50 of 1,003,075 rows — these rows as CSV

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