PREVIEW / stock_1hour / 2007-12-21

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-12-21.parquet
  size:    868 KB
  rows:    42,673
  symbols: 3,246

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
2007-12-21 07:00:00	AAPL	Stock	6.8182	6.8214	6.8036	6.8043	701904.0
2007-12-21 08:00:00	AAPL	Stock	6.8125	6.8321	6.8018	6.8268	8590680.0
2007-12-21 09:00:00	AAPL	Stock	6.8268	6.8529	6.7818	6.8029	270844364.0
2007-12-21 10:00:00	AAPL	Stock	6.8032	6.8696	6.8014	6.8525	149106272.0
2007-12-21 11:00:00	AAPL	Stock	6.8521	6.8707	6.8357	6.8464	88549020.0
2007-12-21 12:00:00	AAPL	Stock	6.8454	6.8571	6.8371	6.8464	56358568.0
2007-12-21 13:00:00	AAPL	Stock	6.8461	6.875	6.8457	6.87	60909884.0
2007-12-21 14:00:00	AAPL	Stock	6.8693	6.9071	6.8618	6.9008	84227080.0
2007-12-21 15:00:00	AAPL	Stock	6.9018	6.9132	6.8375	6.9011	173047252.0
2007-12-21 16:00:00	AAPL	Stock	6.8929	6.9261	6.6861	6.9107	96273128.0
2007-12-21 17:00:00	AAPL	Stock	6.9107	6.9256	6.6861	6.9143	6153448.0
2007-12-21 18:00:00	AAPL	Stock	6.9146	6.9259	6.7864	6.9161	870716.0
2007-12-21 19:00:00	AAPL	Stock	6.9161	6.9196	6.9075	6.9107	357364.0
2007-12-21 07:00:00	MSFT	Stock	35.7	35.87	35.7	35.87	490.0
2007-12-21 08:00:00	MSFT	Stock	35.85	35.92	35.52	35.52	2285991.0
2007-12-21 09:00:00	MSFT	Stock	35.9	35.98	35.52	35.82	29451867.0
2007-12-21 10:00:00	MSFT	Stock	35.83	36.01	35.81	35.9	8139178.0
2007-12-21 11:00:00	MSFT	Stock	35.9	35.98	35.86	35.882	4440188.0
2007-12-21 12:00:00	MSFT	Stock	35.885	35.92	35.8	35.863	2777750.0
2007-12-21 13:00:00	MSFT	Stock	35.86	35.9	35.81	35.86	2713294.0
2007-12-21 14:00:00	MSFT	Stock	35.86	35.96	35.84	35.887	5086938.0
2007-12-21 15:00:00	MSFT	Stock	35.885	36.05	35.86	36.05	10408327.0
2007-12-21 16:00:00	MSFT	Stock	36.05	36.12	35.52	36.06	17279502.0
2007-12-21 17:00:00	MSFT	Stock	35.916	36.18	35.465	36.18	790308.0
2007-12-21 18:00:00	MSFT	Stock	36.15	36.18	35.81	35.89	509611.0
2007-12-21 19:00:00	MSFT	Stock	35.9	36.18	35.89	36.16	1816.0
2007-12-21 08:00:00	NVDA	Stock	0.8875	0.8925	0.8875	0.8875	268000.0
2007-12-21 09:00:00	NVDA	Stock	0.8912	0.8975	0.8855	0.8912	131683880.0
2007-12-21 10:00:00	NVDA	Stock	0.8912	0.894	0.8842	0.8842	44215240.0
2007-12-21 11:00:00	NVDA	Stock	0.8842	0.889	0.8772	0.879	31052440.0
2007-12-21 12:00:00	NVDA	Stock	0.879	0.886	0.8765	0.8825	25489680.0
2007-12-21 13:00:00	NVDA	Stock	0.8825	0.8828	0.8765	0.8768	24655200.0
2007-12-21 14:00:00	NVDA	Stock	0.8768	0.881	0.8765	0.8788	36248760.0
2007-12-21 15:00:00	NVDA	Stock	0.8788	0.88	0.871	0.8795	80708280.0
2007-12-21 16:00:00	NVDA	Stock	0.8795	0.8831	0.8764	0.879	52723000.0
2007-12-21 17:00:00	NVDA	Stock	0.8792	0.8792	0.879	0.879	7679960.0
2007-12-21 18:00:00	NVDA	Stock	0.8786	0.8875	0.8786	0.8875	1784720.0
2007-12-21 19:00:00	NVDA	Stock	0.8785	0.8785	0.8785	0.8785	73400.0
2007-12-21 08:00:00	AMZN	Stock	4.55	4.5965	4.55	4.575	569640.0
2007-12-21 09:00:00	AMZN	Stock	4.575	4.58	4.5195	4.527	38716000.0
2007-12-21 10:00:00	AMZN	Stock	4.5275	4.5855	4.5225	4.5765	17735080.0
2007-12-21 11:00:00	AMZN	Stock	4.5775	4.614	4.5705	4.5825	17486620.0
2007-12-21 12:00:00	AMZN	Stock	4.5835	4.6	4.573	4.578	7549080.0
2007-12-21 13:00:00	AMZN	Stock	4.578	4.582	4.563	4.5765	6131220.0
2007-12-21 14:00:00	AMZN	Stock	4.5765	4.6045	4.5755	4.597	6865200.0
2007-12-21 15:00:00	AMZN	Stock	4.5965	4.611	4.5575	4.5715	21384220.0
2007-12-21 16:00:00	AMZN	Stock	4.575	4.581	4.529	4.529	12750260.0
2007-12-21 17:00:00	AMZN	Stock	4.585	4.585	4.529	4.5629	2999820.0
2007-12-21 18:00:00	AMZN	Stock	4.5637	4.5637	4.5635	4.5635	282100.0
2007-12-21 09:00:00	TLT	Stock	92.77	92.92	92.7	92.88	349789.0

> showing 50 of 42,673 rows — these rows as CSV

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