PREVIEW / stock_1min / 2019-08-05

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-08-05.parquet
  size:    17.9 MB
  rows:    1,199,530
  symbols: 2,165

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
2019-08-05 04:00:00	AAPL	Stock	49.75	49.99	49.75	49.8	18320.0
2019-08-05 04:02:00	AAPL	Stock	49.92	49.92	49.92	49.92	800.0
2019-08-05 04:03:00	AAPL	Stock	49.9	49.995	49.9	49.995	3960.0
2019-08-05 04:04:00	AAPL	Stock	49.875	49.875	49.875	49.875	400.0
2019-08-05 04:05:00	AAPL	Stock	49.8725	49.8725	49.8725	49.8725	400.0
2019-08-05 04:07:00	AAPL	Stock	49.85	49.85	49.85	49.85	400.0
2019-08-05 04:08:00	AAPL	Stock	49.7875	49.7875	49.745	49.7875	2540.0
2019-08-05 04:10:00	AAPL	Stock	49.72	49.72	49.72	49.72	3624.0
2019-08-05 04:11:00	AAPL	Stock	49.7	49.7	49.7	49.7	2000.0
2019-08-05 04:19:00	AAPL	Stock	49.705	49.705	49.705	49.705	1200.0
2019-08-05 04:20:00	AAPL	Stock	49.7325	49.735	49.7325	49.735	1908.0
2019-08-05 04:24:00	AAPL	Stock	49.735	49.735	49.735	49.735	800.0
2019-08-05 04:28:00	AAPL	Stock	49.735	49.745	49.735	49.745	2488.0
2019-08-05 04:29:00	AAPL	Stock	49.705	49.705	49.705	49.705	800.0
2019-08-05 04:30:00	AAPL	Stock	49.7	49.7	49.695	49.695	2008.0
2019-08-05 04:31:00	AAPL	Stock	49.69	49.69	49.69	49.69	420.0
2019-08-05 04:32:00	AAPL	Stock	49.74	49.75	49.74	49.75	7048.0
2019-08-05 04:34:00	AAPL	Stock	49.7875	49.7875	49.7875	49.7875	400.0
2019-08-05 04:35:00	AAPL	Stock	49.7875	49.86	49.7875	49.86	11200.0
2019-08-05 04:42:00	AAPL	Stock	49.915	49.915	49.915	49.915	400.0
2019-08-05 04:54:00	AAPL	Stock	49.82	49.82	49.82	49.82	400.0
2019-08-05 04:56:00	AAPL	Stock	49.775	49.775	49.71	49.71	2776.0
2019-08-05 04:58:00	AAPL	Stock	49.675	49.675	49.675	49.675	7600.0
2019-08-05 04:59:00	AAPL	Stock	49.675	49.6825	49.6525	49.6525	5640.0
2019-08-05 05:01:00	AAPL	Stock	49.645	49.645	49.625	49.625	5200.0
2019-08-05 05:02:00	AAPL	Stock	49.685	49.7	49.685	49.7	2796.0
2019-08-05 05:03:00	AAPL	Stock	49.7	49.7	49.7	49.7	17204.0
2019-08-05 05:05:00	AAPL	Stock	49.65	49.65	49.65	49.65	5196.0
2019-08-05 05:06:00	AAPL	Stock	49.65	49.65	49.65	49.65	1200.0
2019-08-05 05:09:00	AAPL	Stock	49.625	49.625	49.625	49.625	9920.0
2019-08-05 05:10:00	AAPL	Stock	49.6	49.625	49.6	49.625	1340.0
2019-08-05 05:11:00	AAPL	Stock	49.625	49.625	49.625	49.625	9060.0
2019-08-05 05:12:00	AAPL	Stock	49.6425	49.6475	49.6425	49.6425	1200.0
2019-08-05 05:13:00	AAPL	Stock	49.6425	49.645	49.6425	49.645	1800.0
2019-08-05 05:15:00	AAPL	Stock	49.635	49.635	49.635	49.635	400.0
2019-08-05 05:19:00	AAPL	Stock	49.6475	49.65	49.6475	49.6475	1912.0
2019-08-05 05:28:00	AAPL	Stock	49.6325	49.8225	49.6325	49.8225	3640.0
2019-08-05 05:29:00	AAPL	Stock	49.8025	49.8025	49.8025	49.8025	400.0
2019-08-05 05:32:00	AAPL	Stock	49.8825	49.8825	49.8825	49.8825	400.0
2019-08-05 05:33:00	AAPL	Stock	49.815	49.815	49.8025	49.8025	1400.0
2019-08-05 05:34:00	AAPL	Stock	49.8175	49.8175	49.8175	49.8175	400.0
2019-08-05 05:35:00	AAPL	Stock	49.8025	49.8025	49.7975	49.7975	1400.0
2019-08-05 05:36:00	AAPL	Stock	49.8	49.875	49.8	49.875	2128.0
2019-08-05 05:37:00	AAPL	Stock	49.8	49.85	49.8	49.85	1600.0
2019-08-05 05:40:00	AAPL	Stock	49.9175	49.9175	49.9175	49.9175	800.0
2019-08-05 05:41:00	AAPL	Stock	49.9725	49.9975	49.9725	49.9975	1576.0
2019-08-05 05:42:00	AAPL	Stock	50.0	50.0	50.0	50.0	800.0
2019-08-05 05:43:00	AAPL	Stock	49.9075	49.9075	49.9075	49.9075	400.0
2019-08-05 05:47:00	AAPL	Stock	49.9	49.9	49.8925	49.8925	3200.0
2019-08-05 05:51:00	AAPL	Stock	49.8875	49.8875	49.8875	49.8875	1000.0

> showing 50 of 1,199,530 rows — these rows as CSV

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