PREVIEW / stock_1hour / 2010-03-08

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-08.parquet
  size:    910 KB
  rows:    43,186
  symbols: 3,474

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-03-08 04:00:00	AAPL	Stock	7.8268	7.8539	7.8268	7.8539	25200.0
2010-03-08 05:00:00	AAPL	Stock	7.8411	7.8464	7.8411	7.8464	11200.0
2010-03-08 07:00:00	AAPL	Stock	7.8329	7.8464	7.8243	7.8464	326872.0
2010-03-08 08:00:00	AAPL	Stock	7.8446	7.8893	7.8429	7.8593	7318360.0
2010-03-08 09:00:00	AAPL	Stock	7.8579	7.8693	7.7946	7.8018	113340416.0
2010-03-08 10:00:00	AAPL	Stock	7.8007	7.8511	7.7986	7.8482	77384300.0
2010-03-08 11:00:00	AAPL	Stock	7.8489	7.8514	7.8168	7.8322	55185368.0
2010-03-08 12:00:00	AAPL	Stock	7.8318	7.8357	7.8179	7.8321	37014684.0
2010-03-08 13:00:00	AAPL	Stock	7.8318	7.84	7.8268	7.8336	29698900.0
2010-03-08 14:00:00	AAPL	Stock	7.8336	7.8357	7.8179	7.8246	32829636.0
2010-03-08 15:00:00	AAPL	Stock	7.8247	7.8296	7.8143	7.8225	68880868.0
2010-03-08 16:00:00	AAPL	Stock	7.8193	7.8309	7.8114	7.8189	5981612.0
2010-03-08 17:00:00	AAPL	Stock	7.8193	7.8307	7.8157	7.8196	314636.0
2010-03-08 18:00:00	AAPL	Stock	7.8196	7.8411	7.8175	7.8211	112560.0
2010-03-08 19:00:00	AAPL	Stock	7.8204	7.8204	7.8057	7.8125	282828.0
2010-03-08 07:00:00	MSFT	Stock	28.67	28.67	28.65	28.65	1259.0
2010-03-08 08:00:00	MSFT	Stock	28.61	28.65	28.56	28.56	43373.0
2010-03-08 09:00:00	MSFT	Stock	28.57	28.78	28.5	28.78	4744909.0
2010-03-08 10:00:00	MSFT	Stock	28.78	28.93	28.76	28.845	8544173.0
2010-03-08 11:00:00	MSFT	Stock	28.84	28.85	28.67	28.675	7973745.0
2010-03-08 12:00:00	MSFT	Stock	28.675	28.788	28.62	28.76	2924057.0
2010-03-08 13:00:00	MSFT	Stock	28.76	28.8	28.73	28.748	3344846.0
2010-03-08 14:00:00	MSFT	Stock	28.75	28.77	28.66	28.68	3453961.0
2010-03-08 15:00:00	MSFT	Stock	28.68	28.72	28.61	28.63	5745262.0
2010-03-08 16:00:00	MSFT	Stock	28.63	28.75	28.61	28.719	895408.0
2010-03-08 17:00:00	MSFT	Stock	28.64	28.66	28.63	28.64	23975.0
2010-03-08 18:00:00	MSFT	Stock	28.64	28.65	28.63	28.63	1175.0
2010-03-08 19:00:00	MSFT	Stock	28.6	28.64	28.6	28.62	6480.0
2010-03-08 08:00:00	NVDA	Stock	0.438	0.438	0.432	0.4332	340640.0
2010-03-08 09:00:00	NVDA	Stock	0.4312	0.4318	0.4268	0.427	40277680.0
2010-03-08 10:00:00	NVDA	Stock	0.427	0.427	0.4241	0.4242	66283840.0
2010-03-08 11:00:00	NVDA	Stock	0.4243	0.4265	0.4238	0.4242	81443320.0
2010-03-08 12:00:00	NVDA	Stock	0.4241	0.4242	0.4222	0.4238	47692040.0
2010-03-08 13:00:00	NVDA	Stock	0.4239	0.4253	0.4238	0.4251	48813120.0
2010-03-08 14:00:00	NVDA	Stock	0.425	0.4255	0.4225	0.4228	53927520.0
2010-03-08 15:00:00	NVDA	Stock	0.4225	0.424	0.4213	0.4232	88748720.0
2010-03-08 16:00:00	NVDA	Stock	0.4232	0.4302	0.4188	0.4249	8429640.0
2010-03-08 17:00:00	NVDA	Stock	0.424	0.424	0.424	0.424	12000.0
2010-03-08 18:00:00	NVDA	Stock	0.4235	0.4235	0.4235	0.4235	2906520.0
2010-03-08 19:00:00	NVDA	Stock	0.4228	0.4228	0.4205	0.4205	40000.0
2010-03-08 05:00:00	AMZN	Stock	6.4485	6.4485	6.4485	6.4485	2000.0
2010-03-08 07:00:00	AMZN	Stock	6.4625	6.4625	6.4625	6.4625	4000.0
2010-03-08 08:00:00	AMZN	Stock	6.455	6.462	6.3995	6.405	225440.0
2010-03-08 09:00:00	AMZN	Stock	6.403	6.4315	6.3825	6.4075	18675920.0
2010-03-08 10:00:00	AMZN	Stock	6.4075	6.4775	6.4	6.4645	21507760.0
2010-03-08 11:00:00	AMZN	Stock	6.465	6.4865	6.448	6.482	13590840.0
2010-03-08 12:00:00	AMZN	Stock	6.483	6.4955	6.47	6.48	8812680.0
2010-03-08 13:00:00	AMZN	Stock	6.48	6.498	6.48	6.4958	6026980.0
2010-03-08 14:00:00	AMZN	Stock	6.4955	6.5425	6.4915	6.5216	21319600.0
2010-03-08 15:00:00	AMZN	Stock	6.5225	6.5315	6.5055	6.5055	19319100.0

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

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