PREVIEW / stock_1hour / 2008-05-08

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-05-08.parquet
  size:    836 KB
  rows:    40,088
  symbols: 3,275

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-05-08 07:00:00	AAPL	Stock	6.5125	6.6071	6.5125	6.5718	1140636.0
2008-05-08 08:00:00	AAPL	Stock	6.57	6.5846	6.5393	6.5432	7327796.0
2008-05-08 09:00:00	AAPL	Stock	6.5436	6.6089	6.5382	6.59	130901008.0
2008-05-08 10:00:00	AAPL	Stock	6.5896	6.6061	6.5489	6.5761	184749488.0
2008-05-08 11:00:00	AAPL	Stock	6.5759	6.6279	6.5754	6.61	137965912.0
2008-05-08 12:00:00	AAPL	Stock	6.61	6.6254	6.5771	6.5996	73056340.0
2008-05-08 13:00:00	AAPL	Stock	6.5996	6.6607	6.5961	6.6529	104127828.0
2008-05-08 14:00:00	AAPL	Stock	6.6529	6.6571	6.5832	6.6039	105139328.0
2008-05-08 15:00:00	AAPL	Stock	6.6036	6.6225	6.5714	6.6064	120106924.0
2008-05-08 16:00:00	AAPL	Stock	6.6068	6.6096	6.5896	6.5954	22268736.0
2008-05-08 17:00:00	AAPL	Stock	6.595	6.6271	6.5896	6.5982	376544.0
2008-05-08 18:00:00	AAPL	Stock	6.5982	6.5982	6.5904	6.5929	284592.0
2008-05-08 19:00:00	AAPL	Stock	6.5943	6.5993	6.5921	6.5954	350224.0
2008-05-08 07:00:00	MSFT	Stock	29.24	29.39	29.23	29.39	3518.0
2008-05-08 08:00:00	MSFT	Stock	29.35	29.39	29.3	29.35	36802.0
2008-05-08 09:00:00	MSFT	Stock	29.36	29.39	29.11	29.3	9034889.0
2008-05-08 10:00:00	MSFT	Stock	29.3	29.35	29.2	29.25	9670020.0
2008-05-08 11:00:00	MSFT	Stock	29.252	29.27	29.0	29.05	10915963.0
2008-05-08 12:00:00	MSFT	Stock	29.06	29.18	29.01	29.16	4865275.0
2008-05-08 13:00:00	MSFT	Stock	29.16	29.34	29.13	29.338	6827909.0
2008-05-08 14:00:00	MSFT	Stock	29.33	29.35	29.045	29.23	10158051.0
2008-05-08 15:00:00	MSFT	Stock	29.22	29.32	29.19	29.24	14379912.0
2008-05-08 16:00:00	MSFT	Stock	29.24	29.33	29.2	29.212	2423117.0
2008-05-08 17:00:00	MSFT	Stock	29.22	29.24	29.17	29.198	7793.0
2008-05-08 18:00:00	MSFT	Stock	29.19	29.25	29.19	29.25	1201.0
2008-05-08 19:00:00	MSFT	Stock	29.22	29.22	29.2	29.2	698.0
2008-05-08 08:00:00	NVDA	Stock	0.5502	0.5555	0.5502	0.5555	490800.0
2008-05-08 09:00:00	NVDA	Stock	0.555	0.5562	0.5318	0.5325	140801080.0
2008-05-08 10:00:00	NVDA	Stock	0.5325	0.536	0.5253	0.5357	213546120.0
2008-05-08 11:00:00	NVDA	Stock	0.5355	0.539	0.5327	0.534	100413640.0
2008-05-08 12:00:00	NVDA	Stock	0.534	0.537	0.5311	0.537	86774120.0
2008-05-08 13:00:00	NVDA	Stock	0.537	0.539	0.5351	0.5385	97915240.0
2008-05-08 14:00:00	NVDA	Stock	0.5382	0.539	0.5342	0.5365	137202440.0
2008-05-08 15:00:00	NVDA	Stock	0.5367	0.5465	0.5362	0.5448	286844760.0
2008-05-08 16:00:00	NVDA	Stock	0.5452	0.5518	0.4985	0.5015	96910960.0
2008-05-08 17:00:00	NVDA	Stock	0.5025	0.5538	0.5003	0.5462	147204840.0
2008-05-08 18:00:00	NVDA	Stock	0.5475	0.5495	0.545	0.5458	6823200.0
2008-05-08 19:00:00	NVDA	Stock	0.5452	0.5462	0.5322	0.5332	2873080.0
2008-05-08 08:00:00	AMZN	Stock	3.6755	3.6755	3.6755	3.6755	8000.0
2008-05-08 09:00:00	AMZN	Stock	3.66	3.708	3.6575	3.6655	15857000.0
2008-05-08 10:00:00	AMZN	Stock	3.6645	3.6675	3.581	3.6165	46110080.0
2008-05-08 11:00:00	AMZN	Stock	3.6165	3.6425	3.6025	3.603	22399240.0
2008-05-08 12:00:00	AMZN	Stock	3.603	3.6115	3.578	3.6095	17132000.0
2008-05-08 13:00:00	AMZN	Stock	3.6104	3.664	3.6	3.661	17428300.0
2008-05-08 14:00:00	AMZN	Stock	3.6595	3.6605	3.618	3.624	17994200.0
2008-05-08 15:00:00	AMZN	Stock	3.6235	3.645	3.6185	3.6385	20377580.0
2008-05-08 16:00:00	AMZN	Stock	3.639	3.6778	3.617	3.6354	3987480.0
2008-05-08 17:00:00	AMZN	Stock	3.6147	3.6147	3.6147	3.6147	323100.0
2008-05-08 18:00:00	AMZN	Stock	3.631	3.631	3.631	3.631	2000.0
2008-05-08 19:00:00	AMZN	Stock	3.6525	3.6555	3.6525	3.6555	19000.0

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

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