PREVIEW / stock_1hour / 2010-12-14

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-12-14.parquet
  size:    931 KB
  rows:    44,161
  symbols: 3,529

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-12-14 04:00:00	AAPL	Stock	11.5	11.5	11.4718	11.4718	41440.0
2010-12-14 05:00:00	AAPL	Stock	11.4718	11.5357	11.4718	11.5357	86800.0
2010-12-14 06:00:00	AAPL	Stock	11.5089	11.5357	11.5089	11.5157	68320.0
2010-12-14 07:00:00	AAPL	Stock	11.5196	11.5214	11.4679	11.4821	1013068.0
2010-12-14 08:00:00	AAPL	Stock	11.4857	11.4875	11.4386	11.4754	3126760.0
2010-12-14 09:00:00	AAPL	Stock	11.4754	11.5036	11.4039	11.4425	64070832.0
2010-12-14 10:00:00	AAPL	Stock	11.4443	11.5193	11.4429	11.4732	64699992.0
2010-12-14 11:00:00	AAPL	Stock	11.4732	11.4936	11.4607	11.4786	22924328.0
2010-12-14 12:00:00	AAPL	Stock	11.4786	11.4857	11.4714	11.4754	15008700.0
2010-12-14 13:00:00	AAPL	Stock	11.4757	11.5121	11.4739	11.4939	21817460.0
2010-12-14 14:00:00	AAPL	Stock	11.4943	11.5057	11.4393	11.4646	44500288.0
2010-12-14 15:00:00	AAPL	Stock	11.4646	11.4818	11.3929	11.4379	86967776.0
2010-12-14 16:00:00	AAPL	Stock	11.4382	11.4592	11.4049	11.4293	11043088.0
2010-12-14 17:00:00	AAPL	Stock	11.4293	11.4389	11.4232	11.43	533512.0
2010-12-14 18:00:00	AAPL	Stock	11.4286	11.4389	11.425	11.4386	455364.0
2010-12-14 19:00:00	AAPL	Stock	11.4354	11.4411	11.4304	11.4411	135100.0
2010-12-14 04:00:00	MSFT	Stock	27.2	27.2	27.2	27.2	100.0
2010-12-14 05:00:00	MSFT	Stock	27.17	27.28	27.17	27.28	652.0
2010-12-14 07:00:00	MSFT	Stock	27.28	27.28	27.21	27.28	975.0
2010-12-14 08:00:00	MSFT	Stock	27.24	27.24	27.21	27.21	5800.0
2010-12-14 09:00:00	MSFT	Stock	27.24	27.42	27.0	27.41	6307672.0
2010-12-14 10:00:00	MSFT	Stock	27.405	27.5	27.39	27.48	9373011.0
2010-12-14 11:00:00	MSFT	Stock	27.48	27.612	27.46	27.612	7464150.0
2010-12-14 12:00:00	MSFT	Stock	27.62	27.68	27.59	27.66	5743725.0
2010-12-14 13:00:00	MSFT	Stock	27.66	27.68	27.63	27.678	4264214.0
2010-12-14 14:00:00	MSFT	Stock	27.675	27.7	27.6	27.691	8494056.0
2010-12-14 15:00:00	MSFT	Stock	27.695	27.75	27.5	27.63	17516016.0
2010-12-14 16:00:00	MSFT	Stock	27.62	27.68	27.23	27.62	3558060.0
2010-12-14 17:00:00	MSFT	Stock	27.62	27.64	27.62	27.63	7889.0
2010-12-14 18:00:00	MSFT	Stock	27.61	27.62	27.37	27.61	27150.0
2010-12-14 19:00:00	MSFT	Stock	27.61	27.63	27.6	27.6	1058.0
2010-12-14 07:00:00	NVDA	Stock	0.365	0.365	0.365	0.365	4000.0
2010-12-14 08:00:00	NVDA	Stock	0.3675	0.3713	0.3652	0.37	1592880.0
2010-12-14 09:00:00	NVDA	Stock	0.371	0.378	0.37	0.3713	192493480.0
2010-12-14 10:00:00	NVDA	Stock	0.3715	0.3738	0.3703	0.3725	104561000.0
2010-12-14 11:00:00	NVDA	Stock	0.3725	0.3738	0.3723	0.3729	59695400.0
2010-12-14 12:00:00	NVDA	Stock	0.3729	0.373	0.367	0.367	70002520.0
2010-12-14 13:00:00	NVDA	Stock	0.367	0.3685	0.3665	0.3675	88396320.0
2010-12-14 14:00:00	NVDA	Stock	0.3675	0.3695	0.367	0.3692	78872480.0
2010-12-14 15:00:00	NVDA	Stock	0.369	0.3692	0.3642	0.365	134434640.0
2010-12-14 16:00:00	NVDA	Stock	0.3648	0.3708	0.3645	0.3655	8602800.0
2010-12-14 17:00:00	NVDA	Stock	0.3655	0.3658	0.3655	0.3658	32000.0
2010-12-14 18:00:00	NVDA	Stock	0.3655	0.3658	0.3655	0.3658	68000.0
2010-12-14 19:00:00	NVDA	Stock	0.3658	0.367	0.3658	0.367	46400.0
2010-12-14 07:00:00	AMZN	Stock	8.7375	8.7375	8.7375	8.7375	4000.0
2010-12-14 08:00:00	AMZN	Stock	8.69	8.716	8.629	8.7155	349400.0
2010-12-14 09:00:00	AMZN	Stock	8.715	8.788	8.663	8.713	16160980.0
2010-12-14 10:00:00	AMZN	Stock	8.7165	8.749	8.6855	8.69	16964900.0
2010-12-14 11:00:00	AMZN	Stock	8.6925	8.7165	8.6805	8.6945	4970200.0
2010-12-14 12:00:00	AMZN	Stock	8.6943	8.722	8.6825	8.7035	4079720.0

> showing 50 of 44,161 rows — these rows as CSV

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