PREVIEW / stock_1hour / 2018-04-23

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-04-23.parquet
  size:    1.1 MB
  rows:    48,425
  symbols: 2,854

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-04-23 04:00:00	AAPL	Stock	41.505	41.505	41.5	41.5	3600.0
2018-04-23 05:00:00	AAPL	Stock	41.525	41.5475	41.525	41.525	5728.0
2018-04-23 06:00:00	AAPL	Stock	41.525	41.6675	41.5	41.6625	27824.0
2018-04-23 07:00:00	AAPL	Stock	41.6375	41.805	41.6225	41.775	438188.0
2018-04-23 08:00:00	AAPL	Stock	41.775	41.815	41.625	41.6625	938904.0
2018-04-23 09:00:00	AAPL	Stock	41.6625	41.7375	41.3025	41.48	21203116.0
2018-04-23 10:00:00	AAPL	Stock	41.4775	41.7	41.4	41.646	19755956.0
2018-04-23 11:00:00	AAPL	Stock	41.645	41.6862	41.585	41.635	12495824.0
2018-04-23 12:00:00	AAPL	Stock	41.635	41.655	41.2	41.245	17046800.0
2018-04-23 13:00:00	AAPL	Stock	41.2425	41.3225	41.1375	41.2575	11178852.0
2018-04-23 14:00:00	AAPL	Stock	41.255	41.2825	41.0225	41.075	14150104.0
2018-04-23 15:00:00	AAPL	Stock	41.0725	41.315	41.055	41.3125	16940704.0
2018-04-23 16:00:00	AAPL	Stock	41.31	41.4075	41.25	41.3025	16891756.0
2018-04-23 17:00:00	AAPL	Stock	41.31	41.325	41.275	41.275	1805292.0
2018-04-23 18:00:00	AAPL	Stock	41.275	41.32	41.275	41.3025	23736.0
2018-04-23 19:00:00	AAPL	Stock	41.3025	41.3375	41.2625	41.2875	98380.0
2018-04-23 07:00:00	MSFT	Stock	95.38	95.4	95.21	95.39	13913.0
2018-04-23 08:00:00	MSFT	Stock	95.39	95.65	95.3	95.65	22636.0
2018-04-23 09:00:00	MSFT	Stock	95.64	95.77	95.03	95.45	2159574.0
2018-04-23 10:00:00	MSFT	Stock	95.46	96.09	95.18	95.94	2686402.0
2018-04-23 11:00:00	MSFT	Stock	95.94	96.29	95.73	95.855	2444462.0
2018-04-23 12:00:00	MSFT	Stock	95.86	95.915	95.295	95.4	1653179.0
2018-04-23 13:00:00	MSFT	Stock	95.4	95.59	95.225	95.37	1542897.0
2018-04-23 14:00:00	MSFT	Stock	95.375	95.41	94.64	94.695	2025899.0
2018-04-23 15:00:00	MSFT	Stock	94.69	95.4	94.63	95.36	3512834.0
2018-04-23 16:00:00	MSFT	Stock	95.35	95.79	95.2	95.47	2314353.0
2018-04-23 17:00:00	MSFT	Stock	95.35	95.47	95.22	95.46	674647.0
2018-04-23 18:00:00	MSFT	Stock	95.47	95.49	95.22	95.49	1777.0
2018-04-23 19:00:00	MSFT	Stock	95.45	95.49	95.45	95.49	1312.0
2018-04-23 04:00:00	NVDA	Stock	5.7095	5.7098	5.6875	5.6875	29560.0
2018-04-23 05:00:00	NVDA	Stock	5.6875	5.7013	5.6875	5.7013	28040.0
2018-04-23 06:00:00	NVDA	Stock	5.7093	5.7098	5.7093	5.7098	28000.0
2018-04-23 07:00:00	NVDA	Stock	5.7125	5.725	5.7075	5.7175	84800.0
2018-04-23 08:00:00	NVDA	Stock	5.7225	5.75	5.7075	5.7388	841280.0
2018-04-23 09:00:00	NVDA	Stock	5.7435	5.7875	5.6913	5.7265	53416200.0
2018-04-23 10:00:00	NVDA	Stock	5.7278	5.7438	5.6851	5.7388	46541080.0
2018-04-23 11:00:00	NVDA	Stock	5.737	5.7655	5.72	5.7262	36539440.0
2018-04-23 12:00:00	NVDA	Stock	5.7275	5.7278	5.628	5.6419	50184040.0
2018-04-23 13:00:00	NVDA	Stock	5.6435	5.677	5.608	5.6208	56893240.0
2018-04-23 14:00:00	NVDA	Stock	5.6203	5.6225	5.5708	5.5938	46193440.0
2018-04-23 15:00:00	NVDA	Stock	5.5918	5.6083	5.5795	5.597	50035440.0
2018-04-23 16:00:00	NVDA	Stock	5.597	5.615	5.5903	5.5903	42057040.0
2018-04-23 17:00:00	NVDA	Stock	5.597	5.6062	5.597	5.5988	2275400.0
2018-04-23 18:00:00	NVDA	Stock	5.6023	5.6023	5.5878	5.59	221680.0
2018-04-23 19:00:00	NVDA	Stock	5.5913	5.6062	5.59	5.6	172640.0
2018-04-23 04:00:00	AMZN	Stock	76.6	76.641	76.55	76.641	18000.0
2018-04-23 05:00:00	AMZN	Stock	76.7035	76.7035	76.7035	76.7035	2000.0
2018-04-23 06:00:00	AMZN	Stock	76.705	76.7565	76.705	76.75	17260.0
2018-04-23 07:00:00	AMZN	Stock	76.85	76.9075	76.7835	76.8995	106740.0
2018-04-23 08:00:00	AMZN	Stock	76.9015	77.22	76.7525	77.2	540980.0

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

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