PREVIEW / stock_30min / 2020-06-22

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-06-22.parquet
  size:    2.0 MB
  rows:    99,389
  symbols: 2,431

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-06-22 04:00:00	AAPL	Stock	87.6	87.75	87.5025	87.55	8104.0
2020-06-22 04:30:00	AAPL	Stock	87.55	87.93	87.5	87.8875	15820.0
2020-06-22 05:00:00	AAPL	Stock	88.0325	88.1925	87.9375	87.9375	5040.0
2020-06-22 05:30:00	AAPL	Stock	88.005	88.0525	87.9625	87.9625	1600.0
2020-06-22 06:00:00	AAPL	Stock	87.875	87.875	87.75	87.75	5168.0
2020-06-22 06:30:00	AAPL	Stock	87.75	88.085	87.75	87.9225	26084.0
2020-06-22 07:00:00	AAPL	Stock	87.815	87.8875	87.5625	87.7475	155948.0
2020-06-22 07:30:00	AAPL	Stock	87.735	88.105	87.735	88.05	160532.0
2020-06-22 08:00:00	AAPL	Stock	87.5625	88.175	87.5525	88.1025	310876.0
2020-06-22 08:30:00	AAPL	Stock	88.1	88.119	87.8775	87.975	151288.0
2020-06-22 09:00:00	AAPL	Stock	87.965	88.0375	87.6775	87.875	303132.0
2020-06-22 09:30:00	AAPL	Stock	87.85	88.7825	87.7875	88.7375	16635472.0
2020-06-22 10:00:00	AAPL	Stock	88.7475	89.0525	88.665	88.7275	9306216.0
2020-06-22 10:30:00	AAPL	Stock	88.7325	88.85	88.6275	88.6362	5419244.0
2020-06-22 11:00:00	AAPL	Stock	88.6325	88.8825	88.4675	88.8303	5379560.0
2020-06-22 11:30:00	AAPL	Stock	88.83	89.0878	88.77	89.0125	4749432.0
2020-06-22 12:00:00	AAPL	Stock	89.0125	89.3525	89.0112	89.295	7161104.0
2020-06-22 12:30:00	AAPL	Stock	89.2972	89.35	89.1075	89.2775	4289492.0
2020-06-22 13:00:00	AAPL	Stock	89.28	89.42	89.2538	89.32	5946872.0
2020-06-22 13:30:00	AAPL	Stock	89.32	89.375	89.1425	89.245	5317176.0
2020-06-22 14:00:00	AAPL	Stock	89.24	89.385	89.105	89.365	5486664.0
2020-06-22 14:30:00	AAPL	Stock	89.3662	89.775	89.35	89.77	10163112.0
2020-06-22 15:00:00	AAPL	Stock	89.7702	89.805	89.31	89.425	9620892.0
2020-06-22 15:30:00	AAPL	Stock	89.4275	89.865	89.37	89.7325	11294304.0
2020-06-22 16:00:00	AAPL	Stock	89.735	90.055	89.6325	90.03	8297892.0
2020-06-22 16:30:00	AAPL	Stock	90.03	90.0825	89.885	89.9875	162056.0
2020-06-22 17:00:00	AAPL	Stock	90.0	90.07	89.9575	90.025	92464.0
2020-06-22 17:30:00	AAPL	Stock	90.0375	90.105	89.9525	90.0375	114784.0
2020-06-22 18:00:00	AAPL	Stock	90.005	90.19	90.005	90.19	91256.0
2020-06-22 18:30:00	AAPL	Stock	90.2	90.4025	90.0875	90.375	192292.0
2020-06-22 19:00:00	AAPL	Stock	90.3725	90.4	90.295	90.4	66692.0
2020-06-22 19:30:00	AAPL	Stock	90.4125	90.5625	90.375	90.55	105496.0
2020-06-22 04:00:00	MSFT	Stock	195.88	195.88	195.15	195.15	1571.0
2020-06-22 05:00:00	MSFT	Stock	196.4	196.9	196.26	196.33	3124.0
2020-06-22 05:30:00	MSFT	Stock	196.39	196.39	196.23	196.23	519.0
2020-06-22 06:00:00	MSFT	Stock	195.9	196.12	195.85	196.12	6670.0
2020-06-22 06:30:00	MSFT	Stock	196.12	196.2	195.51	195.58	2592.0
2020-06-22 07:00:00	MSFT	Stock	195.58	195.79	195.5	195.79	15526.0
2020-06-22 07:30:00	MSFT	Stock	195.7	196.3	195.7	196.3	16356.0
2020-06-22 08:00:00	MSFT	Stock	195.78	196.6	195.52	196.29	39863.0
2020-06-22 08:30:00	MSFT	Stock	196.1	196.3	195.8	195.83	27194.0
2020-06-22 09:00:00	MSFT	Stock	195.828	196.0	195.64	195.64	28169.0
2020-06-22 09:30:00	MSFT	Stock	195.6	196.9	195.23	196.89	3248544.0
2020-06-22 10:00:00	MSFT	Stock	196.9	198.33	196.9	197.442	2141622.0
2020-06-22 10:30:00	MSFT	Stock	197.445	198.18	197.34	197.87	1345987.0
2020-06-22 11:00:00	MSFT	Stock	197.87	198.19	197.61	198.01	1286161.0
2020-06-22 11:30:00	MSFT	Stock	198.02	199.2	197.78	199.01	1799496.0
2020-06-22 12:00:00	MSFT	Stock	199.0	199.8	199.0	199.53	2281146.0
2020-06-22 12:30:00	MSFT	Stock	199.514	199.8	199.23	199.48	1095146.0
2020-06-22 13:00:00	MSFT	Stock	199.53	199.68	198.85	199.07	908551.0

> showing 50 of 99,389 rows — these rows as CSV

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