PREVIEW / stock_1min / 2018-07-30

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-07-30.parquet
  size:    14.9 MB
  rows:    1,068,568
  symbols: 2,350

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-07-30 04:00:00	AAPL	Stock	47.75	47.75	47.745	47.745	6800.0
2018-07-30 04:03:00	AAPL	Stock	47.7125	47.7125	47.7125	47.7125	4000.0
2018-07-30 04:06:00	AAPL	Stock	47.7	47.7	47.7	47.7	800.0
2018-07-30 04:07:00	AAPL	Stock	47.7	47.7	47.7	47.7	400.0
2018-07-30 04:09:00	AAPL	Stock	47.7	47.7	47.7	47.7	1200.0
2018-07-30 04:10:00	AAPL	Stock	47.7	47.7	47.7	47.7	1804.0
2018-07-30 04:15:00	AAPL	Stock	47.7	47.7	47.7	47.7	400.0
2018-07-30 04:16:00	AAPL	Stock	47.7	47.7	47.7	47.7	4000.0
2018-07-30 04:30:00	AAPL	Stock	47.9675	47.9675	47.9675	47.9675	400.0
2018-07-30 04:38:00	AAPL	Stock	47.745	47.745	47.745	47.745	400.0
2018-07-30 05:01:00	AAPL	Stock	47.75	47.75	47.75	47.75	400.0
2018-07-30 05:02:00	AAPL	Stock	47.9	47.9	47.8925	47.8925	4000.0
2018-07-30 05:18:00	AAPL	Stock	47.7875	47.7875	47.7875	47.7875	400.0
2018-07-30 05:22:00	AAPL	Stock	47.8575	47.86	47.8575	47.86	800.0
2018-07-30 05:26:00	AAPL	Stock	47.82	47.82	47.7575	47.7575	4268.0
2018-07-30 05:27:00	AAPL	Stock	47.76	47.76	47.76	47.76	416.0
2018-07-30 05:29:00	AAPL	Stock	47.7925	47.7925	47.7925	47.7925	424.0
2018-07-30 05:30:00	AAPL	Stock	47.7925	47.7925	47.7925	47.7925	3576.0
2018-07-30 05:42:00	AAPL	Stock	47.8025	47.8025	47.8025	47.8025	416.0
2018-07-30 05:44:00	AAPL	Stock	47.81	47.81	47.7875	47.7875	800.0
2018-07-30 05:45:00	AAPL	Stock	47.7675	47.7675	47.7575	47.7575	2796.0
2018-07-30 05:48:00	AAPL	Stock	47.75	47.75	47.75	47.75	400.0
2018-07-30 05:52:00	AAPL	Stock	47.75	47.75	47.75	47.75	1580.0
2018-07-30 05:55:00	AAPL	Stock	47.8475	47.8575	47.8475	47.8525	11252.0
2018-07-30 05:56:00	AAPL	Stock	47.8525	47.8525	47.8525	47.8525	400.0
2018-07-30 05:57:00	AAPL	Stock	47.855	47.855	47.855	47.855	3948.0
2018-07-30 05:58:00	AAPL	Stock	47.825	47.825	47.825	47.825	400.0
2018-07-30 05:59:00	AAPL	Stock	47.825	47.825	47.825	47.825	3600.0
2018-07-30 06:03:00	AAPL	Stock	47.825	47.825	47.825	47.825	400.0
2018-07-30 06:11:00	AAPL	Stock	47.795	47.795	47.795	47.795	1908.0
2018-07-30 06:22:00	AAPL	Stock	47.795	47.795	47.795	47.795	440.0
2018-07-30 06:36:00	AAPL	Stock	47.795	47.8	47.795	47.8	2688.0
2018-07-30 06:52:00	AAPL	Stock	47.825	47.825	47.825	47.825	1200.0
2018-07-30 06:57:00	AAPL	Stock	47.85	47.85	47.85	47.85	1200.0
2018-07-30 07:00:00	AAPL	Stock	47.815	47.87	47.8	47.8475	17736.0
2018-07-30 07:01:00	AAPL	Stock	47.85	47.85	47.85	47.85	640.0
2018-07-30 07:03:00	AAPL	Stock	47.87	47.8725	47.87	47.8725	8980.0
2018-07-30 07:04:00	AAPL	Stock	47.8725	47.8725	47.8725	47.8725	2920.0
2018-07-30 07:06:00	AAPL	Stock	47.9	47.9	47.9	47.9	4000.0
2018-07-30 07:10:00	AAPL	Stock	47.8775	47.8775	47.8525	47.8525	7840.0
2018-07-30 07:11:00	AAPL	Stock	47.85	47.85	47.85	47.85	7400.0
2018-07-30 07:12:00	AAPL	Stock	47.8675	47.87	47.8675	47.87	800.0
2018-07-30 07:13:00	AAPL	Stock	47.8875	47.8875	47.8775	47.8775	800.0
2018-07-30 07:14:00	AAPL	Stock	47.8775	47.8775	47.8775	47.8775	400.0
2018-07-30 07:15:00	AAPL	Stock	47.875	47.875	47.85	47.85	7200.0
2018-07-30 07:16:00	AAPL	Stock	47.87	47.87	47.87	47.87	400.0
2018-07-30 07:17:00	AAPL	Stock	47.8425	47.8425	47.825	47.825	6636.0
2018-07-30 07:19:00	AAPL	Stock	47.85	47.855	47.83	47.855	2600.0
2018-07-30 07:20:00	AAPL	Stock	47.85	47.85	47.85	47.85	7644.0
2018-07-30 07:21:00	AAPL	Stock	47.8575	47.8575	47.8575	47.8575	2000.0

> showing 50 of 1,068,568 rows — these rows as CSV

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