PREVIEW / stock_1hour / 2008-02-29

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-02-29.parquet
  size:    822 KB
  rows:    40,722
  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.6071	4.6071	12180.0
2008-02-29 06:00: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.5964	499772.0
2008-02-29 08:00:00	AAPL	Stock	4.5921	4.6136	4.5821	4.6071	4970140.0
2008-02-29 09:00:00	AAPL	Stock	4.6071	4.6504	4.5875	4.6275	165218144.0
2008-02-29 10:00:00	AAPL	Stock	4.6277	4.6286	4.3171	4.5479	290460380.0
2008-02-29 11:00:00	AAPL	Stock	4.5479	4.56	4.5271	4.5311	123007164.0
2008-02-29 12:00:00	AAPL	Stock	4.5311	4.5418	4.5118	4.5346	102646600.0
2008-02-29 13:00:00	AAPL	Stock	4.5339	4.56	4.5125	4.5139	129382736.0
2008-02-29 14:00:00	AAPL	Stock	4.5136	4.5332	4.4857	4.5132	155596476.0
2008-02-29 15:00:00	AAPL	Stock	4.5136	4.5214	4.4571	4.4712	238690340.0
2008-02-29 16:00:00	AAPL	Stock	4.4704	4.5372	4.4643	4.4743	35469728.0
2008-02-29 17:00:00	AAPL	Stock	4.4743	4.5383	4.465	4.4786	10827684.0
2008-02-29 18:00:00	AAPL	Stock	4.4768	4.4768	4.4696	4.4696	267652.0
2008-02-29 19:00:00	AAPL	Stock	4.4686	4.4725	4.4643	4.4643	285152.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.8	21565.0
2008-02-29 09:00:00	MSFT	Stock	27.8	27.93	27.55	27.61	13277813.0
2008-02-29 10:00:00	MSFT	Stock	27.61	27.64	27.19	27.37	26773445.0
2008-02-29 11:00:00	MSFT	Stock	27.37	27.48	27.3	27.43	8388461.0
2008-02-29 12:00:00	MSFT	Stock	27.43	27.49	27.36	27.41	7370357.0
2008-02-29 13:00:00	MSFT	Stock	27.4	27.45	27.3	27.3	10590315.0
2008-02-29 14:00:00	MSFT	Stock	27.3	27.33	27.12	27.19	14341412.0
2008-02-29 15:00:00	MSFT	Stock	27.2	27.24	27.02	27.22	25447605.0
2008-02-29 16:00:00	MSFT	Stock	27.199	27.34	27.09	27.25	9530242.0
2008-02-29 17:00:00	MSFT	Stock	27.24	27.341	27.2	27.21	1653348.0
2008-02-29 18:00:00	MSFT	Stock	27.25	27.25	27.22	27.22	2874.0
2008-02-29 19:00:00	MSFT	Stock	27.25	27.25	27.18	27.18	14820.0
2008-02-29 07:00:00	NVDA	Stock	0.5462	0.5462	0.5462	0.5462	4000.0
2008-02-29 08:00:00	NVDA	Stock	0.546	0.5488	0.5407	0.5488	276000.0
2008-02-29 09:00:00	NVDA	Stock	0.543	0.5498	0.5375	0.5468	59066320.0
2008-02-29 10:00:00	NVDA	Stock	0.5468	0.548	0.5332	0.5358	79324120.0
2008-02-29 11:00:00	NVDA	Stock	0.5358	0.5407	0.535	0.5372	40633520.0
2008-02-29 12:00:00	NVDA	Stock	0.537	0.5418	0.5355	0.5402	45807800.0
2008-02-29 13:00:00	NVDA	Stock	0.5405	0.5438	0.5365	0.537	72238360.0
2008-02-29 14:00:00	NVDA	Stock	0.5372	0.54	0.5338	0.5365	62010680.0
2008-02-29 15:00:00	NVDA	Stock	0.5365	0.5392	0.5325	0.536	129322400.0
2008-02-29 16:00:00	NVDA	Stock	0.5352	0.5379	0.5312	0.5348	27934080.0
2008-02-29 17:00:00	NVDA	Stock	0.5348	0.538	0.5348	0.5367	4383320.0
2008-02-29 18:00:00	NVDA	Stock	0.5362	0.5362	0.5362	0.5362	4000.0
2008-02-29 19:00:00	NVDA	Stock	0.5367	0.5367	0.5367	0.5367	4000.0
2008-02-29 07:00:00	AMZN	Stock	3.351	3.351	3.35	3.351	8000.0
2008-02-29 08:00:00	AMZN	Stock	3.352	3.3585	3.3325	3.345	289100.0
2008-02-29 09:00:00	AMZN	Stock	3.345	3.3925	3.295	3.306	30337100.0
2008-02-29 10:00:00	AMZN	Stock	3.306	3.3175	3.2615	3.2875	41096780.0
2008-02-29 11:00:00	AMZN	Stock	3.289	3.3	3.2735	3.28	14101160.0
2008-02-29 12:00:00	AMZN	Stock	3.2805	3.295	3.2655	3.275	15086340.0
2008-02-29 13:00:00	AMZN	Stock	3.275	3.289	3.2165	3.2165	32776040.0
2008-02-29 14:00:00	AMZN	Stock	3.2165	3.245	3.204	3.221	35523100.0
2008-02-29 15:00:00	AMZN	Stock	3.221	3.243	3.1985	3.2255	53109680.0

> showing 50 of 40,722 rows — these rows as CSV

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