PREVIEW / stock_1hour / 2010-12-07

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-12-07.parquet
  size:    970 KB
  rows:    46,404
  symbols: 3,536

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-07 04:00:00	AAPL	Stock	11.4993	11.5025	11.4993	11.5025	11200.0
2010-12-07 05:00:00	AAPL	Stock	11.5464	11.5464	11.5411	11.5411	5600.0
2010-12-07 06:00:00	AAPL	Stock	11.5	11.5357	11.5	11.5179	19600.0
2010-12-07 07:00:00	AAPL	Stock	11.5179	11.5571	11.5179	11.5368	1076488.0
2010-12-07 08:00:00	AAPL	Stock	11.5407	11.5589	11.5179	11.5568	5115852.0
2010-12-07 09:00:00	AAPL	Stock	11.5564	11.5711	11.505	11.5168	74533984.0
2010-12-07 10:00:00	AAPL	Stock	11.5164	11.5193	11.4489	11.4914	66142832.0
2010-12-07 11:00:00	AAPL	Stock	11.4925	11.505	11.4746	11.4796	31728648.0
2010-12-07 12:00:00	AAPL	Stock	11.4796	11.4904	11.4518	11.4698	26007492.0
2010-12-07 13:00:00	AAPL	Stock	11.4694	11.4854	11.4571	11.4782	22201060.0
2010-12-07 14:00:00	AAPL	Stock	11.4771	11.5114	11.4518	11.4579	39150692.0
2010-12-07 15:00:00	AAPL	Stock	11.4571	11.4704	11.3614	11.3643	107035572.0
2010-12-07 16:00:00	AAPL	Stock	11.365	11.5764	11.3646	11.3839	12737032.0
2010-12-07 17:00:00	AAPL	Stock	11.4346	11.4346	11.3625	11.3696	1197728.0
2010-12-07 18:00:00	AAPL	Stock	11.365	11.3711	11.3589	11.3664	253652.0
2010-12-07 19:00:00	AAPL	Stock	11.3679	11.3964	11.3679	11.3929	943460.0
2010-12-07 05:00:00	MSFT	Stock	27.12	27.12	27.12	27.12	200.0
2010-12-07 06:00:00	MSFT	Stock	27.05	27.05	27.05	27.05	1000.0
2010-12-07 07:00:00	MSFT	Stock	27.04	27.1	27.04	27.05	4600.0
2010-12-07 08:00:00	MSFT	Stock	27.02	27.05	26.98	27.05	56276.0
2010-12-07 09:00:00	MSFT	Stock	27.07	27.11	26.88	27.03	7512137.0
2010-12-07 10:00:00	MSFT	Stock	27.03	27.06	26.89	26.975	11190800.0
2010-12-07 11:00:00	MSFT	Stock	26.975	26.99	26.92	26.945	5625009.0
2010-12-07 12:00:00	MSFT	Stock	26.94	26.99	26.91	26.975	5437556.0
2010-12-07 13:00:00	MSFT	Stock	26.98	26.99	26.92	26.97	4378351.0
2010-12-07 14:00:00	MSFT	Stock	26.97	27.13	26.94	26.97	9405227.0
2010-12-07 15:00:00	MSFT	Stock	26.97	27.0	26.85	26.88	9954423.0
2010-12-07 16:00:00	MSFT	Stock	26.88	27.09	26.794	26.96	2890395.0
2010-12-07 17:00:00	MSFT	Stock	26.97	27.03	26.8	26.82	87482.0
2010-12-07 18:00:00	MSFT	Stock	26.82	26.87	26.78	26.81	26332.0
2010-12-07 19:00:00	MSFT	Stock	26.83	26.87	26.8	26.81	2730.0
2010-12-07 07:00:00	NVDA	Stock	0.3718	0.3718	0.3718	0.3718	4000.0
2010-12-07 08:00:00	NVDA	Stock	0.37	0.372	0.3675	0.3678	358800.0
2010-12-07 09:00:00	NVDA	Stock	0.3698	0.3825	0.3685	0.3825	238180000.0
2010-12-07 10:00:00	NVDA	Stock	0.3828	0.3833	0.3743	0.3783	232614600.0
2010-12-07 11:00:00	NVDA	Stock	0.378	0.3805	0.3773	0.3785	79950880.0
2010-12-07 12:00:00	NVDA	Stock	0.3783	0.381	0.3783	0.381	62640200.0
2010-12-07 13:00:00	NVDA	Stock	0.381	0.3828	0.38	0.3802	83033640.0
2010-12-07 14:00:00	NVDA	Stock	0.3802	0.3807	0.3758	0.3763	89559200.0
2010-12-07 15:00:00	NVDA	Stock	0.3762	0.3773	0.373	0.3745	188497800.0
2010-12-07 16:00:00	NVDA	Stock	0.3758	0.3783	0.37	0.374	6776760.0
2010-12-07 17:00:00	NVDA	Stock	0.3783	0.3783	0.374	0.374	92000.0
2010-12-07 18:00:00	NVDA	Stock	0.3735	0.3758	0.3725	0.3725	336600.0
2010-12-07 19:00:00	NVDA	Stock	0.372	0.372	0.37	0.3708	932200.0
2010-12-07 07:00:00	AMZN	Stock	9.011	9.0625	9.011	9.05	255500.0
2010-12-07 08:00:00	AMZN	Stock	9.041	9.0505	9.025	9.044	860160.0
2010-12-07 09:00:00	AMZN	Stock	9.0405	9.0735	8.9705	8.986	21682560.0
2010-12-07 10:00:00	AMZN	Stock	8.986	9.017	8.9335	8.9745	20757420.0
2010-12-07 11:00:00	AMZN	Stock	8.974	8.9995	8.968	8.9784	7201180.0
2010-12-07 12:00:00	AMZN	Stock	8.9785	8.984	8.9445	8.971	6102140.0

> showing 50 of 46,404 rows — these rows as CSV

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