PREVIEW / stock_1hour / 2018-05-30

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-05-30.parquet
  size:    1.1 MB
  rows:    49,864
  symbols: 2,821

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-05-30 04:00:00	AAPL	Stock	47.05	47.1375	47.05	47.1375	3356.0
2018-05-30 05:00:00	AAPL	Stock	47.0275	47.14	47.0275	47.14	10488.0
2018-05-30 06:00:00	AAPL	Stock	47.13	47.155	47.1075	47.1075	14356.0
2018-05-30 07:00:00	AAPL	Stock	47.105	47.145	46.9525	46.9875	216516.0
2018-05-30 08:00:00	AAPL	Stock	47.1	47.125	46.9025	46.91	324160.0
2018-05-30 09:00:00	AAPL	Stock	46.9075	47.0	46.765	46.78	8986976.0
2018-05-30 10:00:00	AAPL	Stock	46.78	46.8525	46.695	46.765	11440408.0
2018-05-30 11:00:00	AAPL	Stock	46.7675	46.8225	46.7025	46.7775	7189884.0
2018-05-30 12:00:00	AAPL	Stock	46.7775	46.885	46.7525	46.805	7092552.0
2018-05-30 13:00:00	AAPL	Stock	46.8068	46.8775	46.7425	46.835	6026616.0
2018-05-30 14:00:00	AAPL	Stock	46.8425	46.8975	46.8275	46.885	5433348.0
2018-05-30 15:00:00	AAPL	Stock	46.885	46.9275	46.775	46.875	11556776.0
2018-05-30 16:00:00	AAPL	Stock	46.86	46.875	46.8375	46.8375	4903072.0
2018-05-30 17:00:00	AAPL	Stock	46.8375	46.8625	46.825	46.8375	24228.0
2018-05-30 18:00:00	AAPL	Stock	46.8175	46.845	46.7675	46.8	35604.0
2018-05-30 19:00:00	AAPL	Stock	46.8	46.8	46.765	46.7925	31256.0
2018-05-30 04:00:00	MSFT	Stock	98.5	98.5	98.5	98.5	259.0
2018-05-30 05:00:00	MSFT	Stock	98.6	98.6	98.6	98.6	300.0
2018-05-30 06:00:00	MSFT	Stock	98.53	98.6	98.52	98.6	1003.0
2018-05-30 07:00:00	MSFT	Stock	98.51	98.74	98.45	98.5	5318.0
2018-05-30 08:00:00	MSFT	Stock	98.79	98.79	98.4	98.4	15356.0
2018-05-30 09:00:00	MSFT	Stock	98.45	99.25	98.3	98.46	3156871.0
2018-05-30 10:00:00	MSFT	Stock	98.46	98.59	97.91	98.51	3809250.0
2018-05-30 11:00:00	MSFT	Stock	98.505	98.86	98.42	98.796	2001631.0
2018-05-30 12:00:00	MSFT	Stock	98.8	98.93	98.66	98.8	1461517.0
2018-05-30 13:00:00	MSFT	Stock	98.8	99.039	98.65	98.865	1670816.0
2018-05-30 14:00:00	MSFT	Stock	98.87	99.06	98.81	98.845	1676289.0
2018-05-30 15:00:00	MSFT	Stock	98.85	99.06	98.81	98.91	3438307.0
2018-05-30 16:00:00	MSFT	Stock	98.95	99.02	98.81	98.83	2140167.0
2018-05-30 17:00:00	MSFT	Stock	98.9	98.9	98.85	98.85	1523.0
2018-05-30 18:00:00	MSFT	Stock	98.83	98.83	98.82	98.83	720.0
2018-05-30 19:00:00	MSFT	Stock	98.88	98.88	98.88	98.88	355.0
2018-05-30 04:00:00	NVDA	Stock	6.235	6.245	6.2323	6.24	128200.0
2018-05-30 05:00:00	NVDA	Stock	6.24	6.25	6.24	6.25	33920.0
2018-05-30 06:00:00	NVDA	Stock	6.2575	6.2575	6.25	6.25	37520.0
2018-05-30 07:00:00	NVDA	Stock	6.25	6.2525	6.2358	6.244	374760.0
2018-05-30 08:00:00	NVDA	Stock	6.2468	6.2563	6.2323	6.2438	1876760.0
2018-05-30 09:00:00	NVDA	Stock	6.2438	6.2795	6.2238	6.265	61154280.0
2018-05-30 10:00:00	NVDA	Stock	6.2675	6.309	6.2625	6.302	79726240.0
2018-05-30 11:00:00	NVDA	Stock	6.3035	6.3192	6.288	6.2978	43877960.0
2018-05-30 12:00:00	NVDA	Stock	6.2993	6.3132	6.266	6.275	41049840.0
2018-05-30 13:00:00	NVDA	Stock	6.275	6.2952	6.2593	6.2818	27677920.0
2018-05-30 14:00:00	NVDA	Stock	6.2818	6.3112	6.2788	6.3112	29626200.0
2018-05-30 15:00:00	NVDA	Stock	6.3112	6.3335	6.3058	6.3248	63497360.0
2018-05-30 16:00:00	NVDA	Stock	6.3248	6.3275	6.3199	6.323	10203840.0
2018-05-30 17:00:00	NVDA	Stock	6.323	6.3248	6.3188	6.3248	1426320.0
2018-05-30 18:00:00	NVDA	Stock	6.32	6.3215	6.3188	6.3188	99040.0
2018-05-30 19:00:00	NVDA	Stock	6.3188	6.3225	6.3178	6.3225	187560.0
2018-05-30 04:00:00	AMZN	Stock	81.1	81.3825	81.1	81.1	13280.0
2018-05-30 05:00:00	AMZN	Stock	81.14	81.14	81.14	81.14	2400.0

> showing 50 of 49,864 rows — these rows as CSV

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