PREVIEW / stock_30min / 2008-01-29

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-01-29.parquet
  size:    1.2 MB
  rows:    70,122
  symbols: 3,262

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-01-29 04:00:00	AAPL	Stock	4.6518	4.6518	4.6518	4.6518	2800.0
2008-01-29 05:00:00	AAPL	Stock	4.6661	4.6661	4.6661	4.6661	2800.0
2008-01-29 05:30:00	AAPL	Stock	4.6789	4.6789	4.6789	4.6789	25200.0
2008-01-29 06:00:00	AAPL	Stock	4.6929	4.7064	4.6929	4.7064	126000.0
2008-01-29 06:30:00	AAPL	Stock	4.7018	4.7079	4.7004	4.7054	33768.0
2008-01-29 07:00:00	AAPL	Stock	4.7054	4.71	4.6754	4.6893	471716.0
2008-01-29 07:30:00	AAPL	Stock	4.6839	4.6839	4.6625	4.6711	203224.0
2008-01-29 08:00:00	AAPL	Stock	4.7071	4.7071	4.6439	4.6571	1929228.0
2008-01-29 08:30:00	AAPL	Stock	4.6564	4.6811	4.6521	4.675	3586800.0
2008-01-29 09:00:00	AAPL	Stock	4.6707	4.71	4.6696	4.6821	5963832.0
2008-01-29 09:30:00	AAPL	Stock	4.6846	4.7425	4.6429	4.6957	168304192.0
2008-01-29 10:00:00	AAPL	Stock	4.6954	4.7371	4.6643	4.7118	136823736.0
2008-01-29 10:30:00	AAPL	Stock	4.7125	4.7254	4.6832	4.6921	80120572.0
2008-01-29 11:00:00	AAPL	Stock	4.6921	4.7161	4.6889	4.6964	56720272.0
2008-01-29 11:30:00	AAPL	Stock	4.6968	4.7089	4.6739	4.6871	60567584.0
2008-01-29 12:00:00	AAPL	Stock	4.6864	4.6882	4.6496	4.66	51596244.0
2008-01-29 12:30:00	AAPL	Stock	4.6607	4.6657	4.6264	4.6389	68345564.0
2008-01-29 13:00:00	AAPL	Stock	4.6389	4.6571	4.625	4.6464	50063356.0
2008-01-29 13:30:00	AAPL	Stock	4.6475	4.6693	4.6325	4.6432	54202568.0
2008-01-29 14:00:00	AAPL	Stock	4.6429	4.6618	4.6089	4.6557	77891380.0
2008-01-29 14:30:00	AAPL	Stock	4.6568	4.6839	4.635	4.6736	72856588.0
2008-01-29 15:00:00	AAPL	Stock	4.6732	4.7143	4.6732	4.7043	89900272.0
2008-01-29 15:30:00	AAPL	Stock	4.7043	4.7089	4.6818	4.6964	87249652.0
2008-01-29 16:00:00	AAPL	Stock	4.6969	4.7071	4.6825	4.6979	19062848.0
2008-01-29 16:30:00	AAPL	Stock	4.6929	4.7007	4.6643	4.6754	2785552.0
2008-01-29 17:00:00	AAPL	Stock	4.6754	4.6979	4.6702	4.6768	10484936.0
2008-01-29 17:30:00	AAPL	Stock	4.6782	4.6839	4.6782	4.6786	283080.0
2008-01-29 18:00:00	AAPL	Stock	4.6786	4.6979	4.6786	4.6857	106036.0
2008-01-29 18:30:00	AAPL	Stock	4.6857	4.6857	4.6796	4.6804	30576.0
2008-01-29 19:00:00	AAPL	Stock	4.6821	4.6854	4.6746	4.6854	203084.0
2008-01-29 19:30:00	AAPL	Stock	4.6821	4.6832	4.6789	4.6807	110432.0
2008-01-29 07:00:00	MSFT	Stock	32.72	32.72	32.72	32.72	1000.0
2008-01-29 07:30:00	MSFT	Stock	32.9	32.9	32.9	32.9	500.0
2008-01-29 08:00:00	MSFT	Stock	32.8	32.8	32.77	32.8	16177.0
2008-01-29 08:30:00	MSFT	Stock	32.8	32.89	32.74	32.8	34639.0
2008-01-29 09:00:00	MSFT	Stock	32.82	32.87	32.8	32.85	66435.0
2008-01-29 09:30:00	MSFT	Stock	32.85	32.89	32.49	32.508	8189238.0
2008-01-29 10:00:00	MSFT	Stock	32.51	32.84	32.42	32.81	7684538.0
2008-01-29 10:30:00	MSFT	Stock	32.81	32.82	32.56	32.6	4064120.0
2008-01-29 11:00:00	MSFT	Stock	32.59	32.7	32.56	32.63	4016724.0
2008-01-29 11:30:00	MSFT	Stock	32.63	32.69	32.6	32.65	1980332.0
2008-01-29 12:00:00	MSFT	Stock	32.65	32.655	32.5	32.512	2580560.0
2008-01-29 12:30:00	MSFT	Stock	32.51	32.56	32.45	32.495	2646262.0
2008-01-29 13:00:00	MSFT	Stock	32.49	32.56	32.43	32.52	2780078.0
2008-01-29 13:30:00	MSFT	Stock	32.52	32.57	32.43	32.46	2976621.0
2008-01-29 14:00:00	MSFT	Stock	32.46	32.55	32.43	32.51	3520261.0
2008-01-29 14:30:00	MSFT	Stock	32.5	32.67	32.4	32.557	4632156.0
2008-01-29 15:00:00	MSFT	Stock	32.56	32.73	32.535	32.59	5040493.0
2008-01-29 15:30:00	MSFT	Stock	32.585	32.62	32.35	32.62	11538450.0
2008-01-29 16:00:00	MSFT	Stock	32.62	32.71	32.523	32.6	6200478.0

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

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