PREVIEW / stock_1hour / 2014-12-19

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-12-19.parquet
  size:    1.1 MB
  rows:    50,906
  symbols: 3,579

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-12-19 04:00:00	AAPL	Stock	28.1375	28.3375	28.1375	28.33	25632.0
2014-12-19 05:00:00	AAPL	Stock	28.315	28.3475	28.25	28.28	17520.0
2014-12-19 06:00:00	AAPL	Stock	28.25	28.275	28.2225	28.225	68268.0
2014-12-19 07:00:00	AAPL	Stock	28.2375	28.3125	28.2375	28.2375	247384.0
2014-12-19 08:00:00	AAPL	Stock	28.235	28.3125	28.1525	28.195	915944.0
2014-12-19 09:00:00	AAPL	Stock	28.1925	28.1925	27.9	28.0768	82263248.0
2014-12-19 10:00:00	AAPL	Stock	28.0775	28.31	28.0425	28.2	34091280.0
2014-12-19 11:00:00	AAPL	Stock	28.1925	28.2075	28.0262	28.07	18515280.0
2014-12-19 12:00:00	AAPL	Stock	28.0675	28.1375	28.01	28.0922	14138416.0
2014-12-19 13:00:00	AAPL	Stock	28.09	28.1075	28.0175	28.0175	12511656.0
2014-12-19 14:00:00	AAPL	Stock	28.0175	28.1125	28.0162	28.095	14906064.0
2014-12-19 15:00:00	AAPL	Stock	28.1	28.1025	27.94	27.94	41506448.0
2014-12-19 16:00:00	AAPL	Stock	27.9475	28.1598	27.9395	27.95	111964760.0
2014-12-19 17:00:00	AAPL	Stock	27.9475	28.08	27.944	27.9725	7059764.0
2014-12-19 18:00:00	AAPL	Stock	27.9725	27.985	27.9448	27.9625	254404.0
2014-12-19 19:00:00	AAPL	Stock	27.9725	27.975	27.9475	27.9625	88104.0
2014-12-19 04:00:00	MSFT	Stock	47.6	47.7	47.6	47.7	3100.0
2014-12-19 06:00:00	MSFT	Stock	47.7	47.7	47.7	47.7	650.0
2014-12-19 07:00:00	MSFT	Stock	47.75	47.83	47.69	47.7	12067.0
2014-12-19 08:00:00	MSFT	Stock	47.74	47.84	47.58	47.65	11172.0
2014-12-19 09:00:00	MSFT	Stock	47.64	47.89	47.17	47.885	22733682.0
2014-12-19 10:00:00	MSFT	Stock	47.895	47.91	47.66	47.845	3446750.0
2014-12-19 11:00:00	MSFT	Stock	47.84	47.99	47.77	47.9	2717682.0
2014-12-19 12:00:00	MSFT	Stock	47.9	47.91	47.75	47.77	2283754.0
2014-12-19 13:00:00	MSFT	Stock	47.77	47.87	47.73	47.821	2067364.0
2014-12-19 14:00:00	MSFT	Stock	47.82	48.005	47.767	47.99	2439197.0
2014-12-19 15:00:00	MSFT	Stock	48.0	48.1	47.38	47.62	9192614.0
2014-12-19 16:00:00	MSFT	Stock	47.66	47.943	47.607	47.67	18109340.0
2014-12-19 17:00:00	MSFT	Stock	47.67	47.833	47.64	47.656	30346.0
2014-12-19 18:00:00	MSFT	Stock	47.66	47.66	47.659	47.659	37075.0
2014-12-19 19:00:00	MSFT	Stock	47.66	47.66	47.66	47.66	3100.0
2014-12-19 08:00:00	NVDA	Stock	0.5135	0.5138	0.5135	0.5138	296000.0
2014-12-19 09:00:00	NVDA	Stock	0.5138	0.5142	0.5043	0.5093	67921360.0
2014-12-19 10:00:00	NVDA	Stock	0.5093	0.5095	0.505	0.5071	18384160.0
2014-12-19 11:00:00	NVDA	Stock	0.507	0.5088	0.5068	0.508	15166920.0
2014-12-19 12:00:00	NVDA	Stock	0.5078	0.51	0.5078	0.5088	17244440.0
2014-12-19 13:00:00	NVDA	Stock	0.5088	0.5088	0.5048	0.5075	15262920.0
2014-12-19 14:00:00	NVDA	Stock	0.5075	0.5088	0.5065	0.5084	13653560.0
2014-12-19 15:00:00	NVDA	Stock	0.5085	0.512	0.5078	0.5105	65707280.0
2014-12-19 16:00:00	NVDA	Stock	0.5105	0.5108	0.5061	0.5104	100583840.0
2014-12-19 17:00:00	NVDA	Stock	0.5079	0.5079	0.5079	0.5079	1048240.0
2014-12-19 18:00:00	NVDA	Stock	0.5105	0.5105	0.5105	0.5105	76360.0
2014-12-19 06:00:00	AMZN	Stock	14.95	15.0	14.95	15.0	6700.0
2014-12-19 07:00:00	AMZN	Stock	15.0	15.0	15.0	15.0	13720.0
2014-12-19 08:00:00	AMZN	Stock	15.0	15.0295	14.8985	14.9005	499280.0
2014-12-19 09:00:00	AMZN	Stock	14.912	14.9245	14.701	14.844	33601500.0
2014-12-19 10:00:00	AMZN	Stock	14.8455	15.077	14.8335	15.0475	21449840.0
2014-12-19 11:00:00	AMZN	Stock	15.0475	15.0625	14.979	15.0128	16512440.0
2014-12-19 12:00:00	AMZN	Stock	15.0125	15.0175	14.9255	14.9928	9950880.0
2014-12-19 13:00:00	AMZN	Stock	14.996	15.036	14.99	15.001	13421720.0

> showing 50 of 50,906 rows — these rows as CSV

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