PREVIEW / stock_1hour / 2014-02-10

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-02-10.parquet
  size:    1.0 MB
  rows:    47,971
  symbols: 3,534

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-02-10 04:00:00	AAPL	Stock	18.6464	18.6554	18.6218	18.6554	26600.0
2014-02-10 05:00:00	AAPL	Stock	18.6607	18.6643	18.6339	18.6464	33684.0
2014-02-10 06:00:00	AAPL	Stock	18.6429	18.6429	18.6321	18.6375	16744.0
2014-02-10 07:00:00	AAPL	Stock	18.6129	18.6346	18.5718	18.6179	350308.0
2014-02-10 08:00:00	AAPL	Stock	18.6161	18.6357	18.5607	18.6061	1156652.0
2014-02-10 09:00:00	AAPL	Stock	18.5986	18.8661	18.4543	18.7995	69747356.0
2014-02-10 10:00:00	AAPL	Stock	18.8043	18.8618	18.7679	18.82	42890596.0
2014-02-10 11:00:00	AAPL	Stock	18.8229	18.9179	18.8043	18.9098	32117932.0
2014-02-10 12:00:00	AAPL	Stock	18.9086	18.9996	18.9068	18.9146	39664324.0
2014-02-10 13:00:00	AAPL	Stock	18.9179	18.9396	18.8607	18.9011	21771848.0
2014-02-10 14:00:00	AAPL	Stock	18.9046	18.9636	18.8821	18.9304	19253164.0
2014-02-10 15:00:00	AAPL	Stock	18.9307	18.9411	18.8629	18.8923	31548300.0
2014-02-10 16:00:00	AAPL	Stock	18.8925	18.9132	18.8314	18.9036	18255132.0
2014-02-10 17:00:00	AAPL	Stock	18.9054	18.9054	18.8925	18.8989	225036.0
2014-02-10 18:00:00	AAPL	Stock	18.8982	18.9	18.8929	18.8929	27020.0
2014-02-10 19:00:00	AAPL	Stock	18.9032	18.9154	18.8946	18.9018	119728.0
2014-02-10 05:00:00	MSFT	Stock	36.65	36.65	36.54	36.65	2100.0
2014-02-10 06:00:00	MSFT	Stock	36.65	36.65	36.65	36.65	2500.0
2014-02-10 07:00:00	MSFT	Stock	36.6	36.61	36.6	36.6	4600.0
2014-02-10 08:00:00	MSFT	Stock	36.62	36.65	36.6	36.64	7800.0
2014-02-10 09:00:00	MSFT	Stock	36.64	36.736	36.46	36.54	3369790.0
2014-02-10 10:00:00	MSFT	Stock	36.54	36.566	36.29	36.345	5053635.0
2014-02-10 11:00:00	MSFT	Stock	36.345	36.66	36.34	36.65	2103834.0
2014-02-10 12:00:00	MSFT	Stock	36.65	36.66	36.53	36.57	1450540.0
2014-02-10 13:00:00	MSFT	Stock	36.575	36.73	36.57	36.71	1456903.0
2014-02-10 14:00:00	MSFT	Stock	36.71	36.74	36.66	36.7	1942174.0
2014-02-10 15:00:00	MSFT	Stock	36.705	36.8	36.665	36.78	5102495.0
2014-02-10 16:00:00	MSFT	Stock	36.8	36.801	36.585	36.8	5391282.0
2014-02-10 17:00:00	MSFT	Stock	36.8	36.8	36.8	36.8	31083.0
2014-02-10 18:00:00	MSFT	Stock	36.83	36.83	36.82	36.82	5100.0
2014-02-10 19:00:00	MSFT	Stock	36.83	37.35	36.83	37.35	9559.0
2014-02-10 08:00:00	NVDA	Stock	0.3962	0.3968	0.3962	0.3968	12000.0
2014-02-10 09:00:00	NVDA	Stock	0.3962	0.4025	0.3962	0.402	29528920.0
2014-02-10 10:00:00	NVDA	Stock	0.402	0.4032	0.399	0.3995	30690000.0
2014-02-10 11:00:00	NVDA	Stock	0.3995	0.4011	0.3973	0.398	62126080.0
2014-02-10 12:00:00	NVDA	Stock	0.398	0.3988	0.3973	0.3985	44607840.0
2014-02-10 13:00:00	NVDA	Stock	0.3985	0.399	0.3959	0.3988	37498880.0
2014-02-10 14:00:00	NVDA	Stock	0.3988	0.3993	0.3975	0.3975	40744840.0
2014-02-10 15:00:00	NVDA	Stock	0.3975	0.3985	0.3973	0.3978	62642800.0
2014-02-10 16:00:00	NVDA	Stock	0.398	0.3988	0.3979	0.398	3227360.0
2014-02-10 17:00:00	NVDA	Stock	0.398	0.398	0.398	0.398	84680.0
2014-02-10 04:00:00	AMZN	Stock	18.0805	18.0805	18.0805	18.0805	6560.0
2014-02-10 05:00:00	AMZN	Stock	18.0805	18.0805	18.0745	18.0745	9000.0
2014-02-10 06:00:00	AMZN	Stock	18.05	18.05	18.037	18.044	13720.0
2014-02-10 07:00:00	AMZN	Stock	18.025	18.0805	18.025	18.0805	15000.0
2014-02-10 08:00:00	AMZN	Stock	18.0625	18.1085	18.0625	18.0885	91720.0
2014-02-10 09:00:00	AMZN	Stock	18.0885	18.25	18.022	18.143	11219600.0
2014-02-10 10:00:00	AMZN	Stock	18.1452	18.175	17.9675	18.0625	11048560.0
2014-02-10 11:00:00	AMZN	Stock	18.061	18.21	18.035	18.1811	8863680.0
2014-02-10 12:00:00	AMZN	Stock	18.181	18.1845	18.089	18.098	4977880.0

> showing 50 of 47,971 rows — these rows as CSV

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