PREVIEW / stock_1hour / 2010-04-01

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-04-01.parquet
  size:    915 KB
  rows:    43,718
  symbols: 3,466

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
2010-04-01 05:00:00	AAPL	Stock	8.4021	8.4368	8.4018	8.4368	53200.0
2010-04-01 06:00:00	AAPL	Stock	8.4354	8.4357	8.435	8.4357	36400.0
2010-04-01 07:00:00	AAPL	Stock	8.425	8.4614	8.4143	8.4543	407624.0
2010-04-01 08:00:00	AAPL	Stock	8.46	8.4743	8.3929	8.4675	5531008.0
2010-04-01 09:00:00	AAPL	Stock	8.4661	8.5261	8.4071	8.5021	116050648.0
2010-04-01 10:00:00	AAPL	Stock	8.5018	8.5107	8.4586	8.4713	82777436.0
2010-04-01 11:00:00	AAPL	Stock	8.4715	8.4739	8.4475	8.4697	47132708.0
2010-04-01 12:00:00	AAPL	Stock	8.4696	8.4782	8.4532	8.4675	29377236.0
2010-04-01 13:00:00	AAPL	Stock	8.4664	8.47	8.3893	8.4093	68146960.0
2010-04-01 14:00:00	AAPL	Stock	8.4082	8.4114	8.3125	8.3668	131739860.0
2010-04-01 15:00:00	AAPL	Stock	8.3668	8.4275	8.3586	8.4275	107956100.0
2010-04-01 16:00:00	AAPL	Stock	8.4275	8.4671	8.3694	8.425	10165036.0
2010-04-01 17:00:00	AAPL	Stock	8.4257	8.4279	8.3975	8.4268	766248.0
2010-04-01 18:00:00	AAPL	Stock	8.4271	8.4286	8.4218	8.4286	286356.0
2010-04-01 19:00:00	AAPL	Stock	8.4286	8.4321	8.425	8.4286	408268.0
2010-04-01 08:00:00	MSFT	Stock	29.43	29.48	29.4	29.43	28390.0
2010-04-01 09:00:00	MSFT	Stock	29.42	29.54	29.288	29.35	5533207.0
2010-04-01 10:00:00	MSFT	Stock	29.36	29.43	29.06	29.16	11758301.0
2010-04-01 11:00:00	MSFT	Stock	29.17	29.24	29.09	29.095	4851702.0
2010-04-01 12:00:00	MSFT	Stock	29.09	29.27	28.8	28.945	12083021.0
2010-04-01 13:00:00	MSFT	Stock	28.94	29.0	28.68	28.72	10249867.0
2010-04-01 14:00:00	MSFT	Stock	28.723	28.87	28.62	28.86	10165222.0
2010-04-01 15:00:00	MSFT	Stock	28.86	29.16	28.84	29.14	15252002.0
2010-04-01 16:00:00	MSFT	Stock	29.14	29.19	28.848	29.12	2856214.0
2010-04-01 17:00:00	MSFT	Stock	29.11	29.13	29.11	29.11	4522.0
2010-04-01 18:00:00	MSFT	Stock	29.13	29.16	29.13	29.13	9103.0
2010-04-01 19:00:00	MSFT	Stock	29.12	29.12	29.1	29.1	1950.0
2010-04-01 08:00:00	NVDA	Stock	0.435	0.438	0.435	0.438	792240.0
2010-04-01 09:00:00	NVDA	Stock	0.438	0.442	0.435	0.4395	48990720.0
2010-04-01 10:00:00	NVDA	Stock	0.4398	0.4412	0.437	0.4375	58262640.0
2010-04-01 11:00:00	NVDA	Stock	0.4378	0.438	0.435	0.4356	26587120.0
2010-04-01 12:00:00	NVDA	Stock	0.4355	0.4362	0.4318	0.4325	41628920.0
2010-04-01 13:00:00	NVDA	Stock	0.4325	0.4335	0.4282	0.4288	34333160.0
2010-04-01 14:00:00	NVDA	Stock	0.4288	0.4295	0.426	0.4285	46429520.0
2010-04-01 15:00:00	NVDA	Stock	0.4285	0.4305	0.4278	0.43	70953640.0
2010-04-01 16:00:00	NVDA	Stock	0.4305	0.4338	0.4285	0.431	7873720.0
2010-04-01 17:00:00	NVDA	Stock	0.4312	0.4322	0.4312	0.4322	52000.0
2010-04-01 18:00:00	NVDA	Stock	0.4322	0.4322	0.4322	0.4322	8000.0
2010-04-01 04:00:00	AMZN	Stock	6.797	6.797	6.7885	6.7885	29960.0
2010-04-01 07:00:00	AMZN	Stock	6.7825	6.7825	6.7825	6.7825	2000.0
2010-04-01 08:00:00	AMZN	Stock	6.8015	6.815	6.778	6.7875	303680.0
2010-04-01 09:00:00	AMZN	Stock	6.7835	6.8255	6.73	6.7765	17258440.0
2010-04-01 10:00:00	AMZN	Stock	6.7754	6.7895	6.735	6.7405	20772020.0
2010-04-01 11:00:00	AMZN	Stock	6.74	6.742	6.655	6.655	31474740.0
2010-04-01 12:00:00	AMZN	Stock	6.6545	6.687	6.6475	6.6598	16782100.0
2010-04-01 13:00:00	AMZN	Stock	6.6595	6.6628	6.573	6.5835	23122640.0
2010-04-01 14:00:00	AMZN	Stock	6.583	6.602	6.559	6.578	22383480.0
2010-04-01 15:00:00	AMZN	Stock	6.578	6.596	6.5645	6.5895	38421040.0
2010-04-01 16:00:00	AMZN	Stock	6.591	6.6557	6.5765	6.5985	1028180.0
2010-04-01 17:00:00	AMZN	Stock	6.5985	6.6	6.597	6.6	37560.0

> showing 50 of 43,718 rows — these rows as CSV

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