PREVIEW / stock_1hour / 2018-02-09

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-02-09.parquet
  size:    1.1 MB
  rows:    50,930
  symbols: 2,906

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
2018-02-09 04:00:00	AAPL	Stock	39.1275	39.225	39.07	39.1175	48676.0
2018-02-09 05:00:00	AAPL	Stock	39.1025	39.2125	39.0025	39.1675	35828.0
2018-02-09 06:00:00	AAPL	Stock	39.1675	39.1675	38.8825	39.025	155564.0
2018-02-09 07:00:00	AAPL	Stock	39.03	39.1025	38.8325	38.86	241128.0
2018-02-09 08:00:00	AAPL	Stock	38.885	39.2925	38.8525	39.25	572988.0
2018-02-09 09:00:00	AAPL	Stock	39.2525	39.4575	38.9528	39.29	25008340.0
2018-02-09 10:00:00	AAPL	Stock	39.2925	39.4725	38.685	38.975	34330528.0
2018-02-09 11:00:00	AAPL	Stock	38.98	39.12	38.715	38.7408	23049784.0
2018-02-09 12:00:00	AAPL	Stock	38.7375	38.8375	37.8675	38.4835	33426648.0
2018-02-09 13:00:00	AAPL	Stock	38.4825	38.485	37.56	37.9425	33634832.0
2018-02-09 14:00:00	AAPL	Stock	37.9375	38.8725	37.9	38.6825	31420872.0
2018-02-09 15:00:00	AAPL	Stock	38.6875	39.295	38.365	39.055	38202596.0
2018-02-09 16:00:00	AAPL	Stock	39.1025	39.1175	38.98	39.0575	13375488.0
2018-02-09 17:00:00	AAPL	Stock	39.0575	39.17	39.0575	39.15	325308.0
2018-02-09 18:00:00	AAPL	Stock	39.125	39.18	39.125	39.175	57276.0
2018-02-09 19:00:00	AAPL	Stock	39.165	39.185	39.1375	39.185	44564.0
2018-02-09 04:00:00	MSFT	Stock	85.99	86.0	85.99	86.0	1490.0
2018-02-09 05:00:00	MSFT	Stock	85.79	86.05	85.69	86.04	24438.0
2018-02-09 06:00:00	MSFT	Stock	86.1	86.19	85.25	85.75	31338.0
2018-02-09 07:00:00	MSFT	Stock	85.77	85.85	85.17	85.19	25117.0
2018-02-09 08:00:00	MSFT	Stock	85.87	86.24	85.17	86.2	78415.0
2018-02-09 09:00:00	MSFT	Stock	86.2	87.28	85.84	86.89	5627400.0
2018-02-09 10:00:00	MSFT	Stock	86.9	87.47	86.11	86.89	6603221.0
2018-02-09 11:00:00	MSFT	Stock	86.91	87.595	86.345	86.39	5568167.0
2018-02-09 12:00:00	MSFT	Stock	86.39	86.49	84.13	85.54	7012797.0
2018-02-09 13:00:00	MSFT	Stock	85.53	85.55	83.83	84.84	6423003.0
2018-02-09 14:00:00	MSFT	Stock	84.83	88.03	84.8	86.945	9935173.0
2018-02-09 15:00:00	MSFT	Stock	86.95	88.93	86.01	88.15	11664077.0
2018-02-09 16:00:00	MSFT	Stock	88.18	88.69	87.81	88.15	4715178.0
2018-02-09 17:00:00	MSFT	Stock	88.15	88.4	88.15	88.23	68238.0
2018-02-09 18:00:00	MSFT	Stock	88.43	88.5	88.36	88.5	4100.0
2018-02-09 19:00:00	MSFT	Stock	88.45	88.57	88.45	88.52	6860.0
2018-02-09 04:00:00	NVDA	Stock	5.925	5.9875	5.9	5.9812	589480.0
2018-02-09 05:00:00	NVDA	Stock	5.9975	6.0125	5.9663	5.9773	499280.0
2018-02-09 06:00:00	NVDA	Stock	5.991	6.0658	5.875	5.9403	1478000.0
2018-02-09 07:00:00	NVDA	Stock	5.944	5.9875	5.8308	5.8375	4875960.0
2018-02-09 08:00:00	NVDA	Stock	5.8328	6.0	5.8308	5.9625	14179760.0
2018-02-09 09:00:00	NVDA	Stock	5.95	5.975	5.6515	5.8394	292715040.0
2018-02-09 10:00:00	NVDA	Stock	5.846	5.88	5.475	5.59	273807360.0
2018-02-09 11:00:00	NVDA	Stock	5.5934	5.6987	5.5815	5.6074	114129560.0
2018-02-09 12:00:00	NVDA	Stock	5.6046	5.625	5.438	5.5725	166294280.0
2018-02-09 13:00:00	NVDA	Stock	5.5712	5.724	5.5113	5.6895	129528000.0
2018-02-09 14:00:00	NVDA	Stock	5.6912	5.8528	5.6638	5.743	204291160.0
2018-02-09 15:00:00	NVDA	Stock	5.743	5.8375	5.6565	5.7865	199532040.0
2018-02-09 16:00:00	NVDA	Stock	5.802	5.8192	5.7763	5.808	26496120.0
2018-02-09 17:00:00	NVDA	Stock	5.8125	5.8188	5.802	5.8118	624480.0
2018-02-09 18:00:00	NVDA	Stock	5.8075	5.8148	5.8028	5.8105	551200.0
2018-02-09 19:00:00	NVDA	Stock	5.811	5.815	5.8053	5.8125	731560.0
2018-02-09 04:00:00	AMZN	Stock	67.7505	68.0	67.7505	68.0	39280.0
2018-02-09 05:00:00	AMZN	Stock	68.1945	68.1945	67.833	67.9695	70500.0

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

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