PREVIEW / stock_1hour / 2011-03-18

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-18.parquet
  size:    967 KB
  rows:    44,972
  symbols: 3,514

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
2011-03-18 04:00:00	AAPL	Stock	11.9643	12.0893	11.9643	12.0893	5600.0
2011-03-18 05:00:00	AAPL	Stock	12.0496	12.0496	12.0232	12.0357	78400.0
2011-03-18 06:00:00	AAPL	Stock	12.0357	12.0357	11.9468	11.9821	159600.0
2011-03-18 07:00:00	AAPL	Stock	11.9821	12.0607	11.9821	12.0464	1065176.0
2011-03-18 08:00:00	AAPL	Stock	12.0464	12.0929	12.0225	12.0661	5840464.0
2011-03-18 09:00:00	AAPL	Stock	12.0696	12.1036	11.95	11.9543	184658292.0
2011-03-18 10:00:00	AAPL	Stock	11.9554	11.96	11.7857	11.8979	200793712.0
2011-03-18 11:00:00	AAPL	Stock	11.8979	11.9143	11.8221	11.83	71156484.0
2011-03-18 12:00:00	AAPL	Stock	11.8296	11.8832	11.8268	11.8614	38143168.0
2011-03-18 13:00:00	AAPL	Stock	11.8625	11.8989	11.8614	11.8871	41470016.0
2011-03-18 14:00:00	AAPL	Stock	11.8871	11.8954	11.8286	11.8346	46842684.0
2011-03-18 15:00:00	AAPL	Stock	11.8346	11.8454	11.7857	11.8093	113521044.0
2011-03-18 16:00:00	AAPL	Stock	11.8093	11.8914	11.7875	11.7875	37647372.0
2011-03-18 17:00:00	AAPL	Stock	11.7893	12.0524	11.7836	11.7893	615188.0
2011-03-18 18:00:00	AAPL	Stock	11.7893	11.7982	11.7864	11.7946	134204.0
2011-03-18 19:00:00	AAPL	Stock	11.7893	11.8096	11.7875	11.7918	395192.0
2011-03-18 04:00:00	MSFT	Stock	24.9	25.04	24.9	25.04	800.0
2011-03-18 06:00:00	MSFT	Stock	24.95	24.95	24.94	24.94	1100.0
2011-03-18 07:00:00	MSFT	Stock	24.98	24.98	24.93	24.98	11195.0
2011-03-18 08:00:00	MSFT	Stock	24.93	25.04	24.88	24.98	93666.0
2011-03-18 09:00:00	MSFT	Stock	24.98	25.18	24.784	24.94	17593412.0
2011-03-18 10:00:00	MSFT	Stock	24.93	25.025	24.82	25.005	7685090.0
2011-03-18 11:00:00	MSFT	Stock	25.01	25.11	25.0	25.015	9543416.0
2011-03-18 12:00:00	MSFT	Stock	25.01	25.08	24.99	24.992	3999431.0
2011-03-18 13:00:00	MSFT	Stock	25.0	25.1	24.99	25.08	3827006.0
2011-03-18 14:00:00	MSFT	Stock	25.082	25.1	25.0	25.015	5152890.0
2011-03-18 15:00:00	MSFT	Stock	25.02	25.06	24.8	24.82	15621222.0
2011-03-18 16:00:00	MSFT	Stock	24.8	25.002	24.792	24.808	17465182.0
2011-03-18 17:00:00	MSFT	Stock	24.87	24.998	24.795	24.86	189441.0
2011-03-18 18:00:00	MSFT	Stock	24.86	24.86	24.85	24.85	8050.0
2011-03-18 19:00:00	MSFT	Stock	24.85	24.88	24.8	24.88	19807.0
2011-03-18 07:00:00	NVDA	Stock	0.4512	0.4525	0.4502	0.4502	82000.0
2011-03-18 08:00:00	NVDA	Stock	0.4502	0.4568	0.45	0.4538	2208080.0
2011-03-18 09:00:00	NVDA	Stock	0.4538	0.455	0.4445	0.4445	172803720.0
2011-03-18 10:00:00	NVDA	Stock	0.4445	0.4495	0.4415	0.4475	178646560.0
2011-03-18 11:00:00	NVDA	Stock	0.4475	0.4485	0.4425	0.443	107144400.0
2011-03-18 12:00:00	NVDA	Stock	0.443	0.4448	0.4415	0.4428	62725680.0
2011-03-18 13:00:00	NVDA	Stock	0.4428	0.4475	0.4428	0.4465	59630720.0
2011-03-18 14:00:00	NVDA	Stock	0.4462	0.4475	0.4432	0.444	66361840.0
2011-03-18 15:00:00	NVDA	Stock	0.4442	0.445	0.44	0.4408	139409800.0
2011-03-18 16:00:00	NVDA	Stock	0.4407	0.4447	0.4403	0.4404	79707040.0
2011-03-18 17:00:00	NVDA	Stock	0.4418	0.444	0.4412	0.4415	191200.0
2011-03-18 18:00:00	NVDA	Stock	0.4412	0.4425	0.4412	0.442	264000.0
2011-03-18 19:00:00	NVDA	Stock	0.4422	0.4425	0.4405	0.4422	656160.0
2011-03-18 04:00:00	AMZN	Stock	8.075	8.075	8.075	8.075	4000.0
2011-03-18 06:00:00	AMZN	Stock	8.125	8.125	8.125	8.125	2000.0
2011-03-18 07:00:00	AMZN	Stock	8.119	8.125	8.119	8.125	7460.0
2011-03-18 08:00:00	AMZN	Stock	8.1285	8.14	8.065	8.0765	687700.0
2011-03-18 09:00:00	AMZN	Stock	8.082	8.168	8.0295	8.1475	25400260.0
2011-03-18 10:00:00	AMZN	Stock	8.1495	8.1555	8.0375	8.094	24066740.0

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

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