PREVIEW / stock_30min / 2020-03-27

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-03-27.parquet
  size:    1.8 MB
  rows:    93,056
  symbols: 2,443

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-03-27 04:00:00	AAPL	Stock	63.61	63.8	63.375	63.4625	36568.0
2020-03-27 04:30:00	AAPL	Stock	63.5	63.5675	63.375	63.375	6208.0
2020-03-27 05:00:00	AAPL	Stock	63.3	63.5	63.0275	63.155	41628.0
2020-03-27 05:30:00	AAPL	Stock	63.0825	63.2225	63.0	63.0	18112.0
2020-03-27 06:00:00	AAPL	Stock	63.0	63.1225	62.83	63.0	25732.0
2020-03-27 06:30:00	AAPL	Stock	62.95	63.3275	62.825	62.825	53276.0
2020-03-27 07:00:00	AAPL	Stock	62.9375	63.6125	62.83	63.1875	442984.0
2020-03-27 07:30:00	AAPL	Stock	63.2	63.5	62.95	63.075	229556.0
2020-03-27 08:00:00	AAPL	Stock	63.45	63.5875	62.825	63.26	553356.0
2020-03-27 08:30:00	AAPL	Stock	63.3	63.44	62.9125	63.0025	345148.0
2020-03-27 09:00:00	AAPL	Stock	63.0	63.33	62.815	63.21	318728.0
2020-03-27 09:30:00	AAPL	Stock	63.1875	63.335	62.095	62.716	24034176.0
2020-03-27 10:00:00	AAPL	Stock	62.7225	62.7975	62.1725	62.3575	12232072.0
2020-03-27 10:30:00	AAPL	Stock	62.36	62.5975	62.2075	62.425	7576744.0
2020-03-27 11:00:00	AAPL	Stock	62.43	63.03	62.43	62.8315	9717456.0
2020-03-27 11:30:00	AAPL	Stock	62.82	62.9225	62.47	62.5	6466896.0
2020-03-27 12:00:00	AAPL	Stock	62.4975	62.6025	62.25	62.48	7534132.0
2020-03-27 12:30:00	AAPL	Stock	62.4725	62.8625	62.4275	62.7592	7290288.0
2020-03-27 13:00:00	AAPL	Stock	62.7775	63.05	62.6125	62.8478	7716724.0
2020-03-27 13:30:00	AAPL	Stock	62.865	63.66	62.79	63.3425	12233636.0
2020-03-27 14:00:00	AAPL	Stock	63.3475	63.4275	62.93	63.2725	8285564.0
2020-03-27 14:30:00	AAPL	Stock	63.2812	63.49	63.075	63.43	6616536.0
2020-03-27 15:00:00	AAPL	Stock	63.426	63.9675	63.335	63.7975	13078196.0
2020-03-27 15:30:00	AAPL	Stock	63.79	63.82	61.7625	61.905	27666808.0
2020-03-27 16:00:00	AAPL	Stock	61.9325	62.7155	61.75	61.875	18272124.0
2020-03-27 16:30:00	AAPL	Stock	61.84	61.935	61.7575	61.9075	268380.0
2020-03-27 17:00:00	AAPL	Stock	61.9075	61.9875	61.8575	61.9625	104732.0
2020-03-27 17:30:00	AAPL	Stock	61.9625	61.9975	61.85	61.9975	54472.0
2020-03-27 18:00:00	AAPL	Stock	61.9975	62.0	61.825	61.8525	45088.0
2020-03-27 18:30:00	AAPL	Stock	61.8625	61.8725	61.825	61.8725	19940.0
2020-03-27 19:00:00	AAPL	Stock	61.8675	61.8725	61.7775	61.7875	42068.0
2020-03-27 19:30:00	AAPL	Stock	61.7825	61.825	61.75	61.75	53004.0
2020-03-27 04:00:00	MSFT	Stock	153.38	153.82	153.0	153.2	4756.0
2020-03-27 04:30:00	MSFT	Stock	153.0	153.31	152.8	153.0	3667.0
2020-03-27 05:00:00	MSFT	Stock	152.99	153.0	152.5	152.5	4356.0
2020-03-27 05:30:00	MSFT	Stock	152.18	152.5	151.75	151.75	2954.0
2020-03-27 06:00:00	MSFT	Stock	151.76	152.01	151.21	151.89	2725.0
2020-03-27 06:30:00	MSFT	Stock	151.93	153.2	151.23	151.4	16266.0
2020-03-27 07:00:00	MSFT	Stock	151.98	152.9	151.5	151.61	51734.0
2020-03-27 07:30:00	MSFT	Stock	151.7	152.05	151.04	151.31	54011.0
2020-03-27 08:00:00	MSFT	Stock	152.25	152.8	151.0	152.02	91567.0
2020-03-27 08:30:00	MSFT	Stock	152.05	152.5	151.31	151.31	78916.0
2020-03-27 09:00:00	MSFT	Stock	151.37	152.0	150.72	151.68	124327.0
2020-03-27 09:30:00	MSFT	Stock	151.75	152.31	149.25	150.26	7569216.0
2020-03-27 10:00:00	MSFT	Stock	150.29	151.3	149.2	149.938	3452700.0
2020-03-27 10:30:00	MSFT	Stock	149.96	150.89	149.89	150.58	2344778.0
2020-03-27 11:00:00	MSFT	Stock	150.57	153.12	150.55	152.24	2619263.0
2020-03-27 11:30:00	MSFT	Stock	152.22	152.66	151.27	151.3	1846702.0
2020-03-27 12:00:00	MSFT	Stock	151.28	151.78	150.61	151.33	1707543.0
2020-03-27 12:30:00	MSFT	Stock	151.36	152.42	151.1	152.2	1606035.0

> showing 50 of 93,056 rows — these rows as CSV

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