PREVIEW / stock_1hour / 2014-03-07

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-03-07.parquet
  size:    1.0 MB
  rows:    48,472
  symbols: 3,554

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-03-07 04:00:00	AAPL	Stock	18.9557	18.9557	18.9554	18.9554	5600.0
2014-03-07 06:00:00	AAPL	Stock	18.9554	18.9796	18.9554	18.9796	19600.0
2014-03-07 07:00:00	AAPL	Stock	18.9786	18.9786	18.9646	18.9646	19600.0
2014-03-07 08:00:00	AAPL	Stock	18.9643	18.9957	18.8929	18.9736	1027908.0
2014-03-07 09:00:00	AAPL	Stock	18.9664	18.9993	18.8111	18.8642	38415300.0
2014-03-07 10:00:00	AAPL	Stock	18.8616	18.9032	18.8289	18.84	25607596.0
2014-03-07 11:00:00	AAPL	Stock	18.8389	18.8689	18.8004	18.8464	20325872.0
2014-03-07 12:00:00	AAPL	Stock	18.8425	18.85	18.7946	18.7996	14742560.0
2014-03-07 13:00:00	AAPL	Stock	18.8	18.8614	18.7875	18.8182	14657748.0
2014-03-07 14:00:00	AAPL	Stock	18.8204	18.8911	18.8123	18.8821	15330840.0
2014-03-07 15:00:00	AAPL	Stock	18.8846	18.9443	18.8593	18.9439	33983376.0
2014-03-07 16:00:00	AAPL	Stock	18.9439	18.9496	18.8583	18.9275	9840292.0
2014-03-07 17:00:00	AAPL	Stock	18.9314	18.9443	18.9286	18.9357	320096.0
2014-03-07 18:00:00	AAPL	Stock	18.9339	18.9443	18.9339	18.9368	730576.0
2014-03-07 19:00:00	AAPL	Stock	18.9371	18.9446	18.9339	18.9443	157948.0
2014-03-07 08:00:00	MSFT	Stock	38.15	38.29	38.15	38.24	31200.0
2014-03-07 09:00:00	MSFT	Stock	38.26	38.36	37.87	38.01	3034533.0
2014-03-07 10:00:00	MSFT	Stock	38.01	38.062	37.89	37.925	4033250.0
2014-03-07 11:00:00	MSFT	Stock	37.93	37.93	37.69	37.81	2801568.0
2014-03-07 12:00:00	MSFT	Stock	37.82	37.82	37.73	37.78	1809063.0
2014-03-07 13:00:00	MSFT	Stock	37.785	37.812	37.7	37.805	2356988.0
2014-03-07 14:00:00	MSFT	Stock	37.81	37.88	37.72	37.83	2927392.0
2014-03-07 15:00:00	MSFT	Stock	37.84	37.91	37.76	37.9	6375126.0
2014-03-07 16:00:00	MSFT	Stock	37.9	37.91	37.797	37.89	2527550.0
2014-03-07 17:00:00	MSFT	Stock	37.9	37.9	37.86	37.9	43944.0
2014-03-07 18:00:00	MSFT	Stock	37.9	37.9	37.9	37.9	400.0
2014-03-07 19:00:00	MSFT	Stock	37.83	37.83	37.81	37.81	2100.0
2014-03-07 08:00:00	NVDA	Stock	0.4595	0.4595	0.4595	0.4595	4000.0
2014-03-07 09:00:00	NVDA	Stock	0.4615	0.4622	0.4582	0.4595	53853000.0
2014-03-07 10:00:00	NVDA	Stock	0.4595	0.462	0.4575	0.459	28315480.0
2014-03-07 11:00:00	NVDA	Stock	0.459	0.459	0.4554	0.4561	40429680.0
2014-03-07 12:00:00	NVDA	Stock	0.4561	0.4585	0.456	0.4585	21899040.0
2014-03-07 13:00:00	NVDA	Stock	0.4584	0.4585	0.4565	0.4576	22736320.0
2014-03-07 14:00:00	NVDA	Stock	0.4578	0.4585	0.4568	0.4575	19010800.0
2014-03-07 15:00:00	NVDA	Stock	0.4578	0.459	0.457	0.4589	47334400.0
2014-03-07 16:00:00	NVDA	Stock	0.4585	0.459	0.4578	0.4589	3057960.0
2014-03-07 17:00:00	NVDA	Stock	0.459	0.459	0.459	0.459	109920.0
2014-03-07 18:00:00	NVDA	Stock	0.4568	0.4568	0.4568	0.4568	4000.0
2014-03-07 06:00:00	AMZN	Stock	18.6	18.664	18.6	18.664	8000.0
2014-03-07 07:00:00	AMZN	Stock	18.6475	18.682	18.6475	18.682	4000.0
2014-03-07 08:00:00	AMZN	Stock	18.6	18.747	18.6	18.725	199620.0
2014-03-07 09:00:00	AMZN	Stock	18.7115	18.7495	18.507	18.573	8348760.0
2014-03-07 10:00:00	AMZN	Stock	18.582	18.6295	18.5505	18.5655	6743880.0
2014-03-07 11:00:00	AMZN	Stock	18.5665	18.5875	18.4766	18.568	4498760.0
2014-03-07 12:00:00	AMZN	Stock	18.5735	18.599	18.5436	18.575	3882380.0
2014-03-07 13:00:00	AMZN	Stock	18.5755	18.589	18.5385	18.5735	3136520.0
2014-03-07 14:00:00	AMZN	Stock	18.5728	18.5885	18.495	18.532	4116780.0
2014-03-07 15:00:00	AMZN	Stock	18.54	18.606	18.5095	18.6	8711400.0
2014-03-07 16:00:00	AMZN	Stock	18.593	18.6255	18.5544	18.608	2270480.0
2014-03-07 17:00:00	AMZN	Stock	18.603	18.615	18.6	18.615	99620.0

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

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