PREVIEW / stock_1min / 2018-01-18

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-01-18.parquet
  size:    15.7 MB
  rows:    1,086,331
  symbols: 2,407

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-01-18 04:00:00	AAPL	Stock	44.815	44.815	44.75	44.75	800.0
2018-01-18 04:03:00	AAPL	Stock	44.75	44.75	44.75	44.75	2000.0
2018-01-18 04:08:00	AAPL	Stock	44.7525	44.7525	44.7525	44.7525	1640.0
2018-01-18 04:12:00	AAPL	Stock	44.7275	44.7275	44.725	44.725	4588.0
2018-01-18 04:13:00	AAPL	Stock	44.725	44.725	44.725	44.725	400.0
2018-01-18 04:14:00	AAPL	Stock	44.725	44.725	44.7	44.7	6608.0
2018-01-18 04:15:00	AAPL	Stock	44.7	44.7	44.7	44.7	5600.0
2018-01-18 04:16:00	AAPL	Stock	44.7	44.7	44.7	44.7	400.0
2018-01-18 04:21:00	AAPL	Stock	44.7	44.7	44.7	44.7	1880.0
2018-01-18 04:27:00	AAPL	Stock	44.7175	44.7175	44.7175	44.7175	7120.0
2018-01-18 04:32:00	AAPL	Stock	44.7125	44.7125	44.7125	44.7125	1380.0
2018-01-18 04:35:00	AAPL	Stock	44.7125	44.7125	44.7125	44.7125	800.0
2018-01-18 04:47:00	AAPL	Stock	44.825	44.825	44.825	44.825	1120.0
2018-01-18 04:49:00	AAPL	Stock	44.8125	44.8125	44.8125	44.8125	800.0
2018-01-18 04:58:00	AAPL	Stock	44.8	44.8	44.8	44.8	1600.0
2018-01-18 05:30:00	AAPL	Stock	44.775	44.775	44.775	44.775	7552.0
2018-01-18 05:47:00	AAPL	Stock	44.8	44.8	44.8	44.8	800.0
2018-01-18 06:04:00	AAPL	Stock	44.7775	44.7775	44.775	44.775	4796.0
2018-01-18 06:10:00	AAPL	Stock	44.775	44.775	44.7725	44.775	7576.0
2018-01-18 06:11:00	AAPL	Stock	44.775	44.775	44.775	44.775	432.0
2018-01-18 06:22:00	AAPL	Stock	44.8	44.8	44.8	44.8	1600.0
2018-01-18 06:25:00	AAPL	Stock	44.8475	44.8625	44.8475	44.8625	9600.0
2018-01-18 06:26:00	AAPL	Stock	44.8725	44.8725	44.8725	44.8725	9600.0
2018-01-18 06:33:00	AAPL	Stock	44.8725	44.8725	44.8725	44.8725	400.0
2018-01-18 06:37:00	AAPL	Stock	44.8725	44.8725	44.8725	44.8725	440.0
2018-01-18 06:42:00	AAPL	Stock	44.8725	44.8725	44.8725	44.8725	800.0
2018-01-18 06:43:00	AAPL	Stock	44.8725	44.8725	44.8725	44.8725	800.0
2018-01-18 06:45:00	AAPL	Stock	44.8725	44.8725	44.8725	44.8725	400.0
2018-01-18 06:47:00	AAPL	Stock	44.8525	44.8525	44.8525	44.8525	800.0
2018-01-18 06:49:00	AAPL	Stock	44.87	44.87	44.87	44.87	400.0
2018-01-18 06:53:00	AAPL	Stock	44.87	44.87	44.87	44.87	400.0
2018-01-18 06:54:00	AAPL	Stock	44.85	44.85	44.85	44.85	400.0
2018-01-18 06:56:00	AAPL	Stock	44.87	44.87	44.87	44.87	400.0
2018-01-18 07:00:00	AAPL	Stock	44.87	44.9	44.87	44.9	34956.0
2018-01-18 07:01:00	AAPL	Stock	44.9	44.9325	44.9	44.925	17824.0
2018-01-18 07:02:00	AAPL	Stock	44.925	44.9325	44.925	44.9325	1800.0
2018-01-18 07:03:00	AAPL	Stock	44.9225	44.9225	44.9125	44.9125	3500.0
2018-01-18 07:04:00	AAPL	Stock	44.9125	44.9125	44.9125	44.9125	1500.0
2018-01-18 07:05:00	AAPL	Stock	44.91	44.91	44.9	44.9	1612.0
2018-01-18 07:08:00	AAPL	Stock	44.9075	44.91	44.9075	44.91	880.0
2018-01-18 07:10:00	AAPL	Stock	44.91	44.91	44.91	44.91	960.0
2018-01-18 07:11:00	AAPL	Stock	44.9125	44.9125	44.9	44.9	8368.0
2018-01-18 07:12:00	AAPL	Stock	44.9125	44.9125	44.9125	44.9125	4000.0
2018-01-18 07:14:00	AAPL	Stock	44.9125	44.925	44.9125	44.925	840.0
2018-01-18 07:15:00	AAPL	Stock	44.91	44.91	44.9	44.9	3200.0
2018-01-18 07:17:00	AAPL	Stock	44.9	44.9	44.9	44.9	800.0
2018-01-18 07:18:00	AAPL	Stock	44.895	44.8975	44.895	44.8975	1988.0
2018-01-18 07:19:00	AAPL	Stock	44.895	44.895	44.895	44.895	400.0
2018-01-18 07:20:00	AAPL	Stock	44.895	44.895	44.895	44.895	4520.0
2018-01-18 07:21:00	AAPL	Stock	44.875	44.88	44.875	44.875	9920.0

> showing 50 of 1,086,331 rows — these rows as CSV

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