PREVIEW / stock_1hour / 2015-03-09

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-03-09.parquet
  size:    1.0 MB
  rows:    48,948
  symbols: 3,517

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
2015-03-09 04:00:00	AAPL	Stock	32.0025	32.0025	31.9	31.955	32288.0
2015-03-09 05:00:00	AAPL	Stock	31.9725	32.0225	31.95	31.955	57852.0
2015-03-09 06:00:00	AAPL	Stock	31.9475	32.0	31.9325	31.955	112648.0
2015-03-09 07:00:00	AAPL	Stock	31.95	31.955	31.875	31.9125	263200.0
2015-03-09 08:00:00	AAPL	Stock	31.9125	32.025	31.8625	31.9625	1596916.0
2015-03-09 09:00:00	AAPL	Stock	31.9575	32.0575	31.8025	31.8825	24392288.0
2015-03-09 10:00:00	AAPL	Stock	31.88	32.025	31.83	31.9875	29569728.0
2015-03-09 11:00:00	AAPL	Stock	31.9875	31.9925	31.8675	31.8975	17071960.0
2015-03-09 12:00:00	AAPL	Stock	31.8975	31.9075	31.7875	31.79	19628196.0
2015-03-09 13:00:00	AAPL	Stock	31.7925	32.3925	31.77	32.1425	75256240.0
2015-03-09 14:00:00	AAPL	Stock	32.14	32.21	31.265	31.6125	103888512.0
2015-03-09 15:00:00	AAPL	Stock	31.6125	31.895	31.5875	31.7775	51783724.0
2015-03-09 16:00:00	AAPL	Stock	31.785	31.9572	31.6738	31.8375	9608848.0
2015-03-09 17:00:00	AAPL	Stock	31.8375	31.8902	31.785	31.81	215060.0
2015-03-09 18:00:00	AAPL	Stock	31.8	31.82	31.775	31.7875	139080.0
2015-03-09 19:00:00	AAPL	Stock	31.7872	31.8025	31.7525	31.77	213852.0
2015-03-09 07:00:00	MSFT	Stock	42.29	42.33	42.29	42.33	1100.0
2015-03-09 08:00:00	MSFT	Stock	42.15	42.41	42.15	42.36	6979.0
2015-03-09 09:00:00	MSFT	Stock	42.361	42.48	42.19	42.445	3744408.0
2015-03-09 10:00:00	MSFT	Stock	42.44	42.49	42.24	42.38	4494009.0
2015-03-09 11:00:00	MSFT	Stock	42.37	42.6	42.34	42.565	3734706.0
2015-03-09 12:00:00	MSFT	Stock	42.57	42.82	42.54	42.805	2296022.0
2015-03-09 13:00:00	MSFT	Stock	42.8	43.125	42.8	43.05	3879852.0
2015-03-09 14:00:00	MSFT	Stock	43.05	43.1	42.93	43.09	3748964.0
2015-03-09 15:00:00	MSFT	Stock	43.095	43.1	42.82	42.83	6123748.0
2015-03-09 16:00:00	MSFT	Stock	42.85	42.888	42.7	42.85	2612274.0
2015-03-09 17:00:00	MSFT	Stock	42.732	42.972	42.732	42.972	6154.0
2015-03-09 18:00:00	MSFT	Stock	42.88	42.88	42.88	42.88	200.0
2015-03-09 19:00:00	MSFT	Stock	42.81	42.81	42.81	42.81	350.0
2015-03-09 09:00:00	NVDA	Stock	0.564	0.5695	0.5638	0.5679	28773640.0
2015-03-09 10:00:00	NVDA	Stock	0.5679	0.568	0.5628	0.5646	37356560.0
2015-03-09 11:00:00	NVDA	Stock	0.5646	0.5685	0.5638	0.5645	27962640.0
2015-03-09 12:00:00	NVDA	Stock	0.5645	0.5661	0.5635	0.566	17180440.0
2015-03-09 13:00:00	NVDA	Stock	0.566	0.5672	0.5652	0.5671	14125560.0
2015-03-09 14:00:00	NVDA	Stock	0.5672	0.5682	0.5668	0.5675	23600520.0
2015-03-09 15:00:00	NVDA	Stock	0.5674	0.568	0.5652	0.5652	46814320.0
2015-03-09 16:00:00	NVDA	Stock	0.5654	0.5661	0.5652	0.5661	21500680.0
2015-03-09 17:00:00	NVDA	Stock	0.5661	0.5661	0.5661	0.5661	331840.0
2015-03-09 06:00:00	AMZN	Stock	18.945	18.945	18.8265	18.83	91440.0
2015-03-09 07:00:00	AMZN	Stock	18.844	18.891	18.834	18.891	96040.0
2015-03-09 08:00:00	AMZN	Stock	18.875	18.94	18.8555	18.892	181280.0
2015-03-09 09:00:00	AMZN	Stock	18.9	18.9665	18.7725	18.8565	9341400.0
2015-03-09 10:00:00	AMZN	Stock	18.866	18.889	18.775	18.7955	7014940.0
2015-03-09 11:00:00	AMZN	Stock	18.7974	18.8975	18.764	18.8425	7161640.0
2015-03-09 12:00:00	AMZN	Stock	18.8493	18.8605	18.7985	18.853	3118040.0
2015-03-09 13:00:00	AMZN	Stock	18.855	18.942	18.81	18.871	4159320.0
2015-03-09 14:00:00	AMZN	Stock	18.875	18.894	18.8225	18.894	3834180.0
2015-03-09 15:00:00	AMZN	Stock	18.896	18.962	18.8765	18.928	5461960.0
2015-03-09 16:00:00	AMZN	Stock	18.928	18.959	18.8654	18.89	582320.0
2015-03-09 17:00:00	AMZN	Stock	18.8641	18.928	18.8641	18.928	118600.0

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

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