PREVIEW / stock_30min / 2008-02-29

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-02-29.parquet
  size:    1.2 MB
  rows:    70,208
  symbols: 3,266

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
2008-02-29 05:00:00	AAPL	Stock	4.625	4.625	4.625	4.625	6580.0
2008-02-29 05:30:00	AAPL	Stock	4.6071	4.6071	4.6071	4.6071	5600.0
2008-02-29 06:30:00	AAPL	Stock	4.5932	4.5932	4.5932	4.5932	28000.0
2008-02-29 07:00:00	AAPL	Stock	4.5932	4.6043	4.5818	4.6	229600.0
2008-02-29 07:30:00	AAPL	Stock	4.6043	4.6043	4.5821	4.5964	270172.0
2008-02-29 08:00:00	AAPL	Stock	4.5921	4.6071	4.5821	4.5964	2799944.0
2008-02-29 08:30:00	AAPL	Stock	4.5975	4.6136	4.5964	4.6071	2170196.0
2008-02-29 09:00:00	AAPL	Stock	4.6071	4.6396	4.5921	4.6146	2762060.0
2008-02-29 09:30:00	AAPL	Stock	4.6157	4.6504	4.5875	4.6275	162456084.0
2008-02-29 10:00:00	AAPL	Stock	4.6277	4.6286	4.3171	4.5429	177515968.0
2008-02-29 10:30:00	AAPL	Stock	4.5432	4.5554	4.5268	4.5479	112944412.0
2008-02-29 11:00:00	AAPL	Stock	4.5479	4.5539	4.53	4.5379	67497976.0
2008-02-29 11:30:00	AAPL	Stock	4.5379	4.56	4.5271	4.5311	55509188.0
2008-02-29 12:00:00	AAPL	Stock	4.5311	4.5418	4.5118	4.5339	61687276.0
2008-02-29 12:30:00	AAPL	Stock	4.5346	4.5393	4.5207	4.5346	40959324.0
2008-02-29 13:00:00	AAPL	Stock	4.5339	4.56	4.53	4.5334	62446888.0
2008-02-29 13:30:00	AAPL	Stock	4.5334	4.5393	4.5125	4.5139	66935848.0
2008-02-29 14:00:00	AAPL	Stock	4.5136	4.5186	4.4857	4.4982	79229052.0
2008-02-29 14:30:00	AAPL	Stock	4.4975	4.5332	4.4893	4.5132	76367424.0
2008-02-29 15:00:00	AAPL	Stock	4.5136	4.5214	4.4771	4.4964	92355312.0
2008-02-29 15:30:00	AAPL	Stock	4.4968	4.4996	4.4571	4.4712	146335028.0
2008-02-29 16:00:00	AAPL	Stock	4.4704	4.5372	4.4643	4.475	31662708.0
2008-02-29 16:30:00	AAPL	Stock	4.475	4.4897	4.4646	4.4743	3807020.0
2008-02-29 17:00:00	AAPL	Stock	4.4743	4.5383	4.465	4.4732	2291660.0
2008-02-29 17:30:00	AAPL	Stock	4.4721	4.4786	4.465	4.4786	8536024.0
2008-02-29 18:00:00	AAPL	Stock	4.4768	4.4768	4.4696	4.4718	173320.0
2008-02-29 18:30:00	AAPL	Stock	4.4714	4.4732	4.4696	4.4696	94332.0
2008-02-29 19:00:00	AAPL	Stock	4.4686	4.4725	4.4686	4.4707	45864.0
2008-02-29 19:30:00	AAPL	Stock	4.4707	4.4714	4.4643	4.4643	239288.0
2008-02-29 05:00:00	MSFT	Stock	27.68	27.68	27.68	27.68	100.0
2008-02-29 08:00:00	MSFT	Stock	27.83	27.83	27.72	27.72	12434.0
2008-02-29 08:30:00	MSFT	Stock	27.75	27.8	27.73	27.8	9131.0
2008-02-29 09:00:00	MSFT	Stock	27.8	27.93	27.64	27.66	269229.0
2008-02-29 09:30:00	MSFT	Stock	27.65	27.83	27.55	27.61	13008584.0
2008-02-29 10:00:00	MSFT	Stock	27.61	27.64	27.19	27.25	18884844.0
2008-02-29 10:30:00	MSFT	Stock	27.25	27.42	27.23	27.37	7888601.0
2008-02-29 11:00:00	MSFT	Stock	27.37	27.46	27.3	27.43	4916341.0
2008-02-29 11:30:00	MSFT	Stock	27.43	27.48	27.4	27.43	3472120.0
2008-02-29 12:00:00	MSFT	Stock	27.43	27.49	27.38	27.44	3391927.0
2008-02-29 12:30:00	MSFT	Stock	27.44	27.46	27.36	27.41	3978430.0
2008-02-29 13:00:00	MSFT	Stock	27.4	27.45	27.37	27.41	4402573.0
2008-02-29 13:30:00	MSFT	Stock	27.4	27.41	27.3	27.3	6187742.0
2008-02-29 14:00:00	MSFT	Stock	27.3	27.33	27.21	27.23	5328638.0
2008-02-29 14:30:00	MSFT	Stock	27.24	27.26	27.12	27.19	9012774.0
2008-02-29 15:00:00	MSFT	Stock	27.2	27.2	27.02	27.11	9392582.0
2008-02-29 15:30:00	MSFT	Stock	27.118	27.24	27.03	27.22	16055023.0
2008-02-29 16:00:00	MSFT	Stock	27.199	27.34	27.16	27.2	9068409.0
2008-02-29 16:30:00	MSFT	Stock	27.22	27.25	27.09	27.25	461833.0
2008-02-29 17:00:00	MSFT	Stock	27.24	27.341	27.2	27.23	1645348.0
2008-02-29 17:30:00	MSFT	Stock	27.23	27.25	27.21	27.21	8000.0

> showing 50 of 70,208 rows — these rows as CSV

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