PREVIEW / stock_1min / 2018-04-03

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-04-03.parquet
  size:    15.7 MB
  rows:    1,127,894
  symbols: 2,397

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-03 04:00:00	AAPL	Stock	41.875	41.875	41.875	41.875	9088.0
2018-04-03 04:21:00	AAPL	Stock	41.7875	41.7875	41.7875	41.7875	948.0
2018-04-03 04:22:00	AAPL	Stock	41.7725	41.7725	41.7725	41.7725	1600.0
2018-04-03 04:28:00	AAPL	Stock	41.7	41.7	41.7	41.7	1976.0
2018-04-03 04:52:00	AAPL	Stock	41.8225	41.8225	41.8225	41.8225	500.0
2018-04-03 04:54:00	AAPL	Stock	41.8225	41.8225	41.8225	41.8225	400.0
2018-04-03 05:04:00	AAPL	Stock	41.775	41.775	41.775	41.775	800.0
2018-04-03 05:44:00	AAPL	Stock	41.805	41.84	41.805	41.84	4936.0
2018-04-03 05:50:00	AAPL	Stock	41.775	41.775	41.775	41.775	760.0
2018-04-03 06:04:00	AAPL	Stock	41.795	41.795	41.7875	41.7875	2244.0
2018-04-03 06:29:00	AAPL	Stock	41.8125	41.8125	41.8125	41.8125	800.0
2018-04-03 06:41:00	AAPL	Stock	41.875	41.875	41.875	41.875	2400.0
2018-04-03 06:46:00	AAPL	Stock	41.9125	41.92	41.9125	41.92	4436.0
2018-04-03 06:49:00	AAPL	Stock	41.9	41.9	41.9	41.9	1600.0
2018-04-03 07:00:00	AAPL	Stock	41.845	41.845	41.8375	41.8375	31040.0
2018-04-03 07:02:00	AAPL	Stock	41.8125	41.8125	41.805	41.805	4400.0
2018-04-03 07:04:00	AAPL	Stock	41.8025	41.8025	41.8025	41.8025	4000.0
2018-04-03 07:05:00	AAPL	Stock	41.8025	41.8225	41.8025	41.8225	6400.0
2018-04-03 07:06:00	AAPL	Stock	41.8225	41.825	41.8225	41.825	3592.0
2018-04-03 07:07:00	AAPL	Stock	41.825	41.825	41.825	41.825	2400.0
2018-04-03 07:09:00	AAPL	Stock	41.8125	41.8125	41.8125	41.8125	2000.0
2018-04-03 07:10:00	AAPL	Stock	41.825	41.825	41.825	41.825	10388.0
2018-04-03 07:11:00	AAPL	Stock	41.845	41.845	41.825	41.825	7852.0
2018-04-03 07:12:00	AAPL	Stock	41.845	41.85	41.845	41.85	9264.0
2018-04-03 07:13:00	AAPL	Stock	41.85	41.85	41.845	41.845	10000.0
2018-04-03 07:14:00	AAPL	Stock	41.8375	41.8375	41.8375	41.8375	12000.0
2018-04-03 07:16:00	AAPL	Stock	41.8375	41.8375	41.8375	41.8375	400.0
2018-04-03 07:18:00	AAPL	Stock	41.8375	41.8375	41.8375	41.8375	2000.0
2018-04-03 07:19:00	AAPL	Stock	41.84	41.8475	41.8375	41.8475	10200.0
2018-04-03 07:22:00	AAPL	Stock	41.845	41.845	41.845	41.845	4000.0
2018-04-03 07:27:00	AAPL	Stock	41.8375	41.8375	41.8325	41.8375	10000.0
2018-04-03 07:30:00	AAPL	Stock	41.815	41.815	41.815	41.815	1200.0
2018-04-03 07:32:00	AAPL	Stock	41.8175	41.8175	41.8025	41.8025	2400.0
2018-04-03 07:33:00	AAPL	Stock	41.82	41.82	41.82	41.82	1200.0
2018-04-03 07:35:00	AAPL	Stock	41.825	41.825	41.825	41.825	400.0
2018-04-03 07:37:00	AAPL	Stock	41.8075	41.8075	41.7925	41.7925	1352.0
2018-04-03 07:38:00	AAPL	Stock	41.7925	41.7925	41.7925	41.7925	728.0
2018-04-03 07:40:00	AAPL	Stock	41.8	41.82	41.8	41.82	12400.0
2018-04-03 07:44:00	AAPL	Stock	41.8025	41.8025	41.8025	41.8025	760.0
2018-04-03 07:47:00	AAPL	Stock	41.8425	41.86	41.8425	41.86	2868.0
2018-04-03 07:50:00	AAPL	Stock	41.825	41.825	41.825	41.825	1732.0
2018-04-03 07:53:00	AAPL	Stock	41.85	41.85	41.85	41.85	4000.0
2018-04-03 07:56:00	AAPL	Stock	41.86	41.86	41.86	41.86	400.0
2018-04-03 07:59:00	AAPL	Stock	41.8625	41.8625	41.8625	41.8625	11200.0
2018-04-03 08:00:00	AAPL	Stock	41.8625	41.8825	41.79	41.8825	46776.0
2018-04-03 08:01:00	AAPL	Stock	41.8825	41.8975	41.8825	41.8975	10176.0
2018-04-03 08:02:00	AAPL	Stock	41.85	41.85	41.85	41.85	2736.0
2018-04-03 08:03:00	AAPL	Stock	41.85	41.8625	41.85	41.8625	8000.0
2018-04-03 08:04:00	AAPL	Stock	41.8525	41.8525	41.8525	41.8525	800.0
2018-04-03 08:07:00	AAPL	Stock	41.85	41.85	41.85	41.85	1552.0

> showing 50 of 1,127,894 rows — these rows as CSV

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