PREVIEW / stock_1hour / 2014-01-02

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-01-02.parquet
  size:    1.0 MB
  rows:    48,306
  symbols: 3,515

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
2014-01-02 04:00:00	AAPL	Stock	19.7679	19.8679	19.7679	19.8521	151872.0
2014-01-02 05:00:00	AAPL	Stock	19.8318	19.8318	19.8018	19.8118	22400.0
2014-01-02 06:00:00	AAPL	Stock	19.8607	19.8643	19.8214	19.845	67984.0
2014-01-02 07:00:00	AAPL	Stock	19.8214	19.9286	19.8214	19.865	643692.0
2014-01-02 08:00:00	AAPL	Stock	19.8661	19.8925	19.8036	19.8268	3344432.0
2014-01-02 09:00:00	AAPL	Stock	19.8304	19.8939	19.7571	19.7857	45404772.0
2014-01-02 10:00:00	AAPL	Stock	19.7857	19.8032	19.7371	19.7679	35874160.0
2014-01-02 11:00:00	AAPL	Stock	19.7712	19.7971	19.7421	19.7496	21015456.0
2014-01-02 12:00:00	AAPL	Stock	19.7511	19.7857	19.7382	19.7761	15780492.0
2014-01-02 13:00:00	AAPL	Stock	19.7786	19.7821	19.7268	19.7536	15822436.0
2014-01-02 14:00:00	AAPL	Stock	19.7579	19.7639	19.715	19.7389	14372288.0
2014-01-02 15:00:00	AAPL	Stock	19.7407	19.7746	19.7325	19.7582	30377452.0
2014-01-02 16:00:00	AAPL	Stock	19.7546	19.7703	19.743	19.7464	9443756.0
2014-01-02 17:00:00	AAPL	Stock	19.75	19.7586	19.75	19.7554	378756.0
2014-01-02 18:00:00	AAPL	Stock	19.7554	19.7554	19.75	19.75	149464.0
2014-01-02 19:00:00	AAPL	Stock	19.7504	19.7521	19.7482	19.75	63364.0
2014-01-02 05:00:00	MSFT	Stock	37.39	37.39	37.39	37.39	1200.0
2014-01-02 06:00:00	MSFT	Stock	37.39	37.39	37.39	37.39	800.0
2014-01-02 07:00:00	MSFT	Stock	37.28	37.4	37.28	37.35	600.0
2014-01-02 08:00:00	MSFT	Stock	37.43	37.43	37.28	37.28	8785.0
2014-01-02 09:00:00	MSFT	Stock	37.43	37.43	37.14	37.26	4044214.0
2014-01-02 10:00:00	MSFT	Stock	37.25	37.31	37.15	37.185	4294511.0
2014-01-02 11:00:00	MSFT	Stock	37.185	37.28	37.13	37.255	3323462.0
2014-01-02 12:00:00	MSFT	Stock	37.255	37.31	37.18	37.285	2312232.0
2014-01-02 13:00:00	MSFT	Stock	37.287	37.3	37.17	37.255	2714308.0
2014-01-02 14:00:00	MSFT	Stock	37.26	37.35	37.12	37.15	2517010.0
2014-01-02 15:00:00	MSFT	Stock	37.15	37.23	37.1	37.145	4967803.0
2014-01-02 16:00:00	MSFT	Stock	37.16	37.205	37.15	37.15	2060206.0
2014-01-02 17:00:00	MSFT	Stock	37.16	37.16	37.145	37.16	36572.0
2014-01-02 18:00:00	MSFT	Stock	37.17	37.17	37.17	37.17	186.0
2014-01-02 19:00:00	MSFT	Stock	37.17	37.17	37.17	37.17	300.0
2014-01-02 08:00:00	NVDA	Stock	0.4	0.4005	0.3988	0.399	329840.0
2014-01-02 09:00:00	NVDA	Stock	0.4	0.4	0.393	0.3962	94188080.0
2014-01-02 10:00:00	NVDA	Stock	0.3962	0.397	0.3945	0.395	26181680.0
2014-01-02 11:00:00	NVDA	Stock	0.3953	0.3958	0.393	0.3945	28653720.0
2014-01-02 12:00:00	NVDA	Stock	0.3945	0.3968	0.3944	0.3956	22950000.0
2014-01-02 13:00:00	NVDA	Stock	0.3956	0.3958	0.3945	0.3948	11022560.0
2014-01-02 14:00:00	NVDA	Stock	0.3949	0.3958	0.394	0.3953	16694000.0
2014-01-02 15:00:00	NVDA	Stock	0.3951	0.3973	0.395	0.3965	45815920.0
2014-01-02 16:00:00	NVDA	Stock	0.3965	0.3965	0.3958	0.3964	11062240.0
2014-01-02 17:00:00	NVDA	Stock	0.3965	0.3965	0.3965	0.3965	70800.0
2014-01-02 04:00:00	AMZN	Stock	19.946	19.946	19.946	19.946	2100.0
2014-01-02 06:00:00	AMZN	Stock	19.865	19.947	19.865	19.925	13020.0
2014-01-02 07:00:00	AMZN	Stock	19.8995	19.8995	19.875	19.875	6000.0
2014-01-02 08:00:00	AMZN	Stock	19.875	19.9395	19.875	19.8895	350140.0
2014-01-02 09:00:00	AMZN	Stock	19.9395	19.968	19.754	19.7935	6040280.0
2014-01-02 10:00:00	AMZN	Stock	19.7775	19.821	19.701	19.8198	5242040.0
2014-01-02 11:00:00	AMZN	Stock	19.82	19.8595	19.7099	19.7248	4049900.0
2014-01-02 12:00:00	AMZN	Stock	19.721	19.8475	19.715	19.8475	3477620.0
2014-01-02 13:00:00	AMZN	Stock	19.8462	19.853	19.7645	19.8425	3231260.0

> showing 50 of 48,306 rows — these rows as CSV

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