PREVIEW / stock_1hour / 2018-08-27

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-27.parquet
  size:    1.1 MB
  rows:    49,843
  symbols: 2,810

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-08-27 04:00:00	AAPL	Stock	54.195	54.2625	54.195	54.2175	14856.0
2018-08-27 05:00:00	AAPL	Stock	54.2625	54.2625	54.2625	54.2625	400.0
2018-08-27 06:00:00	AAPL	Stock	54.26	54.2875	54.2475	54.2475	12752.0
2018-08-27 07:00:00	AAPL	Stock	54.225	54.2625	54.1975	54.205	141992.0
2018-08-27 08:00:00	AAPL	Stock	54.25	54.285	54.1975	54.2475	295776.0
2018-08-27 09:00:00	AAPL	Stock	54.24	54.43	54.0825	54.245	12034268.0
2018-08-27 10:00:00	AAPL	Stock	54.2525	54.48	54.1775	54.4785	12924952.0
2018-08-27 11:00:00	AAPL	Stock	54.4775	54.685	54.4325	54.6388	10901876.0
2018-08-27 12:00:00	AAPL	Stock	54.64	54.66	54.4922	54.575	6404564.0
2018-08-27 13:00:00	AAPL	Stock	54.5732	54.595	54.505	54.5525	3930640.0
2018-08-27 14:00:00	AAPL	Stock	54.5538	54.605	54.5275	54.5762	4349672.0
2018-08-27 15:00:00	AAPL	Stock	54.5762	54.5775	54.3875	54.4975	12155744.0
2018-08-27 16:00:00	AAPL	Stock	54.485	54.5	54.465	54.4875	7801844.0
2018-08-27 17:00:00	AAPL	Stock	54.4875	54.5	54.475	54.5	21696.0
2018-08-27 18:00:00	AAPL	Stock	54.5	54.515	54.49	54.5025	26168.0
2018-08-27 19:00:00	AAPL	Stock	54.515	54.54	54.515	54.54	36444.0
2018-08-27 04:00:00	MSFT	Stock	108.46	108.95	108.46	108.95	400.0
2018-08-27 06:00:00	MSFT	Stock	108.9	108.9	108.9	108.9	300.0
2018-08-27 07:00:00	MSFT	Stock	108.9	108.98	108.63	108.9	7117.0
2018-08-27 08:00:00	MSFT	Stock	108.99	109.1	108.65	109.08	22366.0
2018-08-27 09:00:00	MSFT	Stock	109.0	109.28	108.51	108.75	2333610.0
2018-08-27 10:00:00	MSFT	Stock	108.75	109.32	108.59	109.255	2758092.0
2018-08-27 11:00:00	MSFT	Stock	109.251	109.28	108.86	109.215	1780473.0
2018-08-27 12:00:00	MSFT	Stock	109.22	109.36	109.125	109.215	1479344.0
2018-08-27 13:00:00	MSFT	Stock	109.211	109.38	109.075	109.345	1045669.0
2018-08-27 14:00:00	MSFT	Stock	109.345	109.42	109.25	109.34	1213904.0
2018-08-27 15:00:00	MSFT	Stock	109.345	109.64	109.21	109.6	3183658.0
2018-08-27 16:00:00	MSFT	Stock	109.6	109.73	109.52	109.61	3300604.0
2018-08-27 17:00:00	MSFT	Stock	109.61	109.62	109.6	109.6	4131.0
2018-08-27 18:00:00	MSFT	Stock	109.62	109.65	109.61	109.65	2127.0
2018-08-27 19:00:00	MSFT	Stock	109.65	109.65	109.61	109.65	21548.0
2018-08-27 04:00:00	NVDA	Stock	6.8125	6.8125	6.7875	6.8025	118280.0
2018-08-27 05:00:00	NVDA	Stock	6.815	6.8175	6.8025	6.8175	116200.0
2018-08-27 06:00:00	NVDA	Stock	6.8128	6.825	6.8125	6.825	62040.0
2018-08-27 07:00:00	NVDA	Stock	6.8155	6.8488	6.8055	6.8463	477880.0
2018-08-27 08:00:00	NVDA	Stock	6.8238	6.8775	6.8105	6.8775	2339880.0
2018-08-27 09:00:00	NVDA	Stock	6.8838	6.8888	6.8036	6.85	77256000.0
2018-08-27 10:00:00	NVDA	Stock	6.8493	6.9198	6.8459	6.913	90528320.0
2018-08-27 11:00:00	NVDA	Stock	6.9131	6.925	6.895	6.9098	43964520.0
2018-08-27 12:00:00	NVDA	Stock	6.91	6.9365	6.9076	6.9361	37010920.0
2018-08-27 13:00:00	NVDA	Stock	6.9355	6.9725	6.9332	6.9578	57048240.0
2018-08-27 14:00:00	NVDA	Stock	6.9578	6.967	6.9078	6.9189	48038920.0
2018-08-27 15:00:00	NVDA	Stock	6.9192	6.9312	6.8768	6.8972	65920920.0
2018-08-27 16:00:00	NVDA	Stock	6.8975	6.9025	6.8938	6.9	16955760.0
2018-08-27 17:00:00	NVDA	Stock	6.8925	6.8998	6.8925	6.8953	226440.0
2018-08-27 18:00:00	NVDA	Stock	6.8975	6.8975	6.895	6.895	663600.0
2018-08-27 19:00:00	NVDA	Stock	6.8975	6.905	6.8975	6.8998	664560.0
2018-08-27 04:00:00	AMZN	Stock	95.7	95.875	95.7	95.875	12560.0
2018-08-27 05:00:00	AMZN	Stock	96.089	96.089	95.977	95.98	10480.0
2018-08-27 06:00:00	AMZN	Stock	95.9	95.9395	95.9	95.9395	13680.0

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

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