PREVIEW / stock_30min / 2009-01-14

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-01-14.parquet
  size:    1.2 MB
  rows:    69,864
  symbols: 3,315

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
2009-01-14 07:30:00	AAPL	Stock	3.1125	3.1125	3.1029	3.1029	11200.0
2009-01-14 08:00:00	AAPL	Stock	3.1061	3.1071	3.0921	3.0975	351036.0
2009-01-14 08:30:00	AAPL	Stock	3.0943	3.0975	3.0771	3.0775	625828.0
2009-01-14 09:00:00	AAPL	Stock	3.0775	3.0886	3.0714	3.0836	984592.0
2009-01-14 09:30:00	AAPL	Stock	3.085	3.1161	3.0686	3.0811	92083936.0
2009-01-14 10:00:00	AAPL	Stock	3.0811	3.0921	3.0593	3.0671	72930900.0
2009-01-14 10:30:00	AAPL	Stock	3.0675	3.0714	3.0489	3.0646	64926568.0
2009-01-14 11:00:00	AAPL	Stock	3.0646	3.0668	3.0521	3.0629	46715592.0
2009-01-14 11:30:00	AAPL	Stock	3.0629	3.0832	3.0589	3.0786	45536120.0
2009-01-14 12:00:00	AAPL	Stock	3.0786	3.0845	3.0636	3.0668	33553772.0
2009-01-14 12:30:00	AAPL	Stock	3.0671	3.0693	3.0536	3.0646	34192564.0
2009-01-14 13:00:00	AAPL	Stock	3.0643	3.0646	3.0386	3.0396	46852204.0
2009-01-14 13:30:00	AAPL	Stock	3.04	3.0486	3.0357	3.0382	50427188.0
2009-01-14 14:00:00	AAPL	Stock	3.0382	3.0496	3.0275	3.0496	74069380.0
2009-01-14 14:30:00	AAPL	Stock	3.0493	3.0679	3.0482	3.0511	56295960.0
2009-01-14 15:00:00	AAPL	Stock	3.0511	3.0511	3.0282	3.0376	69428940.0
2009-01-14 15:30:00	AAPL	Stock	3.0375	3.0643	3.0257	3.0482	111084624.0
2009-01-14 16:00:00	AAPL	Stock	3.0479	3.0729	3.045	3.0475	15857716.0
2009-01-14 16:30:00	AAPL	Stock	3.0475	3.0572	3.0475	3.0572	6450696.0
2009-01-14 17:00:00	AAPL	Stock	2.8468	2.8536	2.7182	2.8475	165865168.0
2009-01-14 17:30:00	AAPL	Stock	2.8464	2.8661	2.8354	2.8625	33063688.0
2009-01-14 18:00:00	AAPL	Stock	2.8639	3.0475	2.8464	2.85	30718100.0
2009-01-14 18:30:00	AAPL	Stock	2.8514	2.8546	2.8393	2.8418	4690868.0
2009-01-14 19:00:00	AAPL	Stock	2.8414	2.8464	2.8221	2.8261	4261852.0
2009-01-14 19:30:00	AAPL	Stock	2.8261	2.8339	2.8232	2.8321	2764832.0
2009-01-14 08:00:00	MSFT	Stock	19.65	19.67	19.62	19.63	3850.0
2009-01-14 08:30:00	MSFT	Stock	19.62	19.66	19.53	19.56	15780.0
2009-01-14 09:00:00	MSFT	Stock	19.56	19.64	19.5	19.51	66378.0
2009-01-14 09:30:00	MSFT	Stock	19.52	19.68	19.27	19.47	6334743.0
2009-01-14 10:00:00	MSFT	Stock	19.47	19.52	19.28	19.31	5974987.0
2009-01-14 10:30:00	MSFT	Stock	19.32	19.32	19.03	19.12	6352486.0
2009-01-14 11:00:00	MSFT	Stock	19.12	19.19	19.03	19.16	5207303.0
2009-01-14 11:30:00	MSFT	Stock	19.16	19.18	19.04	19.1	6476286.0
2009-01-14 12:00:00	MSFT	Stock	19.11	19.11	19.03	19.04	4559192.0
2009-01-14 12:30:00	MSFT	Stock	19.04	19.12	19.01	19.11	4329661.0
2009-01-14 13:00:00	MSFT	Stock	19.119	19.47	19.04	19.048	5142426.0
2009-01-14 13:30:00	MSFT	Stock	19.048	19.14	19.03	19.1	2510687.0
2009-01-14 14:00:00	MSFT	Stock	19.11	19.2	19.08	19.2	4087136.0
2009-01-14 14:30:00	MSFT	Stock	19.2	19.35	19.19	19.26	5128758.0
2009-01-14 15:00:00	MSFT	Stock	19.25	19.26	19.01	19.04	7423389.0
2009-01-14 15:30:00	MSFT	Stock	19.04	19.232	19.02	19.1	11263025.0
2009-01-14 16:00:00	MSFT	Stock	19.1	19.36	19.055	19.15	3603175.0
2009-01-14 16:30:00	MSFT	Stock	19.09	19.174	19.04	19.04	872669.0
2009-01-14 17:00:00	MSFT	Stock	19.03	19.06	19.01	19.01	21750.0
2009-01-14 17:30:00	MSFT	Stock	19.01	19.07	19.01	19.01	12028.0
2009-01-14 18:00:00	MSFT	Stock	19.03	19.09	19.02	19.02	54172.0
2009-01-14 18:30:00	MSFT	Stock	19.04	19.19	19.02	19.04	3004.0
2009-01-14 19:00:00	MSFT	Stock	19.09	19.09	19.01	19.01	8700.0
2009-01-14 19:30:00	MSFT	Stock	19.12	19.12	19.0	19.0	9349.0
2009-01-14 08:00:00	NVDA	Stock	0.1875	0.1878	0.1875	0.1875	217200.0

> showing 50 of 69,864 rows — these rows as CSV

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