PREVIEW / stock_30min / 2020-05-01

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-05-01.parquet
  size:    1.8 MB
  rows:    92,985
  symbols: 2,394

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-05-01 04:00:00	AAPL	Stock	71.32	71.4175	71.0	71.2225	25992.0
2020-05-01 04:30:00	AAPL	Stock	71.22	71.275	71.125	71.245	6524.0
2020-05-01 05:00:00	AAPL	Stock	71.325	71.4975	71.2775	71.2775	12144.0
2020-05-01 05:30:00	AAPL	Stock	71.25	71.25	71.125	71.135	5488.0
2020-05-01 06:00:00	AAPL	Stock	71.2625	71.5725	71.26	71.5725	30408.0
2020-05-01 06:30:00	AAPL	Stock	71.56	71.65	71.325	71.3775	23580.0
2020-05-01 07:00:00	AAPL	Stock	71.38	71.525	71.05	71.125	190540.0
2020-05-01 07:30:00	AAPL	Stock	71.1125	71.445	71.0875	71.375	176120.0
2020-05-01 08:00:00	AAPL	Stock	71.455	71.675	71.0275	71.1875	595592.0
2020-05-01 08:30:00	AAPL	Stock	71.245	71.8125	71.2075	71.6775	544624.0
2020-05-01 09:00:00	AAPL	Stock	71.72	71.935	71.4375	71.555	942572.0
2020-05-01 09:30:00	AAPL	Stock	71.5725	73.7075	71.4625	73.54	39210828.0
2020-05-01 10:00:00	AAPL	Stock	73.5475	74.75	73.375	74.035	34981108.0
2020-05-01 10:30:00	AAPL	Stock	74.015	74.3325	73.68	74.2	14982736.0
2020-05-01 11:00:00	AAPL	Stock	74.2	74.32	73.6825	73.765	10683712.0
2020-05-01 11:30:00	AAPL	Stock	73.761	73.9375	73.275	73.365	12353480.0
2020-05-01 12:00:00	AAPL	Stock	73.3675	73.4375	72.825	72.835	12645872.0
2020-05-01 12:30:00	AAPL	Stock	72.8375	72.8675	72.2125	72.5875	12299180.0
2020-05-01 13:00:00	AAPL	Stock	72.5875	72.875	72.17	72.5725	7872784.0
2020-05-01 13:30:00	AAPL	Stock	72.5618	72.745	72.29	72.6375	5638792.0
2020-05-01 14:00:00	AAPL	Stock	72.635	72.955	72.415	72.945	6742956.0
2020-05-01 14:30:00	AAPL	Stock	72.939	72.9475	72.6625	72.8488	5875112.0
2020-05-01 15:00:00	AAPL	Stock	72.8525	73.14	72.635	72.7368	9000340.0
2020-05-01 15:30:00	AAPL	Stock	72.7325	72.7775	72.005	72.2675	15866652.0
2020-05-01 16:00:00	AAPL	Stock	72.44	72.4875	72.2675	72.4	10276164.0
2020-05-01 16:30:00	AAPL	Stock	72.425	72.435	72.2675	72.39	334492.0
2020-05-01 17:00:00	AAPL	Stock	72.4075	72.495	72.3675	72.46	47404.0
2020-05-01 17:30:00	AAPL	Stock	72.475	72.625	72.45	72.5225	64684.0
2020-05-01 18:00:00	AAPL	Stock	72.5125	72.6125	72.5125	72.6125	25284.0
2020-05-01 18:30:00	AAPL	Stock	72.5875	72.635	72.5625	72.635	57152.0
2020-05-01 19:00:00	AAPL	Stock	72.6	72.7375	72.6	72.625	36584.0
2020-05-01 19:30:00	AAPL	Stock	72.625	72.7325	72.6	72.6	71580.0
2020-05-01 04:00:00	MSFT	Stock	175.95	175.95	174.15	174.89	3130.0
2020-05-01 04:30:00	MSFT	Stock	174.91	175.25	174.85	175.25	3277.0
2020-05-01 05:00:00	MSFT	Stock	175.39	175.39	175.28	175.3	300.0
2020-05-01 05:30:00	MSFT	Stock	175.25	175.5	175.25	175.5	5901.0
2020-05-01 06:00:00	MSFT	Stock	175.66	175.7	175.48	175.7	2260.0
2020-05-01 06:30:00	MSFT	Stock	175.53	175.53	175.32	175.44	2592.0
2020-05-01 07:00:00	MSFT	Stock	175.67	175.78	174.8	175.14	52803.0
2020-05-01 07:30:00	MSFT	Stock	175.11	176.0	175.0	175.6	38898.0
2020-05-01 08:00:00	MSFT	Stock	174.9	175.88	174.8	175.45	113978.0
2020-05-01 08:30:00	MSFT	Stock	175.45	175.984	175.4	175.8	51801.0
2020-05-01 09:00:00	MSFT	Stock	175.78	176.6	175.62	175.78	106992.0
2020-05-01 09:30:00	MSFT	Stock	175.79	177.83	175.62	177.586	4353875.0
2020-05-01 10:00:00	MSFT	Stock	177.61	178.485	176.81	177.41	2683656.0
2020-05-01 10:30:00	MSFT	Stock	177.414	178.64	177.13	178.121	2244798.0
2020-05-01 11:00:00	MSFT	Stock	178.11	178.11	176.922	177.07	1707560.0
2020-05-01 11:30:00	MSFT	Stock	177.06	177.27	176.162	176.31	1738081.0
2020-05-01 12:00:00	MSFT	Stock	176.3	176.32	175.63	175.862	1930229.0
2020-05-01 12:30:00	MSFT	Stock	175.88	176.13	174.9	175.16	1872830.0

> showing 50 of 92,985 rows — these rows as CSV

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