PREVIEW / stock_1min / 2020-04-09

all stock 1-min files

  file:    by_date/stock_1min/2020/2020-04-09.parquet
  size:    20.9 MB
  rows:    1,362,921
  symbols: 2,041

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-04-09 04:00:00	AAPL	Stock	67.1375	67.1375	67.125	67.125	1252.0
2020-04-09 04:01:00	AAPL	Stock	67.0225	67.225	67.0225	67.225	1012.0
2020-04-09 04:05:00	AAPL	Stock	67.0375	67.0375	67.025	67.025	1200.0
2020-04-09 04:08:00	AAPL	Stock	67.025	67.025	67.025	67.025	1632.0
2020-04-09 04:10:00	AAPL	Stock	67.0	67.0	67.0	67.0	3944.0
2020-04-09 04:12:00	AAPL	Stock	66.9625	66.9625	66.9625	66.9625	800.0
2020-04-09 04:15:00	AAPL	Stock	66.9	66.9	66.9	66.9	528.0
2020-04-09 04:17:00	AAPL	Stock	66.7525	66.7525	66.7525	66.7525	400.0
2020-04-09 04:24:00	AAPL	Stock	66.9025	66.9025	66.8775	66.8825	4140.0
2020-04-09 04:25:00	AAPL	Stock	66.7875	66.7875	66.7875	66.7875	4280.0
2020-04-09 04:26:00	AAPL	Stock	66.7875	66.7875	66.7875	66.7875	748.0
2020-04-09 04:29:00	AAPL	Stock	66.65	66.65	66.6275	66.6275	800.0
2020-04-09 04:35:00	AAPL	Stock	66.715	66.715	66.7125	66.7125	1200.0
2020-04-09 04:36:00	AAPL	Stock	66.7	66.75	66.7	66.75	3600.0
2020-04-09 04:38:00	AAPL	Stock	66.715	66.715	66.7025	66.7025	1788.0
2020-04-09 04:39:00	AAPL	Stock	66.6275	66.6275	66.6275	66.6275	13200.0
2020-04-09 04:41:00	AAPL	Stock	66.6125	66.6125	66.6125	66.6125	400.0
2020-04-09 04:42:00	AAPL	Stock	66.6275	66.6275	66.6275	66.6275	2084.0
2020-04-09 04:53:00	AAPL	Stock	66.655	66.655	66.655	66.655	400.0
2020-04-09 04:59:00	AAPL	Stock	66.6	66.6	66.6	66.6	400.0
2020-04-09 05:03:00	AAPL	Stock	66.625	66.625	66.6225	66.625	3044.0
2020-04-09 05:04:00	AAPL	Stock	66.5225	66.5225	66.5225	66.5225	400.0
2020-04-09 05:05:00	AAPL	Stock	66.5225	66.5225	66.5	66.5	1200.0
2020-04-09 05:07:00	AAPL	Stock	66.525	66.525	66.525	66.525	412.0
2020-04-09 05:08:00	AAPL	Stock	66.5325	66.5325	66.5325	66.5325	412.0
2020-04-09 05:12:00	AAPL	Stock	66.2525	66.2525	66.2525	66.2525	1060.0
2020-04-09 05:17:00	AAPL	Stock	66.3225	66.3225	66.3225	66.3225	1080.0
2020-04-09 05:18:00	AAPL	Stock	66.275	66.275	66.275	66.275	740.0
2020-04-09 05:19:00	AAPL	Stock	66.275	66.275	66.275	66.275	400.0
2020-04-09 05:20:00	AAPL	Stock	66.2875	66.2875	66.25	66.25	2172.0
2020-04-09 05:21:00	AAPL	Stock	66.1	66.1	66.1	66.1	444.0
2020-04-09 05:22:00	AAPL	Stock	66.25	66.25	66.1275	66.1275	800.0
2020-04-09 05:23:00	AAPL	Stock	66.25	66.25	66.25	66.25	800.0
2020-04-09 05:48:00	AAPL	Stock	66.4	66.4	66.4	66.4	1600.0
2020-04-09 05:54:00	AAPL	Stock	66.2925	66.2925	66.11	66.1375	2456.0
2020-04-09 06:02:00	AAPL	Stock	66.2225	66.2225	66.2225	66.2225	692.0
2020-04-09 06:03:00	AAPL	Stock	66.2025	66.2225	66.2025	66.2225	1416.0
2020-04-09 06:19:00	AAPL	Stock	66.285	66.2875	66.285	66.2875	920.0
2020-04-09 06:25:00	AAPL	Stock	66.2525	66.2525	66.0025	66.0025	2400.0
2020-04-09 06:26:00	AAPL	Stock	66.0025	66.0025	66.0025	66.0025	8200.0
2020-04-09 06:28:00	AAPL	Stock	66.0	66.1	66.0	66.0025	5640.0
2020-04-09 06:29:00	AAPL	Stock	66.0975	66.1125	66.0975	66.1125	2000.0
2020-04-09 06:30:00	AAPL	Stock	66.1125	66.1125	66.11	66.1125	2000.0
2020-04-09 06:32:00	AAPL	Stock	66.0875	66.0875	66.01	66.01	1000.0
2020-04-09 06:33:00	AAPL	Stock	66.04	66.04	66.04	66.04	1200.0
2020-04-09 06:34:00	AAPL	Stock	66.04	66.04	66.0	66.0	800.0
2020-04-09 06:36:00	AAPL	Stock	66.0375	66.095	66.0	66.095	2000.0
2020-04-09 06:37:00	AAPL	Stock	66.095	66.095	66.095	66.095	400.0
2020-04-09 06:40:00	AAPL	Stock	66.075	66.075	66.075	66.075	2000.0
2020-04-09 06:50:00	AAPL	Stock	66.075	66.075	66.075	66.075	400.0

> showing 50 of 1,362,921 rows — these rows as CSV

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