PREVIEW / stock_1hour / 2014-07-21

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-07-21.parquet
  size:    1.0 MB
  rows:    48,552
  symbols: 3,570

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-07-21 04:00:00	AAPL	Stock	23.625	23.79	23.5625	23.79	63540.0
2014-07-21 05:00:00	AAPL	Stock	23.7875	23.815	23.775	23.7925	59384.0
2014-07-21 06:00:00	AAPL	Stock	23.7925	23.8	23.7225	23.735	112416.0
2014-07-21 07:00:00	AAPL	Stock	23.7375	23.8	23.7125	23.78	255664.0
2014-07-21 08:00:00	AAPL	Stock	23.7625	23.7875	23.6175	23.6625	1209496.0
2014-07-21 09:00:00	AAPL	Stock	23.6625	23.7525	23.5225	23.5675	29123320.0
2014-07-21 10:00:00	AAPL	Stock	23.5675	23.5775	23.44	23.4418	23890456.0
2014-07-21 11:00:00	AAPL	Stock	23.441	23.5575	23.43	23.515	17939728.0
2014-07-21 12:00:00	AAPL	Stock	23.5175	23.5487	23.4825	23.5088	12069324.0
2014-07-21 13:00:00	AAPL	Stock	23.5075	23.5625	23.495	23.5625	12636764.0
2014-07-21 14:00:00	AAPL	Stock	23.5625	23.585	23.49	23.515	12783000.0
2014-07-21 15:00:00	AAPL	Stock	23.515	23.5325	23.47	23.485	23612200.0
2014-07-21 16:00:00	AAPL	Stock	23.4875	23.5487	23.475	23.5175	6000024.0
2014-07-21 17:00:00	AAPL	Stock	23.52	23.5425	23.4875	23.5175	409712.0
2014-07-21 18:00:00	AAPL	Stock	23.52	23.5475	23.4875	23.5475	444628.0
2014-07-21 19:00:00	AAPL	Stock	23.5475	23.5525	23.5025	23.5325	322108.0
2014-07-21 07:00:00	MSFT	Stock	44.67	44.67	44.47	44.47	320.0
2014-07-21 08:00:00	MSFT	Stock	44.53	44.66	44.5	44.56	4779.0
2014-07-21 09:00:00	MSFT	Stock	44.56	44.6	44.22	44.4	4763626.0
2014-07-21 10:00:00	MSFT	Stock	44.39	44.41	44.3	44.325	5359481.0
2014-07-21 11:00:00	MSFT	Stock	44.32	44.74	44.3	44.68	3224819.0
2014-07-21 12:00:00	MSFT	Stock	44.67	44.82	44.57	44.81	3344484.0
2014-07-21 13:00:00	MSFT	Stock	44.81	45.09	44.795	45.04	5645526.0
2014-07-21 14:00:00	MSFT	Stock	45.019	45.16	44.99	45.04	4263722.0
2014-07-21 15:00:00	MSFT	Stock	45.04	45.07	44.83	44.835	5865197.0
2014-07-21 16:00:00	MSFT	Stock	44.835	44.935	44.69	44.84	2882340.0
2014-07-21 17:00:00	MSFT	Stock	44.84	44.86	44.84	44.86	10920.0
2014-07-21 18:00:00	MSFT	Stock	44.86	44.88	44.835	44.88	21120.0
2014-07-21 19:00:00	MSFT	Stock	44.88	44.88	44.86	44.86	5400.0
2014-07-21 08:00:00	NVDA	Stock	0.4618	0.4618	0.4618	0.4618	12000.0
2014-07-21 09:00:00	NVDA	Stock	0.4593	0.466	0.4593	0.4633	32599240.0
2014-07-21 10:00:00	NVDA	Stock	0.4633	0.4635	0.4599	0.4612	51034040.0
2014-07-21 11:00:00	NVDA	Stock	0.4612	0.462	0.46	0.4618	24618040.0
2014-07-21 12:00:00	NVDA	Stock	0.4619	0.462	0.461	0.4611	10314120.0
2014-07-21 13:00:00	NVDA	Stock	0.4612	0.4648	0.4605	0.4636	21323080.0
2014-07-21 14:00:00	NVDA	Stock	0.4635	0.4665	0.463	0.4662	21719440.0
2014-07-21 15:00:00	NVDA	Stock	0.4662	0.467	0.4633	0.4638	68540160.0
2014-07-21 16:00:00	NVDA	Stock	0.4638	0.4638	0.4616	0.4638	6938440.0
2014-07-21 17:00:00	NVDA	Stock	0.4638	0.4638	0.4638	0.4638	20000.0
2014-07-21 18:00:00	NVDA	Stock	0.4638	0.4638	0.4638	0.4638	4000.0
2014-07-21 04:00:00	AMZN	Stock	17.894	17.894	17.85	17.85	4000.0
2014-07-21 07:00:00	AMZN	Stock	17.85	17.85	17.85	17.85	4600.0
2014-07-21 08:00:00	AMZN	Stock	17.85	17.9	17.85	17.8945	32900.0
2014-07-21 09:00:00	AMZN	Stock	17.875	18.0855	17.875	17.9865	8721940.0
2014-07-21 10:00:00	AMZN	Stock	17.998	18.0085	17.836	17.8675	7886240.0
2014-07-21 11:00:00	AMZN	Stock	17.858	17.99	17.8555	17.959	5071600.0
2014-07-21 12:00:00	AMZN	Stock	17.964	17.98	17.885	17.8876	3294240.0
2014-07-21 13:00:00	AMZN	Stock	17.8865	17.987	17.8779	17.983	3492500.0
2014-07-21 14:00:00	AMZN	Stock	17.9795	17.995	17.9155	17.9812	3271000.0
2014-07-21 15:00:00	AMZN	Stock	17.9778	18.0345	17.9636	17.988	7101360.0

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

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