PREVIEW / stock_1hour / 2018-08-28

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-28.parquet
  size:    1.1 MB
  rows:    49,129
  symbols: 2,802

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-28 04:00:00	AAPL	Stock	54.575	54.6625	54.575	54.6625	27752.0
2018-08-28 05:00:00	AAPL	Stock	54.675	54.675	54.625	54.625	7016.0
2018-08-28 06:00:00	AAPL	Stock	54.6625	54.6625	54.6125	54.625	6400.0
2018-08-28 07:00:00	AAPL	Stock	54.62	54.71	54.615	54.71	130368.0
2018-08-28 08:00:00	AAPL	Stock	54.6375	54.8175	54.6125	54.72	554432.0
2018-08-28 09:00:00	AAPL	Stock	54.7375	54.9725	54.7175	54.868	15348128.0
2018-08-28 10:00:00	AAPL	Stock	54.87	54.96	54.8325	54.935	12085384.0
2018-08-28 11:00:00	AAPL	Stock	54.935	54.9375	54.77	54.805	8768700.0
2018-08-28 12:00:00	AAPL	Stock	54.8075	54.955	54.7725	54.945	5937456.0
2018-08-28 13:00:00	AAPL	Stock	54.9475	55.135	54.8825	55.0675	12367676.0
2018-08-28 14:00:00	AAPL	Stock	55.0695	55.105	55.0065	55.0425	5694488.0
2018-08-28 15:00:00	AAPL	Stock	55.0425	55.0598	54.795	54.9275	13688572.0
2018-08-28 16:00:00	AAPL	Stock	54.925	54.975	54.925	54.9625	4901480.0
2018-08-28 17:00:00	AAPL	Stock	54.9675	54.975	54.485	54.95	18248.0
2018-08-28 18:00:00	AAPL	Stock	54.9525	54.975	54.94	54.9575	16772.0
2018-08-28 19:00:00	AAPL	Stock	54.97	54.9875	54.9575	54.97	69300.0
2018-08-28 04:00:00	MSFT	Stock	109.65	109.65	109.65	109.65	4678.0
2018-08-28 05:00:00	MSFT	Stock	109.65	109.84	109.65	109.84	8636.0
2018-08-28 06:00:00	MSFT	Stock	109.83	110.0	109.83	109.9	14567.0
2018-08-28 07:00:00	MSFT	Stock	109.85	109.9	109.66	109.88	8199.0
2018-08-28 08:00:00	MSFT	Stock	109.8	110.13	109.75	109.92	48198.0
2018-08-28 09:00:00	MSFT	Stock	109.85	110.45	109.6	110.392	3016209.0
2018-08-28 10:00:00	MSFT	Stock	110.4	110.5	109.8	110.066	2756010.0
2018-08-28 11:00:00	MSFT	Stock	110.07	110.22	109.79	109.976	1709509.0
2018-08-28 12:00:00	MSFT	Stock	109.975	110.23	109.89	110.18	1069224.0
2018-08-28 13:00:00	MSFT	Stock	110.18	110.23	110.06	110.155	885159.0
2018-08-28 14:00:00	MSFT	Stock	110.15	110.26	109.99	110.175	1369946.0
2018-08-28 15:00:00	MSFT	Stock	110.175	110.34	109.99	110.32	3762807.0
2018-08-28 16:00:00	MSFT	Stock	110.26	110.35	110.135	110.26	2429637.0
2018-08-28 17:00:00	MSFT	Stock	110.26	110.26	110.2	110.2	1767.0
2018-08-28 18:00:00	MSFT	Stock	110.25	110.3	110.25	110.3	1783.0
2018-08-28 19:00:00	MSFT	Stock	110.3	110.3	110.27	110.27	1782.0
2018-08-28 04:00:00	NVDA	Stock	6.9	6.9	6.9	6.9	5400.0
2018-08-28 05:00:00	NVDA	Stock	6.9	6.9142	6.9	6.9142	8000.0
2018-08-28 07:00:00	NVDA	Stock	6.915	6.9265	6.9078	6.915	189600.0
2018-08-28 08:00:00	NVDA	Stock	6.9218	6.925	6.905	6.9073	2086520.0
2018-08-28 09:00:00	NVDA	Stock	6.9118	6.92	6.783	6.8411	83602640.0
2018-08-28 10:00:00	NVDA	Stock	6.8424	6.8528	6.7855	6.7985	85146520.0
2018-08-28 11:00:00	NVDA	Stock	6.7978	6.8	6.7382	6.7595	68620560.0
2018-08-28 12:00:00	NVDA	Stock	6.759	6.8198	6.7463	6.8148	34913960.0
2018-08-28 13:00:00	NVDA	Stock	6.815	6.8226	6.7922	6.8146	23772560.0
2018-08-28 14:00:00	NVDA	Stock	6.815	6.875	6.814	6.8729	42654720.0
2018-08-28 15:00:00	NVDA	Stock	6.8729	6.887	6.8405	6.86	62544400.0
2018-08-28 16:00:00	NVDA	Stock	6.8595	6.861	6.85	6.8588	7058160.0
2018-08-28 17:00:00	NVDA	Stock	6.8562	6.8562	6.85	6.85	17480.0
2018-08-28 18:00:00	NVDA	Stock	6.8562	6.8595	6.8505	6.8588	121400.0
2018-08-28 19:00:00	NVDA	Stock	6.8595	6.8595	6.8502	6.8595	575400.0
2018-08-28 04:00:00	AMZN	Stock	96.65	96.65	96.65	96.65	5960.0
2018-08-28 05:00:00	AMZN	Stock	96.6895	96.725	96.6895	96.725	14020.0
2018-08-28 06:00:00	AMZN	Stock	96.729	96.729	96.729	96.729	8720.0

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

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