PREVIEW / stock_5min / 2020-04-09

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-04-09.parquet
  size:    6.7 MB
  rows:    420,092
  symbols: 2,416

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.225	67.0225	67.225	2264.0
2020-04-09 04:05:00	AAPL	Stock	67.0375	67.0375	67.025	67.025	2832.0
2020-04-09 04:10:00	AAPL	Stock	67.0	67.0	66.9625	66.9625	4744.0
2020-04-09 04:15:00	AAPL	Stock	66.9	66.9	66.7525	66.7525	928.0
2020-04-09 04:20: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.6275	66.6275	5828.0
2020-04-09 04:35:00	AAPL	Stock	66.715	66.75	66.6275	66.6275	19788.0
2020-04-09 04:40:00	AAPL	Stock	66.6125	66.6275	66.6125	66.6275	2484.0
2020-04-09 04:50:00	AAPL	Stock	66.655	66.655	66.655	66.655	400.0
2020-04-09 04:55:00	AAPL	Stock	66.6	66.6	66.6	66.6	400.0
2020-04-09 05:00:00	AAPL	Stock	66.625	66.625	66.5225	66.5225	3444.0
2020-04-09 05:05:00	AAPL	Stock	66.5225	66.5325	66.5	66.5325	2024.0
2020-04-09 05:10:00	AAPL	Stock	66.2525	66.2525	66.2525	66.2525	1060.0
2020-04-09 05:15:00	AAPL	Stock	66.3225	66.3225	66.275	66.275	2220.0
2020-04-09 05:20:00	AAPL	Stock	66.2875	66.2875	66.1	66.25	4216.0
2020-04-09 05:45:00	AAPL	Stock	66.4	66.4	66.4	66.4	1600.0
2020-04-09 05:50:00	AAPL	Stock	66.2925	66.2925	66.11	66.1375	2456.0
2020-04-09 06:00:00	AAPL	Stock	66.2225	66.2225	66.2025	66.2225	2108.0
2020-04-09 06:15: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.0	66.1125	18240.0
2020-04-09 06:30:00	AAPL	Stock	66.1125	66.1125	66.0	66.0	5000.0
2020-04-09 06:35:00	AAPL	Stock	66.0375	66.095	66.0	66.095	2400.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
2020-04-09 07:00:00	AAPL	Stock	66.105	66.42	66.0025	66.3375	20360.0
2020-04-09 07:05:00	AAPL	Stock	66.3375	66.4	66.3125	66.375	14040.0
2020-04-09 07:10:00	AAPL	Stock	66.4175	66.4175	66.33	66.33	2848.0
2020-04-09 07:15:00	AAPL	Stock	66.3075	66.3125	66.25	66.25	13112.0
2020-04-09 07:20:00	AAPL	Stock	66.25	66.3275	66.15	66.23	16244.0
2020-04-09 07:25:00	AAPL	Stock	66.1425	66.145	66.005	66.005	22708.0
2020-04-09 07:30:00	AAPL	Stock	66.0025	66.0425	65.85	66.0	48332.0
2020-04-09 07:35:00	AAPL	Stock	66.075	66.075	65.915	65.925	34828.0
2020-04-09 07:40:00	AAPL	Stock	65.9375	65.95	65.875	65.95	17568.0
2020-04-09 07:45:00	AAPL	Stock	65.935	66.075	65.925	66.0725	7240.0
2020-04-09 07:50:00	AAPL	Stock	66.1075	66.1125	66.075	66.075	6520.0
2020-04-09 07:55:00	AAPL	Stock	66.075	66.0775	66.0175	66.0175	7956.0
2020-04-09 08:00:00	AAPL	Stock	66.1745	66.4452	65.855	65.905	110688.0
2020-04-09 08:05:00	AAPL	Stock	65.9375	66.0	65.8975	65.97	23952.0
2020-04-09 08:10:00	AAPL	Stock	65.95	65.975	65.79	65.79	33668.0
2020-04-09 08:15:00	AAPL	Stock	65.845	65.875	65.5888	65.825	62992.0
2020-04-09 08:20:00	AAPL	Stock	65.7525	65.9375	65.7525	65.9	20592.0
2020-04-09 08:25:00	AAPL	Stock	65.8875	66.0	65.875	66.0	23076.0
2020-04-09 08:30:00	AAPL	Stock	66.0	66.7225	65.915	66.57	161300.0
2020-04-09 08:35:00	AAPL	Stock	66.575	66.595	66.4475	66.5	187964.0
2020-04-09 08:40:00	AAPL	Stock	66.465	66.55	66.3675	66.505	72160.0
2020-04-09 08:45:00	AAPL	Stock	66.6	66.825	66.5	66.8175	60144.0
2020-04-09 08:50:00	AAPL	Stock	66.8125	67.115	66.8	67.05	240512.0
2020-04-09 08:55:00	AAPL	Stock	67.05	67.3225	67.0	67.125	163544.0
2020-04-09 09:00:00	AAPL	Stock	67.1	67.2	67.0	67.125	92356.0
2020-04-09 09:05:00	AAPL	Stock	67.1125	67.455	67.1125	67.455	170888.0

> showing 50 of 420,092 rows — these rows as CSV

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