PREVIEW / stock_1min / 2018-06-08

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-06-08.parquet
  size:    14.9 MB
  rows:    1,073,435
  symbols: 2,345

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-06-08 04:00:00	AAPL	Stock	47.9375	47.9375	47.5	47.5	26988.0
2018-06-08 04:01:00	AAPL	Stock	47.4975	47.4975	47.415	47.415	2400.0
2018-06-08 04:02:00	AAPL	Stock	47.375	47.375	47.275	47.275	9604.0
2018-06-08 04:03:00	AAPL	Stock	47.3	47.3	47.3	47.3	1600.0
2018-06-08 04:04:00	AAPL	Stock	47.3075	47.3075	47.26	47.2625	3112.0
2018-06-08 04:05:00	AAPL	Stock	47.25	47.25	47.25	47.25	800.0
2018-06-08 04:06:00	AAPL	Stock	47.2	47.2	47.175	47.175	4764.0
2018-06-08 04:07:00	AAPL	Stock	47.175	47.175	47.175	47.175	1200.0
2018-06-08 04:09:00	AAPL	Stock	47.1325	47.1325	47.1	47.1	4000.0
2018-06-08 04:10:00	AAPL	Stock	47.05	47.1125	47.0475	47.1125	4756.0
2018-06-08 04:11:00	AAPL	Stock	47.165	47.165	47.165	47.165	800.0
2018-06-08 04:12:00	AAPL	Stock	47.1275	47.1275	47.1275	47.1275	400.0
2018-06-08 04:13:00	AAPL	Stock	47.15	47.15	47.09	47.09	4760.0
2018-06-08 04:14:00	AAPL	Stock	47.175	47.25	47.175	47.25	3324.0
2018-06-08 04:15:00	AAPL	Stock	47.2175	47.2175	47.1325	47.1325	13828.0
2018-06-08 04:16:00	AAPL	Stock	47.175	47.25	47.175	47.25	3032.0
2018-06-08 04:17:00	AAPL	Stock	47.3375	47.375	47.3375	47.375	6192.0
2018-06-08 04:19:00	AAPL	Stock	47.35	47.35	47.25	47.3	13596.0
2018-06-08 04:22:00	AAPL	Stock	47.4	47.4	47.4	47.4	400.0
2018-06-08 04:23:00	AAPL	Stock	47.345	47.345	47.33	47.345	2700.0
2018-06-08 04:29:00	AAPL	Stock	47.375	47.375	47.3625	47.3625	1788.0
2018-06-08 04:32:00	AAPL	Stock	47.35	47.35	47.35	47.35	2668.0
2018-06-08 04:33:00	AAPL	Stock	47.35	47.35	47.35	47.35	1120.0
2018-06-08 04:35:00	AAPL	Stock	47.35	47.35	47.35	47.35	12400.0
2018-06-08 04:36:00	AAPL	Stock	47.3025	47.355	47.3025	47.355	6200.0
2018-06-08 04:41:00	AAPL	Stock	47.38	47.38	47.38	47.38	400.0
2018-06-08 04:42:00	AAPL	Stock	47.4125	47.4125	47.4125	47.4125	400.0
2018-06-08 04:45:00	AAPL	Stock	47.4225	47.4225	47.4225	47.4225	980.0
2018-06-08 04:46:00	AAPL	Stock	47.4725	47.4725	47.4725	47.4725	400.0
2018-06-08 04:48:00	AAPL	Stock	47.4625	47.4625	47.4625	47.4625	400.0
2018-06-08 04:52:00	AAPL	Stock	47.375	47.375	47.375	47.375	400.0
2018-06-08 04:54:00	AAPL	Stock	47.35	47.35	47.35	47.35	400.0
2018-06-08 04:55:00	AAPL	Stock	47.35	47.355	47.35	47.355	11540.0
2018-06-08 04:56:00	AAPL	Stock	47.4125	47.4125	47.4125	47.4125	400.0
2018-06-08 04:58:00	AAPL	Stock	47.3875	47.3875	47.3875	47.3875	400.0
2018-06-08 05:01:00	AAPL	Stock	47.3875	47.3875	47.3875	47.3875	400.0
2018-06-08 05:03:00	AAPL	Stock	47.3875	47.3875	47.3875	47.3875	1480.0
2018-06-08 05:10:00	AAPL	Stock	47.3725	47.3725	47.3725	47.3725	400.0
2018-06-08 05:13:00	AAPL	Stock	47.3675	47.3675	47.3675	47.3675	400.0
2018-06-08 05:14:00	AAPL	Stock	47.4125	47.4125	47.3775	47.3775	1360.0
2018-06-08 05:15:00	AAPL	Stock	47.35	47.35	47.35	47.35	8016.0
2018-06-08 05:18:00	AAPL	Stock	47.35	47.35	47.35	47.35	440.0
2018-06-08 05:19:00	AAPL	Stock	47.35	47.35	47.35	47.35	1200.0
2018-06-08 05:21:00	AAPL	Stock	47.3125	47.3125	47.3125	47.3125	400.0
2018-06-08 05:23:00	AAPL	Stock	47.3625	47.375	47.3625	47.375	3200.0
2018-06-08 05:29:00	AAPL	Stock	47.3225	47.3225	47.3175	47.3175	2000.0
2018-06-08 05:32:00	AAPL	Stock	47.4175	47.4175	47.4175	47.4175	1000.0
2018-06-08 05:34:00	AAPL	Stock	47.4175	47.4375	47.4175	47.4375	1000.0
2018-06-08 05:35:00	AAPL	Stock	47.4375	47.4375	47.4375	47.4375	8636.0
2018-06-08 05:38:00	AAPL	Stock	47.375	47.375	47.375	47.375	800.0

> showing 50 of 1,073,435 rows — these rows as CSV

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