PREVIEW / stock_1hour / 2009-12-09

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-12-09.parquet
  size:    884 KB
  rows:    42,409
  symbols: 3,407

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
2009-12-09 04:00:00	AAPL	Stock	6.7707	6.7707	6.7707	6.7707	2800.0
2009-12-09 05:00:00	AAPL	Stock	6.7654	6.8036	6.7632	6.8036	26600.0
2009-12-09 06:00:00	AAPL	Stock	6.7996	6.8018	6.7996	6.8	9520.0
2009-12-09 07:00:00	AAPL	Stock	6.8075	6.8371	6.7993	6.8229	791980.0
2009-12-09 08:00:00	AAPL	Stock	6.825	6.8536	6.8214	6.8393	5037592.0
2009-12-09 09:00:00	AAPL	Stock	6.84	6.8721	6.7968	6.8693	97911548.0
2009-12-09 10:00:00	AAPL	Stock	6.8696	6.9136	6.8393	6.8971	121127440.0
2009-12-09 11:00:00	AAPL	Stock	6.8968	6.9129	6.8821	6.8918	52417316.0
2009-12-09 12:00:00	AAPL	Stock	6.8918	6.8964	6.8714	6.8954	37156252.0
2009-12-09 13:00:00	AAPL	Stock	6.8946	6.8996	6.875	6.8882	41992692.0
2009-12-09 14:00:00	AAPL	Stock	6.8882	6.9625	6.8821	6.9582	84201740.0
2009-12-09 15:00:00	AAPL	Stock	6.9587	7.0771	6.9584	7.0518	215559372.0
2009-12-09 16:00:00	AAPL	Stock	7.0639	7.0699	6.9285	7.0643	11157272.0
2009-12-09 17:00:00	AAPL	Stock	7.0643	7.0768	6.841	7.0746	1215760.0
2009-12-09 18:00:00	AAPL	Stock	7.075	7.0786	7.0643	7.0693	1770552.0
2009-12-09 19:00:00	AAPL	Stock	7.0686	7.0729	7.0618	7.0629	877968.0
2009-12-09 20:00:00	AAPL	Stock	6.8846	6.8846	6.8846	6.8846	11200.0
2009-12-09 07:00:00	MSFT	Stock	29.5	29.5	29.5	29.5	400.0
2009-12-09 08:00:00	MSFT	Stock	29.63	29.7	29.62	29.7	14750.0
2009-12-09 09:00:00	MSFT	Stock	29.64	29.64	29.25	29.43	7414451.0
2009-12-09 10:00:00	MSFT	Stock	29.43	29.77	29.35	29.745	8586866.0
2009-12-09 11:00:00	MSFT	Stock	29.745	29.81	29.63	29.65	5810055.0
2009-12-09 12:00:00	MSFT	Stock	29.65	29.7	29.56	29.642	3752192.0
2009-12-09 13:00:00	MSFT	Stock	29.64	29.75	29.56	29.61	3193472.0
2009-12-09 14:00:00	MSFT	Stock	29.61	29.68	29.6	29.638	3515359.0
2009-12-09 15:00:00	MSFT	Stock	29.64	29.8	29.64	29.71	9259402.0
2009-12-09 16:00:00	MSFT	Stock	29.72	29.748	29.6	29.74	2106127.0
2009-12-09 17:00:00	MSFT	Stock	29.57	29.57	29.57	29.57	100.0
2009-12-09 18:00:00	MSFT	Stock	29.67	29.67	29.67	29.67	198.0
2009-12-09 19:00:00	MSFT	Stock	29.68	29.75	29.68	29.75	5021.0
2009-12-09 20:00:00	MSFT	Stock	29.59	29.59	29.59	29.59	900.0
2009-12-09 08:00:00	NVDA	Stock	0.385	0.3893	0.385	0.3893	1497920.0
2009-12-09 09:00:00	NVDA	Stock	0.3875	0.3915	0.383	0.3895	111043240.0
2009-12-09 10:00:00	NVDA	Stock	0.3898	0.393	0.3882	0.3893	174694160.0
2009-12-09 11:00:00	NVDA	Stock	0.3895	0.3951	0.3895	0.395	105439240.0
2009-12-09 12:00:00	NVDA	Stock	0.395	0.395	0.3918	0.3928	79114720.0
2009-12-09 13:00:00	NVDA	Stock	0.3928	0.3933	0.389	0.3894	59810880.0
2009-12-09 14:00:00	NVDA	Stock	0.3895	0.3908	0.3882	0.3908	40547320.0
2009-12-09 15:00:00	NVDA	Stock	0.3908	0.3933	0.3906	0.3922	81816520.0
2009-12-09 16:00:00	NVDA	Stock	0.3922	0.3933	0.3906	0.3933	7964800.0
2009-12-09 17:00:00	NVDA	Stock	0.3922	0.3942	0.3922	0.3942	266520.0
2009-12-09 18:00:00	NVDA	Stock	0.395	0.395	0.395	0.395	80000.0
2009-12-09 19:00:00	NVDA	Stock	0.3942	0.3942	0.3938	0.3938	38000.0
2009-12-09 06:00:00	AMZN	Stock	6.72	6.75	6.72	6.75	6000.0
2009-12-09 07:00:00	AMZN	Stock	6.74	6.74	6.73	6.73	76000.0
2009-12-09 08:00:00	AMZN	Stock	6.725	6.8	6.725	6.75	545540.0
2009-12-09 09:00:00	AMZN	Stock	6.75	6.75	6.5388	6.5405	51893880.0
2009-12-09 10:00:00	AMZN	Stock	6.5395	6.587	6.491	6.5584	58816440.0
2009-12-09 11:00:00	AMZN	Stock	6.558	6.628	6.5395	6.5696	22235000.0
2009-12-09 12:00:00	AMZN	Stock	6.5685	6.57	6.501	6.5575	20453080.0

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

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