PREVIEW / stock_30min / 2020-07-09

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-07-09.parquet
  size:    1.9 MB
  rows:    96,988
  symbols: 2,428

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-07-09 04:00:00	AAPL	Stock	95.695	95.725	95.6925	95.695	8472.0
2020-07-09 04:30:00	AAPL	Stock	95.7475	95.795	95.7475	95.75	18696.0
2020-07-09 05:00:00	AAPL	Stock	95.7625	95.8975	95.7375	95.775	27536.0
2020-07-09 05:30:00	AAPL	Stock	95.79	96.24	95.7775	96.2175	28412.0
2020-07-09 06:00:00	AAPL	Stock	96.205	96.225	96.125	96.175	15548.0
2020-07-09 06:30:00	AAPL	Stock	96.1875	96.19	95.905	95.9325	38284.0
2020-07-09 07:00:00	AAPL	Stock	95.9825	96.2175	95.9325	96.2125	210320.0
2020-07-09 07:30:00	AAPL	Stock	96.18	96.1925	96.1225	96.125	88968.0
2020-07-09 08:00:00	AAPL	Stock	96.1808	96.2175	95.58	96.1782	263384.0
2020-07-09 08:30:00	AAPL	Stock	96.2	96.3475	96.175	96.21	327512.0
2020-07-09 09:00:00	AAPL	Stock	96.205	96.34	96.1757	96.2725	251512.0
2020-07-09 09:30:00	AAPL	Stock	96.2625	98.4775	95.575	96.0575	15291424.0
2020-07-09 10:00:00	AAPL	Stock	96.0625	96.2	95.71	96.0675	7568108.0
2020-07-09 10:30:00	AAPL	Stock	96.0788	96.1365	94.905	94.9235	9696956.0
2020-07-09 11:00:00	AAPL	Stock	94.9175	95.31	94.6725	95.11	8924144.0
2020-07-09 11:30:00	AAPL	Stock	95.125	95.4225	94.9598	95.3412	5186272.0
2020-07-09 12:00:00	AAPL	Stock	95.3175	95.745	95.25	95.6065	5683316.0
2020-07-09 12:30:00	AAPL	Stock	95.5925	95.8118	95.5112	95.725	3772880.0
2020-07-09 13:00:00	AAPL	Stock	95.725	95.875	95.63	95.7075	3908788.0
2020-07-09 13:30:00	AAPL	Stock	95.725	95.7875	95.2875	95.3675	4136232.0
2020-07-09 14:00:00	AAPL	Stock	95.3692	95.7625	95.295	95.655	4134200.0
2020-07-09 14:30:00	AAPL	Stock	95.6575	95.725	95.535	95.69	3361180.0
2020-07-09 15:00:00	AAPL	Stock	95.68	96.035	95.215	95.2562	7111120.0
2020-07-09 15:30:00	AAPL	Stock	95.25	95.825	95.0	95.665	12274916.0
2020-07-09 16:00:00	AAPL	Stock	95.6625	95.7875	95.63	95.6525	5440248.0
2020-07-09 16:30:00	AAPL	Stock	95.65	95.7	95.6275	95.65	43608.0
2020-07-09 17:00:00	AAPL	Stock	95.6375	95.6875	95.6125	95.6125	28012.0
2020-07-09 17:30:00	AAPL	Stock	95.625	95.625	95.525	95.5625	20784.0
2020-07-09 18:00:00	AAPL	Stock	95.565	95.675	95.53	95.675	40720.0
2020-07-09 18:30:00	AAPL	Stock	95.6975	95.6975	95.6275	95.6275	13008.0
2020-07-09 19:00:00	AAPL	Stock	95.64	95.7125	95.64	95.7125	15568.0
2020-07-09 19:30:00	AAPL	Stock	95.7125	95.875	95.7125	95.8725	108280.0
2020-07-09 04:00:00	MSFT	Stock	213.88	214.2	213.8	213.9	5276.0
2020-07-09 04:30:00	MSFT	Stock	213.85	214.0	213.85	213.85	2758.0
2020-07-09 05:00:00	MSFT	Stock	213.86	214.0	213.75	213.95	1309.0
2020-07-09 05:30:00	MSFT	Stock	214.0	214.6	214.0	214.55	6125.0
2020-07-09 06:00:00	MSFT	Stock	214.6	214.95	214.6	214.67	4049.0
2020-07-09 06:30:00	MSFT	Stock	214.88	214.9	214.06	214.24	7801.0
2020-07-09 07:00:00	MSFT	Stock	214.4	214.69	214.1	214.68	36237.0
2020-07-09 07:30:00	MSFT	Stock	214.7	215.86	214.7	215.66	53971.0
2020-07-09 08:00:00	MSFT	Stock	214.55	215.9	214.25	215.45	58662.0
2020-07-09 08:30:00	MSFT	Stock	215.53	216.25	215.46	215.78	84587.0
2020-07-09 09:00:00	MSFT	Stock	215.8	216.4	215.6	216.37	77799.0
2020-07-09 09:30:00	MSFT	Stock	216.33	216.39	214.406	215.62	4024174.0
2020-07-09 10:00:00	MSFT	Stock	215.64	215.72	213.64	214.46	2279639.0
2020-07-09 10:30:00	MSFT	Stock	214.46	214.72	211.93	212.04	2378292.0
2020-07-09 11:00:00	MSFT	Stock	212.02	213.11	211.47	212.17	1897036.0
2020-07-09 11:30:00	MSFT	Stock	212.16	212.9	211.72	212.79	1414748.0
2020-07-09 12:00:00	MSFT	Stock	212.78	213.985	212.54	213.47	1546931.0
2020-07-09 12:30:00	MSFT	Stock	213.45	214.18	213.223	213.648	1038818.0

> showing 50 of 96,988 rows — these rows as CSV

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