PREVIEW / stock_1hour / 2008-07-23

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-07-23.parquet
  size:    844 KB
  rows:    40,383
  symbols: 3,341

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-07-23 07:00:00	AAPL	Stock	5.7893	5.9429	5.7889	5.9036	4516680.0
2008-07-23 08:00:00	AAPL	Stock	5.8929	5.9107	5.7864	5.8964	10445176.0
2008-07-23 09:00:00	AAPL	Stock	5.8982	5.9154	5.77	5.8486	171228736.0
2008-07-23 10:00:00	AAPL	Stock	5.8486	6.0132	5.8268	5.9511	269659992.0
2008-07-23 11:00:00	AAPL	Stock	5.9504	5.9604	5.8429	5.8653	133539252.0
2008-07-23 12:00:00	AAPL	Stock	5.8657	5.9032	5.8464	5.8918	105701568.0
2008-07-23 13:00:00	AAPL	Stock	5.8918	5.975	5.8871	5.9211	127151668.0
2008-07-23 14:00:00	AAPL	Stock	5.9225	5.9561	5.915	5.9343	91546224.0
2008-07-23 15:00:00	AAPL	Stock	5.9343	5.9514	5.9064	5.9312	118927620.0
2008-07-23 16:00:00	AAPL	Stock	5.9379	5.9679	5.7864	5.9379	12159392.0
2008-07-23 17:00:00	AAPL	Stock	5.9382	5.9761	5.7864	5.9711	3254748.0
2008-07-23 18:00:00	AAPL	Stock	5.9668	5.9696	5.9379	5.9643	1452248.0
2008-07-23 19:00:00	AAPL	Stock	5.9593	5.9768	5.9593	5.9768	302568.0
2008-07-23 20:00:00	AAPL	Stock	5.9379	5.9379	5.9379	5.9379	288400.0
2008-07-23 07:00:00	MSFT	Stock	25.95	25.95	25.95	25.95	100.0
2008-07-23 08:00:00	MSFT	Stock	25.78	25.95	25.78	25.9	17025.0
2008-07-23 09:00:00	MSFT	Stock	25.91	26.23	25.8	25.98	7435134.0
2008-07-23 10:00:00	MSFT	Stock	25.98	26.84	25.94	26.56	21842939.0
2008-07-23 11:00:00	MSFT	Stock	26.56	26.75	26.389	26.48	10205978.0
2008-07-23 12:00:00	MSFT	Stock	26.49	26.522	26.26	26.31	6215693.0
2008-07-23 13:00:00	MSFT	Stock	26.31	26.34	26.1	26.15	6426710.0
2008-07-23 14:00:00	MSFT	Stock	26.15	26.31	26.14	26.27	6739989.0
2008-07-23 15:00:00	MSFT	Stock	26.27	26.5	26.14	26.43	13428646.0
2008-07-23 16:00:00	MSFT	Stock	26.43	26.65	26.011	26.43	3328009.0
2008-07-23 17:00:00	MSFT	Stock	26.4	26.58	26.346	26.5	210408.0
2008-07-23 18:00:00	MSFT	Stock	26.5	26.56	26.43	26.5	1477823.0
2008-07-23 19:00:00	MSFT	Stock	26.52	26.59	26.5	26.59	3770.0
2008-07-23 07:00:00	NVDA	Stock	0.2825	0.2825	0.2825	0.2825	4000.0
2008-07-23 08:00:00	NVDA	Stock	0.285	0.29	0.285	0.2875	243080.0
2008-07-23 09:00:00	NVDA	Stock	0.2862	0.2925	0.285	0.29	54136240.0
2008-07-23 10:00:00	NVDA	Stock	0.2902	0.296	0.2892	0.2915	164287040.0
2008-07-23 11:00:00	NVDA	Stock	0.2912	0.2938	0.2875	0.2885	89710560.0
2008-07-23 12:00:00	NVDA	Stock	0.2885	0.2915	0.2865	0.2912	47806640.0
2008-07-23 13:00:00	NVDA	Stock	0.2915	0.2932	0.2898	0.291	52765440.0
2008-07-23 14:00:00	NVDA	Stock	0.2908	0.2935	0.2905	0.292	76030800.0
2008-07-23 15:00:00	NVDA	Stock	0.292	0.2938	0.2915	0.2932	91531680.0
2008-07-23 16:00:00	NVDA	Stock	0.293	0.2938	0.2882	0.293	13272320.0
2008-07-23 17:00:00	NVDA	Stock	0.293	0.2935	0.293	0.2935	1319400.0
2008-07-23 18:00:00	NVDA	Stock	0.2935	0.2938	0.2935	0.2938	58000.0
2008-07-23 19:00:00	NVDA	Stock	0.2938	0.2945	0.2938	0.2945	310800.0
2008-07-23 07:00:00	AMZN	Stock	3.3825	3.3825	3.3825	3.3825	12000.0
2008-07-23 08:00:00	AMZN	Stock	3.3825	3.4	3.3725	3.3725	129560.0
2008-07-23 09:00:00	AMZN	Stock	3.3725	3.491	3.3725	3.4665	22234680.0
2008-07-23 10:00:00	AMZN	Stock	3.4665	3.6035	3.4595	3.5495	41854260.0
2008-07-23 11:00:00	AMZN	Stock	3.5495	3.5705	3.4655	3.4655	28117260.0
2008-07-23 12:00:00	AMZN	Stock	3.4645	3.5095	3.4445	3.502	17842220.0
2008-07-23 13:00:00	AMZN	Stock	3.5015	3.5115	3.4685	3.4775	18366020.0
2008-07-23 14:00:00	AMZN	Stock	3.4775	3.515	3.4685	3.4873	20371280.0
2008-07-23 15:00:00	AMZN	Stock	3.487	3.5425	3.475	3.525	56758100.0
2008-07-23 16:00:00	AMZN	Stock	3.5233	3.8715	3.4005	3.473	110359760.0

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

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