PREVIEW / stock_5min / 2020-02-27

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-02-27.parquet
  size:    6.8 MB
  rows:    416,783
  symbols: 2,453

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-02-27 04:00:00	AAPL	Stock	72.275	72.575	72.275	72.5125	72580.0
2020-02-27 04:05:00	AAPL	Stock	72.495	72.685	72.4525	72.4925	12736.0
2020-02-27 04:10:00	AAPL	Stock	72.415	72.475	72.4075	72.475	1360.0
2020-02-27 04:15:00	AAPL	Stock	72.575	72.6225	72.55	72.55	4620.0
2020-02-27 04:20:00	AAPL	Stock	72.55	72.65	72.55	72.59	15424.0
2020-02-27 04:25:00	AAPL	Stock	72.6775	72.6775	72.6775	72.6775	400.0
2020-02-27 04:30:00	AAPL	Stock	72.6825	72.875	72.6825	72.875	2800.0
2020-02-27 04:35:00	AAPL	Stock	72.775	72.775	72.4975	72.4975	20948.0
2020-02-27 04:40:00	AAPL	Stock	72.695	72.695	72.5325	72.5325	2168.0
2020-02-27 04:45:00	AAPL	Stock	72.4975	72.4975	72.475	72.475	1452.0
2020-02-27 04:50:00	AAPL	Stock	72.4375	72.4375	72.4375	72.4375	812.0
2020-02-27 04:55:00	AAPL	Stock	72.3025	72.3025	72.25	72.25	1364.0
2020-02-27 05:00:00	AAPL	Stock	72.4075	72.475	72.4075	72.415	3440.0
2020-02-27 05:05:00	AAPL	Stock	72.28	72.3825	72.25	72.3825	3468.0
2020-02-27 05:25:00	AAPL	Stock	72.245	72.3525	72.245	72.345	22808.0
2020-02-27 05:30:00	AAPL	Stock	72.3375	72.375	72.3375	72.375	800.0
2020-02-27 05:35:00	AAPL	Stock	72.3425	72.475	72.3425	72.475	7844.0
2020-02-27 05:40:00	AAPL	Stock	72.4225	72.5	72.4225	72.5	1960.0
2020-02-27 05:45:00	AAPL	Stock	72.4975	72.5	72.375	72.375	21696.0
2020-02-27 05:50:00	AAPL	Stock	72.3725	72.3725	72.35	72.3725	4000.0
2020-02-27 05:55:00	AAPL	Stock	72.25	72.25	72.0025	72.0025	11524.0
2020-02-27 06:00:00	AAPL	Stock	71.99	72.0875	71.925	71.925	5296.0
2020-02-27 06:05:00	AAPL	Stock	71.925	72.0	71.875	72.0	2884.0
2020-02-27 06:10:00	AAPL	Stock	71.9875	72.125	71.9875	72.0625	11912.0
2020-02-27 06:15:00	AAPL	Stock	72.0675	72.1625	72.0625	72.09	11308.0
2020-02-27 06:20:00	AAPL	Stock	72.0	72.0625	71.9375	72.0625	9200.0
2020-02-27 06:25:00	AAPL	Stock	72.04	72.125	72.0175	72.06	4560.0
2020-02-27 06:30:00	AAPL	Stock	72.1625	72.1625	72.135	72.135	2068.0
2020-02-27 06:35:00	AAPL	Stock	72.065	72.065	72.0075	72.0075	2068.0
2020-02-27 06:50:00	AAPL	Stock	72.075	72.075	72.0	72.0725	5200.0
2020-02-27 06:55:00	AAPL	Stock	72.0075	72.0075	71.8075	71.8125	8960.0
2020-02-27 07:00:00	AAPL	Stock	71.95	72.0	71.8275	71.925	46692.0
2020-02-27 07:05:00	AAPL	Stock	71.875	71.95	71.8325	71.935	16976.0
2020-02-27 07:10:00	AAPL	Stock	71.92	71.9425	71.8725	71.9425	20572.0
2020-02-27 07:15:00	AAPL	Stock	71.9875	71.9875	71.825	71.9	14536.0
2020-02-27 07:20:00	AAPL	Stock	71.845	71.9	71.595	71.595	85636.0
2020-02-27 07:25:00	AAPL	Stock	71.625	71.6875	71.2125	71.2125	135076.0
2020-02-27 07:30:00	AAPL	Stock	71.15	71.6125	71.0875	71.6125	73684.0
2020-02-27 07:35:00	AAPL	Stock	71.6125	71.6125	71.275	71.275	55320.0
2020-02-27 07:40:00	AAPL	Stock	71.2675	71.275	71.1075	71.1525	107200.0
2020-02-27 07:45:00	AAPL	Stock	71.1525	71.375	71.15	71.25	113396.0
2020-02-27 07:50:00	AAPL	Stock	71.25	71.3675	71.0	71.0025	109244.0
2020-02-27 07:55:00	AAPL	Stock	71.055	71.0975	70.8625	70.8725	100544.0
2020-02-27 08:00:00	AAPL	Stock	72.0	72.0	70.825	71.175	388196.0
2020-02-27 08:05:00	AAPL	Stock	71.15	71.15	70.8275	70.83	100392.0
2020-02-27 08:10:00	AAPL	Stock	70.8325	70.9975	70.8325	70.8575	133340.0
2020-02-27 08:15:00	AAPL	Stock	70.86	71.0575	70.73	70.73	161916.0
2020-02-27 08:20:00	AAPL	Stock	70.7475	70.8675	70.54	70.8125	161584.0
2020-02-27 08:25:00	AAPL	Stock	70.8225	71.1875	70.8225	71.1725	132424.0
2020-02-27 08:30:00	AAPL	Stock	71.125	71.1875	71.0182	71.08	77424.0

> showing 50 of 416,783 rows — these rows as CSV

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