PREVIEW / stock_1hour / 2017-06-27

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-06-27.parquet
  size:    1.0 MB
  rows:    48,151
  symbols: 3,013

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-27 04:00:00	AAPL	Stock	36.3025	36.305	36.265	36.285	7460.0
2017-06-27 05:00:00	AAPL	Stock	36.285	36.325	36.225	36.225	22996.0
2017-06-27 06:00:00	AAPL	Stock	36.2	36.25	36.185	36.2475	48932.0
2017-06-27 07:00:00	AAPL	Stock	36.25	36.325	36.2325	36.305	115636.0
2017-06-27 08:00:00	AAPL	Stock	36.3125	36.3625	36.25	36.31	217324.0
2017-06-27 09:00:00	AAPL	Stock	36.2975	36.4148	36.1925	36.325	11794252.0
2017-06-27 10:00:00	AAPL	Stock	36.325	36.54	36.3125	36.4575	10501564.0
2017-06-27 11:00:00	AAPL	Stock	36.4575	36.5	36.3625	36.4075	6508292.0
2017-06-27 12:00:00	AAPL	Stock	36.4075	36.48	36.235	36.2688	8353524.0
2017-06-27 13:00:00	AAPL	Stock	36.2688	36.295	35.9875	36.1225	14357516.0
2017-06-27 14:00:00	AAPL	Stock	36.1225	36.17	36.0375	36.1425	10404056.0
2017-06-27 15:00:00	AAPL	Stock	36.1425	36.195	35.905	35.945	20969872.0
2017-06-27 16:00:00	AAPL	Stock	35.9325	35.9875	35.875	35.9325	7275408.0
2017-06-27 17:00:00	AAPL	Stock	35.935	35.9525	35.9025	35.905	119356.0
2017-06-27 18:00:00	AAPL	Stock	35.905	35.9375	35.905	35.9375	27724.0
2017-06-27 19:00:00	AAPL	Stock	35.925	35.9325	35.83	35.85	44064.0
2017-06-27 04:00:00	MSFT	Stock	70.53	70.53	70.45	70.45	2141.0
2017-06-27 07:00:00	MSFT	Stock	70.15	70.25	70.15	70.25	901.0
2017-06-27 08:00:00	MSFT	Stock	70.35	70.35	70.16	70.16	6320.0
2017-06-27 09:00:00	MSFT	Stock	70.15	70.33	69.81	69.86	2613020.0
2017-06-27 10:00:00	MSFT	Stock	69.85	70.11	69.81	70.04	2873189.0
2017-06-27 11:00:00	MSFT	Stock	70.04	70.18	69.94	70.015	1885495.0
2017-06-27 12:00:00	MSFT	Stock	70.02	70.07	69.67	69.749	2013132.0
2017-06-27 13:00:00	MSFT	Stock	69.75	69.81	69.325	69.41	3231728.0
2017-06-27 14:00:00	MSFT	Stock	69.41	69.69	69.21	69.53	2667443.0
2017-06-27 15:00:00	MSFT	Stock	69.53	69.66	69.18	69.21	5710106.0
2017-06-27 16:00:00	MSFT	Stock	69.21	69.992	69.21	69.24	2564550.0
2017-06-27 17:00:00	MSFT	Stock	69.24	69.38	69.22	69.22	1254.0
2017-06-27 18:00:00	MSFT	Stock	69.21	69.21	69.21	69.21	150.0
2017-06-27 19:00:00	MSFT	Stock	69.29	69.29	69.25	69.25	200.0
2017-06-27 04:00:00	NVDA	Stock	3.85	3.85	3.77	3.7825	84560.0
2017-06-27 05:00:00	NVDA	Stock	3.805	3.805	3.805	3.805	12600.0
2017-06-27 06:00:00	NVDA	Stock	3.8038	3.8038	3.8	3.8	16800.0
2017-06-27 07:00:00	NVDA	Stock	3.8125	3.8125	3.7938	3.7938	198680.0
2017-06-27 08:00:00	NVDA	Stock	3.8248	3.8312	3.7938	3.8	2879000.0
2017-06-27 09:00:00	NVDA	Stock	3.8	3.8038	3.7308	3.7565	136481160.0
2017-06-27 10:00:00	NVDA	Stock	3.758	3.7875	3.751	3.7795	125524040.0
2017-06-27 11:00:00	NVDA	Stock	3.7795	3.7882	3.745	3.7485	82603840.0
2017-06-27 12:00:00	NVDA	Stock	3.7485	3.772	3.7102	3.7165	136760560.0
2017-06-27 13:00:00	NVDA	Stock	3.716	3.722	3.683	3.6995	184306320.0
2017-06-27 14:00:00	NVDA	Stock	3.6998	3.7195	3.6738	3.7035	137909200.0
2017-06-27 15:00:00	NVDA	Stock	3.703	3.7085	3.6588	3.665	159364960.0
2017-06-27 16:00:00	NVDA	Stock	3.663	3.672	3.6592	3.6648	4270840.0
2017-06-27 17:00:00	NVDA	Stock	3.6645	3.665	3.663	3.663	490200.0
2017-06-27 18:00:00	NVDA	Stock	3.6625	3.6658	3.6625	3.6645	315560.0
2017-06-27 19:00:00	NVDA	Stock	3.6658	3.6658	3.65	3.65	983520.0
2017-06-27 04:00:00	AMZN	Stock	49.7	49.7	49.6	49.6	21740.0
2017-06-27 07:00:00	AMZN	Stock	49.65	49.65	49.4805	49.5	67780.0
2017-06-27 08:00:00	AMZN	Stock	49.498	49.5	49.4255	49.43	332540.0
2017-06-27 09:00:00	AMZN	Stock	49.465	49.8845	49.3055	49.6378	9612240.0

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

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