PREVIEW / stock_30min / 2020-04-03

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-04-03.parquet
  size:    1.8 MB
  rows:    90,153
  symbols: 2,395

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-03 04:00:00	AAPL	Stock	60.655	60.825	60.35	60.35	8132.0
2020-04-03 04:30:00	AAPL	Stock	60.5	60.5025	60.5	60.5025	800.0
2020-04-03 05:30:00	AAPL	Stock	60.4125	60.525	60.375	60.525	3668.0
2020-04-03 06:00:00	AAPL	Stock	60.5975	60.67	60.5975	60.625	6292.0
2020-04-03 06:30:00	AAPL	Stock	60.5	60.625	60.5	60.605	5088.0
2020-04-03 07:00:00	AAPL	Stock	60.5	60.815	60.5	60.625	90576.0
2020-04-03 07:30:00	AAPL	Stock	60.625	61.45	60.625	61.3775	144624.0
2020-04-03 08:00:00	AAPL	Stock	60.7	61.45	60.575	60.75	241572.0
2020-04-03 08:30:00	AAPL	Stock	60.75	61.1875	60.5	60.8725	557548.0
2020-04-03 09:00:00	AAPL	Stock	60.8032	61.225	60.6025	60.7425	340264.0
2020-04-03 09:30:00	AAPL	Stock	60.725	61.425	60.5625	61.1575	12175160.0
2020-04-03 10:00:00	AAPL	Stock	61.1425	61.415	60.6125	60.7575	10187016.0
2020-04-03 10:30:00	AAPL	Stock	60.75	60.8025	60.39	60.76	7995848.0
2020-04-03 11:00:00	AAPL	Stock	60.7525	60.8975	60.42	60.5868	6048024.0
2020-04-03 11:30:00	AAPL	Stock	60.575	60.735	60.3975	60.576	5365220.0
2020-04-03 12:00:00	AAPL	Stock	60.5775	60.675	60.1625	60.3725	6157764.0
2020-04-03 12:30:00	AAPL	Stock	60.37	60.5532	60.2575	60.4465	4661216.0
2020-04-03 13:00:00	AAPL	Stock	60.44	60.625	60.245	60.28	3920512.0
2020-04-03 13:30:00	AAPL	Stock	60.2775	60.2788	59.9725	60.0925	5816216.0
2020-04-03 14:00:00	AAPL	Stock	60.09	60.1975	59.8775	60.1875	5938032.0
2020-04-03 14:30:00	AAPL	Stock	60.195	60.2225	59.825	60.1825	6202072.0
2020-04-03 15:00:00	AAPL	Stock	60.1825	60.3225	59.855	60.0225	8009280.0
2020-04-03 15:30:00	AAPL	Stock	60.0275	60.4225	59.7435	60.3575	14810144.0
2020-04-03 16:00:00	AAPL	Stock	60.355	60.5025	60.315	60.4725	11312956.0
2020-04-03 16:30:00	AAPL	Stock	60.4725	60.475	60.3875	60.4375	69348.0
2020-04-03 17:00:00	AAPL	Stock	60.4425	60.45	60.42	60.425	22224.0
2020-04-03 17:30:00	AAPL	Stock	60.425	60.425	60.3875	60.3875	20640.0
2020-04-03 18:00:00	AAPL	Stock	60.3775	60.425	60.36	60.36	36940.0
2020-04-03 18:30:00	AAPL	Stock	60.35	60.37	60.2825	60.3375	54156.0
2020-04-03 19:00:00	AAPL	Stock	60.3025	60.3325	60.25	60.2875	32328.0
2020-04-03 19:30:00	AAPL	Stock	60.3125	60.375	60.2825	60.3575	54256.0
2020-04-03 04:00:00	MSFT	Stock	154.44	154.44	153.0	153.0	2790.0
2020-04-03 04:30:00	MSFT	Stock	153.47	153.55	153.0	153.07	1897.0
2020-04-03 05:00:00	MSFT	Stock	153.23	153.23	153.05	153.05	428.0
2020-04-03 06:00:00	MSFT	Stock	153.85	153.85	153.59	153.59	304.0
2020-04-03 06:30:00	MSFT	Stock	153.75	153.89	153.75	153.89	1260.0
2020-04-03 07:00:00	MSFT	Stock	153.6	154.21	153.56	153.82	21535.0
2020-04-03 07:30:00	MSFT	Stock	153.89	155.77	153.85	155.5	34991.0
2020-04-03 08:00:00	MSFT	Stock	154.1	155.65	153.83	154.23	51227.0
2020-04-03 08:30:00	MSFT	Stock	154.06	155.5	153.8	154.7	62576.0
2020-04-03 09:00:00	MSFT	Stock	154.7	155.75	154.5	155.21	94543.0
2020-04-03 09:30:00	MSFT	Stock	155.2	156.94	154.45	156.34	4037290.0
2020-04-03 10:00:00	MSFT	Stock	156.34	157.38	155.07	155.49	3595768.0
2020-04-03 10:30:00	MSFT	Stock	155.48	156.28	155.121	156.06	2269643.0
2020-04-03 11:00:00	MSFT	Stock	156.09	156.465	154.87	155.07	2031699.0
2020-04-03 11:30:00	MSFT	Stock	155.1	155.425	154.474	154.81	1722078.0
2020-04-03 12:00:00	MSFT	Stock	154.78	155.01	153.12	153.65	2179763.0
2020-04-03 12:30:00	MSFT	Stock	153.633	153.95	153.01	153.562	1623838.0
2020-04-03 13:00:00	MSFT	Stock	153.562	154.2	153.161	153.265	1464371.0
2020-04-03 13:30:00	MSFT	Stock	153.25	153.25	152.36	152.59	1633996.0

> showing 50 of 90,153 rows — these rows as CSV

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