PREVIEW / stock_1min / 2020-03-09

all stock 1-min files

  file:    by_date/stock_1min/2020/2020-03-09.parquet
  size:    20.3 MB
  rows:    1,338,597
  symbols: 2,068

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-09 04:00:00	AAPL	Stock	67.8325	67.8325	67.525	67.695	68484.0
2020-03-09 04:01:00	AAPL	Stock	67.975	67.975	67.125	67.125	19428.0
2020-03-09 04:02:00	AAPL	Stock	67.25	67.25	67.13	67.13	4120.0
2020-03-09 04:03:00	AAPL	Stock	67.1525	67.155	67.1525	67.155	1780.0
2020-03-09 04:04:00	AAPL	Stock	67.1575	67.1875	67.075	67.1875	14756.0
2020-03-09 04:05:00	AAPL	Stock	67.1875	67.1875	67.125	67.125	3728.0
2020-03-09 04:06:00	AAPL	Stock	67.2175	67.25	67.13	67.25	7612.0
2020-03-09 04:07:00	AAPL	Stock	67.3675	67.4	67.3675	67.4	2448.0
2020-03-09 04:08:00	AAPL	Stock	67.45	67.5	67.45	67.5	1612.0
2020-03-09 04:09:00	AAPL	Stock	67.82	67.9475	67.82	67.9475	1392.0
2020-03-09 04:10:00	AAPL	Stock	67.5775	67.6	67.5	67.5	3148.0
2020-03-09 04:11:00	AAPL	Stock	67.45	67.45	67.425	67.425	2972.0
2020-03-09 04:12:00	AAPL	Stock	67.425	67.495	67.425	67.495	1544.0
2020-03-09 04:13:00	AAPL	Stock	67.425	67.425	67.375	67.375	11744.0
2020-03-09 04:14:00	AAPL	Stock	67.4	67.4	67.15	67.15	2624.0
2020-03-09 04:15:00	AAPL	Stock	67.1525	67.1525	67.0	67.0	8852.0
2020-03-09 04:16:00	AAPL	Stock	66.97	66.97	66.875	66.875	1636.0
2020-03-09 04:22:00	AAPL	Stock	67.03	67.05	67.025	67.05	1900.0
2020-03-09 04:23:00	AAPL	Stock	67.05	67.1	67.0	67.0	3632.0
2020-03-09 04:25:00	AAPL	Stock	66.875	66.875	66.875	66.875	488.0
2020-03-09 04:26:00	AAPL	Stock	66.675	66.8	66.675	66.8	1016.0
2020-03-09 04:29:00	AAPL	Stock	66.8725	66.875	66.84	66.84	2632.0
2020-03-09 04:30:00	AAPL	Stock	66.885	67.0	66.875	66.925	7596.0
2020-03-09 04:31:00	AAPL	Stock	66.955	66.955	66.95	66.95	800.0
2020-03-09 04:33:00	AAPL	Stock	66.9525	67.0	66.9525	66.9975	6780.0
2020-03-09 04:34:00	AAPL	Stock	66.9375	66.9525	66.9275	66.9275	5484.0
2020-03-09 04:35:00	AAPL	Stock	66.9275	66.9275	66.9275	66.9275	2800.0
2020-03-09 04:36:00	AAPL	Stock	67.0	67.0	67.0	67.0	5152.0
2020-03-09 04:37:00	AAPL	Stock	66.95	66.95	66.95	66.95	1800.0
2020-03-09 04:40:00	AAPL	Stock	66.9625	66.9625	66.81	66.81	41516.0
2020-03-09 04:41:00	AAPL	Stock	66.7725	66.7725	66.725	66.725	4668.0
2020-03-09 04:43:00	AAPL	Stock	66.7	66.7	66.7	66.7	400.0
2020-03-09 04:44:00	AAPL	Stock	66.6275	66.6525	66.625	66.625	7000.0
2020-03-09 04:45:00	AAPL	Stock	66.8625	66.8625	66.8625	66.8625	400.0
2020-03-09 04:46:00	AAPL	Stock	66.9375	66.9375	66.8	66.8	2500.0
2020-03-09 04:47:00	AAPL	Stock	66.88	66.935	66.7875	66.8775	5464.0
2020-03-09 04:48:00	AAPL	Stock	66.8775	66.9375	66.875	66.9375	1932.0
2020-03-09 04:49:00	AAPL	Stock	66.97	66.97	66.97	66.97	400.0
2020-03-09 04:51:00	AAPL	Stock	66.9875	66.9875	66.95	66.95	4000.0
2020-03-09 04:52:00	AAPL	Stock	66.95	66.9875	66.8825	66.9875	5792.0
2020-03-09 04:53:00	AAPL	Stock	66.9875	66.9875	66.9875	66.9875	1948.0
2020-03-09 04:54:00	AAPL	Stock	67.105	67.125	67.0	67.0	3864.0
2020-03-09 04:56:00	AAPL	Stock	66.9975	67.125	66.9975	67.125	15028.0
2020-03-09 04:57:00	AAPL	Stock	67.1	67.1	67.1	67.1	400.0
2020-03-09 04:59:00	AAPL	Stock	67.0	67.0	67.0	67.0	3188.0
2020-03-09 05:00:00	AAPL	Stock	67.0425	67.125	67.0425	67.125	3060.0
2020-03-09 05:01:00	AAPL	Stock	67.07	67.07	67.07	67.07	400.0
2020-03-09 05:04:00	AAPL	Stock	67.125	67.125	67.125	67.125	1200.0
2020-03-09 05:05:00	AAPL	Stock	67.0925	67.1	67.0925	67.1	6420.0
2020-03-09 05:06:00	AAPL	Stock	67.195	67.225	67.195	67.2025	6200.0

> showing 50 of 1,338,597 rows — these rows as CSV

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