PREVIEW / stock_1min / 2020-03-23

all stock 1-min files

  file:    by_date/stock_1min/2020/2020-03-23.parquet
  size:    21.1 MB
  rows:    1,421,099
  symbols: 2,078

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
2020-03-23 04:00:00	AAPL	Stock	56.22	56.22	55.5	55.5375	12204.0
2020-03-23 04:01:00	AAPL	Stock	55.9925	56.1875	55.75	56.1075	4740.0
2020-03-23 04:02:00	AAPL	Stock	56.1075	56.1075	56.0	56.0	8716.0
2020-03-23 04:03:00	AAPL	Stock	55.875	56.1	55.7875	55.7875	7824.0
2020-03-23 04:04:00	AAPL	Stock	55.7875	55.845	55.75	55.75	9788.0
2020-03-23 04:05:00	AAPL	Stock	55.75	55.75	55.5	55.5	3492.0
2020-03-23 04:07:00	AAPL	Stock	55.7475	55.975	55.7475	55.975	2280.0
2020-03-23 04:08:00	AAPL	Stock	55.8825	55.9475	55.8825	55.9	1200.0
2020-03-23 04:09:00	AAPL	Stock	55.8	55.86	55.555	55.625	16368.0
2020-03-23 04:10:00	AAPL	Stock	55.6	55.6	55.6	55.6	400.0
2020-03-23 04:15:00	AAPL	Stock	55.55	55.5525	55.5	55.5	16056.0
2020-03-23 04:16:00	AAPL	Stock	55.3775	55.3825	55.375	55.375	7140.0
2020-03-23 04:17:00	AAPL	Stock	55.37	55.375	55.37	55.375	2048.0
2020-03-23 04:19:00	AAPL	Stock	55.45	55.5025	55.4	55.45	11232.0
2020-03-23 04:20:00	AAPL	Stock	55.4475	55.5	55.425	55.435	12000.0
2020-03-23 04:21:00	AAPL	Stock	55.4925	55.5	55.45	55.45	3396.0
2020-03-23 04:22:00	AAPL	Stock	55.45	55.5	55.44	55.5	4252.0
2020-03-23 04:23:00	AAPL	Stock	55.5375	55.5375	55.475	55.5	7564.0
2020-03-23 04:24:00	AAPL	Stock	55.4625	55.4625	55.4625	55.4625	400.0
2020-03-23 04:25:00	AAPL	Stock	55.475	55.475	55.475	55.475	400.0
2020-03-23 04:27:00	AAPL	Stock	55.5975	55.5975	55.5975	55.5975	680.0
2020-03-23 04:28:00	AAPL	Stock	55.665	55.665	55.665	55.665	2000.0
2020-03-23 04:29:00	AAPL	Stock	55.7175	55.75	55.7175	55.75	1348.0
2020-03-23 04:30:00	AAPL	Stock	55.75	55.75	55.75	55.75	800.0
2020-03-23 04:31:00	AAPL	Stock	55.75	55.75	55.6675	55.6675	2948.0
2020-03-23 04:32:00	AAPL	Stock	55.75	55.86	55.68	55.68	3872.0
2020-03-23 04:33:00	AAPL	Stock	55.675	55.675	55.675	55.675	400.0
2020-03-23 04:35:00	AAPL	Stock	55.7925	55.875	55.7925	55.875	1580.0
2020-03-23 04:36:00	AAPL	Stock	55.805	55.805	55.75	55.75	8184.0
2020-03-23 04:37:00	AAPL	Stock	55.6875	55.6875	55.6875	55.6875	800.0
2020-03-23 04:40:00	AAPL	Stock	55.625	55.75	55.625	55.75	1160.0
2020-03-23 04:41:00	AAPL	Stock	55.8	55.87	55.8	55.87	1400.0
2020-03-23 04:43:00	AAPL	Stock	55.7975	55.7975	55.75	55.75	2988.0
2020-03-23 04:47:00	AAPL	Stock	55.8725	55.875	55.8725	55.875	1200.0
2020-03-23 04:48:00	AAPL	Stock	55.875	55.875	55.875	55.875	4268.0
2020-03-23 04:50:00	AAPL	Stock	55.8125	55.8125	55.8125	55.8125	400.0
2020-03-23 04:52:00	AAPL	Stock	55.875	55.875	55.775	55.775	5280.0
2020-03-23 04:53:00	AAPL	Stock	55.75	55.75	55.75	55.75	3800.0
2020-03-23 04:55:00	AAPL	Stock	55.775	55.775	55.655	55.655	3692.0
2020-03-23 04:56:00	AAPL	Stock	55.8	55.8	55.8	55.8	1596.0
2020-03-23 04:59:00	AAPL	Stock	55.6875	55.6875	55.6875	55.6875	2000.0
2020-03-23 05:00:00	AAPL	Stock	55.75	55.75	55.7	55.7	1124.0
2020-03-23 05:01:00	AAPL	Stock	55.82	55.82	55.82	55.82	400.0
2020-03-23 05:02:00	AAPL	Stock	55.825	55.825	55.825	55.825	996.0
2020-03-23 05:03:00	AAPL	Stock	55.9625	55.975	55.9625	55.975	4328.0
2020-03-23 05:05:00	AAPL	Stock	56.095	56.095	56.095	56.095	400.0
2020-03-23 05:06:00	AAPL	Stock	56.0125	56.0125	56.0125	56.0125	800.0
2020-03-23 05:07:00	AAPL	Stock	56.025	56.025	55.95	55.95	3572.0
2020-03-23 05:09:00	AAPL	Stock	55.9475	55.9475	55.9475	55.9475	400.0
2020-03-23 05:10:00	AAPL	Stock	55.9	55.9	55.9	55.9	1080.0

> showing 50 of 1,421,099 rows — these rows as CSV

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