PREVIEW / stock_1hour / 2018-01-02

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-01-02.parquet
  size:    1.1 MB
  rows:    51,025
  symbols: 2,929

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-01-02 04:00:00	AAPL	Stock	42.275	42.3	42.275	42.295	32440.0
2018-01-02 05:00:00	AAPL	Stock	42.3125	42.3375	42.25	42.3375	19508.0
2018-01-02 06:00:00	AAPL	Stock	42.335	42.4175	42.335	42.4175	45560.0
2018-01-02 07:00:00	AAPL	Stock	42.38	42.55	42.3775	42.5125	135632.0
2018-01-02 08:00:00	AAPL	Stock	42.5025	42.5475	42.3825	42.53	427428.0
2018-01-02 09:00:00	AAPL	Stock	42.5375	42.7675	42.315	42.745	20716672.0
2018-01-02 10:00:00	AAPL	Stock	42.7425	42.9	42.715	42.8762	16017772.0
2018-01-02 11:00:00	AAPL	Stock	42.875	42.8825	42.775	42.8025	9649104.0
2018-01-02 12:00:00	AAPL	Stock	42.8013	42.875	42.7975	42.82	6175516.0
2018-01-02 13:00:00	AAPL	Stock	42.8225	42.925	42.821	42.9222	6815352.0
2018-01-02 14:00:00	AAPL	Stock	42.92	43.0275	42.915	42.995	9803708.0
2018-01-02 15:00:00	AAPL	Stock	42.995	43.075	42.925	43.065	13210508.0
2018-01-02 16:00:00	AAPL	Stock	43.065	43.065	43.005	43.05	8081960.0
2018-01-02 17:00:00	AAPL	Stock	43.035	43.065	43.01	43.0275	944284.0
2018-01-02 18:00:00	AAPL	Stock	43.03	43.0575	43.0075	43.0375	48004.0
2018-01-02 19:00:00	AAPL	Stock	43.0125	43.075	43.0125	43.075	39288.0
2018-01-02 04:00:00	MSFT	Stock	85.55	85.55	85.55	85.55	100.0
2018-01-02 07:00:00	MSFT	Stock	85.6	85.9	85.6	85.88	2470.0
2018-01-02 08:00:00	MSFT	Stock	85.6	86.0	85.54	85.94	25290.0
2018-01-02 09:00:00	MSFT	Stock	85.9	86.31	85.59	86.17	2650986.0
2018-01-02 10:00:00	MSFT	Stock	86.155	86.23	85.92	86.0	3220050.0
2018-01-02 11:00:00	MSFT	Stock	86.0	86.025	85.7	85.706	2149117.0
2018-01-02 12:00:00	MSFT	Stock	85.71	85.75	85.5	85.574	1561440.0
2018-01-02 13:00:00	MSFT	Stock	85.58	85.8	85.555	85.745	1699058.0
2018-01-02 14:00:00	MSFT	Stock	85.74	85.89	85.67	85.72	1673761.0
2018-01-02 15:00:00	MSFT	Stock	85.725	86.04	85.71	85.91	3035370.0
2018-01-02 16:00:00	MSFT	Stock	85.95	85.95	85.73	85.94	4145762.0
2018-01-02 17:00:00	MSFT	Stock	85.94	85.95	85.85	85.85	1916.0
2018-01-02 18:00:00	MSFT	Stock	85.93	85.95	85.93	85.95	580.0
2018-01-02 19:00:00	MSFT	Stock	85.9	86.0	85.9	86.0	6234.0
2018-01-02 04:00:00	NVDA	Stock	4.8418	4.8418	4.8375	4.8375	48160.0
2018-01-02 07:00:00	NVDA	Stock	4.846	4.88	4.8452	4.8775	285480.0
2018-01-02 08:00:00	NVDA	Stock	4.8452	4.8878	4.8452	4.8858	1339600.0
2018-01-02 09:00:00	NVDA	Stock	4.8835	4.9172	4.8625	4.9025	63990080.0
2018-01-02 10:00:00	NVDA	Stock	4.9042	4.9473	4.903	4.9456	58480600.0
2018-01-02 11:00:00	NVDA	Stock	4.9458	4.9544	4.9335	4.9438	36759680.0
2018-01-02 12:00:00	NVDA	Stock	4.9435	4.9585	4.9375	4.947	24297040.0
2018-01-02 13:00:00	NVDA	Stock	4.9465	4.9483	4.9355	4.9423	14453040.0
2018-01-02 14:00:00	NVDA	Stock	4.943	4.959	4.9415	4.9496	25401440.0
2018-01-02 15:00:00	NVDA	Stock	4.9498	4.9875	4.948	4.9825	54379800.0
2018-01-02 16:00:00	NVDA	Stock	4.9838	5.059	4.9329	5.0422	42940080.0
2018-01-02 17:00:00	NVDA	Stock	5.0388	5.065	5.0362	5.06	5695800.0
2018-01-02 18:00:00	NVDA	Stock	5.0612	5.0612	5.06	5.0612	1179560.0
2018-01-02 19:00:00	NVDA	Stock	5.06	5.1	5.0598	5.085	1020920.0
2018-01-02 04:00:00	AMZN	Stock	58.39	58.5	58.39	58.5	6000.0
2018-01-02 05:00:00	AMZN	Stock	58.485	58.485	58.485	58.485	2000.0
2018-01-02 07:00:00	AMZN	Stock	58.6005	58.7105	58.6	58.6945	36740.0
2018-01-02 08:00:00	AMZN	Stock	58.6945	58.75	58.4735	58.725	163220.0
2018-01-02 09:00:00	AMZN	Stock	58.7125	59.0875	58.5255	59.0715	8154760.0
2018-01-02 10:00:00	AMZN	Stock	59.06	59.2625	59.045	59.141	5643860.0

> showing 50 of 51,025 rows — these rows as CSV

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