PREVIEW / stock_1hour / 2017-06-12

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-06-12.parquet
  size:    1.0 MB
  rows:    48,306
  symbols: 3,033

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
2017-06-12 04:00:00	AAPL	Stock	36.9725	36.9825	36.275	36.325	221944.0
2017-06-12 05:00:00	AAPL	Stock	36.3425	36.4475	36.325	36.4275	68840.0
2017-06-12 06:00:00	AAPL	Stock	36.4275	36.6125	36.425	36.515	61816.0
2017-06-12 07:00:00	AAPL	Stock	36.5375	36.6075	36.375	36.42	435652.0
2017-06-12 08:00:00	AAPL	Stock	36.42	36.7475	36.3325	36.5975	1591636.0
2017-06-12 09:00:00	AAPL	Stock	36.58	36.8	35.6275	35.8775	76478572.0
2017-06-12 10:00:00	AAPL	Stock	35.8825	36.315	35.735	36.2275	50645940.0
2017-06-12 11:00:00	AAPL	Stock	36.2275	36.5225	36.175	36.265	31677544.0
2017-06-12 12:00:00	AAPL	Stock	36.265	36.315	35.9	35.9125	20597908.0
2017-06-12 13:00:00	AAPL	Stock	35.9125	36.06	35.8425	35.8725	17149424.0
2017-06-12 14:00:00	AAPL	Stock	35.8725	36.1425	35.85	36.0325	18680456.0
2017-06-12 15:00:00	AAPL	Stock	36.0325	36.365	35.99	36.35	31313348.0
2017-06-12 16:00:00	AAPL	Stock	36.355	36.365	36.2825	36.3475	11017756.0
2017-06-12 17:00:00	AAPL	Stock	36.3475	36.355	36.3375	36.3525	164952.0
2017-06-12 18:00:00	AAPL	Stock	36.3525	36.3775	36.3275	36.3725	118408.0
2017-06-12 19:00:00	AAPL	Stock	36.37	36.425	36.37	36.4	63100.0
2017-06-12 04:00:00	MSFT	Stock	69.53	69.53	69.53	69.53	1358.0
2017-06-12 05:00:00	MSFT	Stock	69.62	69.62	69.62	69.62	639.0
2017-06-12 06:00:00	MSFT	Stock	69.62	69.75	69.6	69.75	1884.0
2017-06-12 07:00:00	MSFT	Stock	69.66	69.66	69.13	69.2	19813.0
2017-06-12 08:00:00	MSFT	Stock	69.66	69.76	69.03	69.76	49983.0
2017-06-12 09:00:00	MSFT	Stock	69.5	70.19	68.13	68.55	10939615.0
2017-06-12 10:00:00	MSFT	Stock	68.55	69.31	68.45	69.205	9338271.0
2017-06-12 11:00:00	MSFT	Stock	69.2	69.56	69.02	69.36	5930407.0
2017-06-12 12:00:00	MSFT	Stock	69.36	69.4	69.03	69.33	3860383.0
2017-06-12 13:00:00	MSFT	Stock	69.33	69.59	69.19	69.5	2563208.0
2017-06-12 14:00:00	MSFT	Stock	69.5	69.94	69.445	69.725	3231525.0
2017-06-12 15:00:00	MSFT	Stock	69.72	69.88	69.45	69.78	5716656.0
2017-06-12 16:00:00	MSFT	Stock	69.77	69.8	69.63	69.77	3176914.0
2017-06-12 17:00:00	MSFT	Stock	69.7	69.78	69.7	69.78	2000.0
2017-06-12 18:00:00	MSFT	Stock	69.73	69.73	69.73	69.73	1900.0
2017-06-12 19:00:00	MSFT	Stock	69.79	69.79	69.78	69.78	1491.0
2017-06-12 04:00:00	NVDA	Stock	3.7525	3.7525	3.6462	3.6515	1246200.0
2017-06-12 05:00:00	NVDA	Stock	3.6575	3.6852	3.6525	3.675	287800.0
2017-06-12 06:00:00	NVDA	Stock	3.6763	3.6998	3.67	3.6992	777440.0
2017-06-12 07:00:00	NVDA	Stock	3.6952	3.6952	3.6498	3.655	3990240.0
2017-06-12 08:00:00	NVDA	Stock	3.6578	3.6952	3.6068	3.6452	20767640.0
2017-06-12 09:00:00	NVDA	Stock	3.6472	3.6625	3.5528	3.595	346607360.0
2017-06-12 10:00:00	NVDA	Stock	3.5943	3.6862	3.575	3.6436	358275080.0
2017-06-12 11:00:00	NVDA	Stock	3.643	3.7925	3.64	3.7298	373137520.0
2017-06-12 12:00:00	NVDA	Stock	3.7292	3.7803	3.7	3.729	144755240.0
2017-06-12 13:00:00	NVDA	Stock	3.728	3.7763	3.7125	3.7215	106708800.0
2017-06-12 14:00:00	NVDA	Stock	3.7216	3.7675	3.717	3.7514	116422920.0
2017-06-12 15:00:00	NVDA	Stock	3.7505	3.7648	3.725	3.7492	139689040.0
2017-06-12 16:00:00	NVDA	Stock	3.7492	3.7688	3.7465	3.7638	17641280.0
2017-06-12 17:00:00	NVDA	Stock	3.7662	3.7775	3.7662	3.7768	1916720.0
2017-06-12 18:00:00	NVDA	Stock	3.7763	3.81	3.775	3.7905	3877400.0
2017-06-12 19:00:00	NVDA	Stock	3.79	3.799	3.788	3.7925	1453680.0
2017-06-12 04:00:00	AMZN	Stock	48.85	48.85	48.3095	48.3095	93480.0
2017-06-12 05:00:00	AMZN	Stock	48.3745	48.4055	48.25	48.2505	125000.0

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

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