PREVIEW / stock_1hour / 2018-04-05

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-04-05.parquet
  size:    1.1 MB
  rows:    49,367
  symbols: 2,845

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-05 04:00:00	AAPL	Stock	43.2525	43.2525	43.13	43.13	24136.0
2018-04-05 05:00:00	AAPL	Stock	43.145	43.15	43.11	43.15	28424.0
2018-04-05 06:00:00	AAPL	Stock	43.1475	43.15	43.1	43.15	23152.0
2018-04-05 07:00:00	AAPL	Stock	43.1225	43.3	43.1225	43.21	229892.0
2018-04-05 08:00:00	AAPL	Stock	43.12	43.28	43.12	43.245	412648.0
2018-04-05 09:00:00	AAPL	Stock	43.2375	43.39	43.02	43.2475	16319924.0
2018-04-05 10:00:00	AAPL	Stock	43.245	43.2725	43.085	43.2275	12953132.0
2018-04-05 11:00:00	AAPL	Stock	43.2325	43.5475	43.2175	43.539	13405880.0
2018-04-05 12:00:00	AAPL	Stock	43.5405	43.5575	43.2625	43.4525	9132192.0
2018-04-05 13:00:00	AAPL	Stock	43.4525	43.515	43.115	43.295	9502532.0
2018-04-05 14:00:00	AAPL	Stock	43.2975	43.5075	43.2625	43.5025	8148104.0
2018-04-05 15:00:00	AAPL	Stock	43.505	43.55	43.1675	43.195	15939136.0
2018-04-05 16:00:00	AAPL	Stock	43.2	43.2425	43.1875	43.1875	9773812.0
2018-04-05 17:00:00	AAPL	Stock	43.1875	43.205	43.1875	43.2	23064.0
2018-04-05 18:00:00	AAPL	Stock	43.1875	43.2	42.85	42.85	91500.0
2018-04-05 19:00:00	AAPL	Stock	42.8375	42.8375	42.2975	42.3975	398216.0
2018-04-05 04:00:00	MSFT	Stock	93.0	93.0	92.52	92.7	4789.0
2018-04-05 05:00:00	MSFT	Stock	92.7	92.74	92.7	92.74	2036.0
2018-04-05 06:00:00	MSFT	Stock	92.56	92.74	92.5	92.74	2275.0
2018-04-05 07:00:00	MSFT	Stock	92.74	93.0	92.67	92.83	26834.0
2018-04-05 08:00:00	MSFT	Stock	92.85	93.0	92.55	92.93	43737.0
2018-04-05 09:00:00	MSFT	Stock	92.9	92.9	92.02	92.4	3390019.0
2018-04-05 10:00:00	MSFT	Stock	92.4	92.58	92.05	92.335	3126090.0
2018-04-05 11:00:00	MSFT	Stock	92.35	93.065	92.34	92.79	2844314.0
2018-04-05 12:00:00	MSFT	Stock	92.79	92.845	92.18	92.47	2482271.0
2018-04-05 13:00:00	MSFT	Stock	92.48	92.6	91.4	91.85	3476073.0
2018-04-05 14:00:00	MSFT	Stock	91.85	92.49	91.69	92.405	3025478.0
2018-04-05 15:00:00	MSFT	Stock	92.41	92.8	92.06	92.38	4292188.0
2018-04-05 16:00:00	MSFT	Stock	92.38	92.4	92.3	92.38	4733650.0
2018-04-05 17:00:00	MSFT	Stock	92.38	92.38	92.27	92.37	21644.0
2018-04-05 18:00:00	MSFT	Stock	92.3	92.3	91.56	91.56	7875.0
2018-04-05 19:00:00	MSFT	Stock	91.56	91.56	90.63	90.8	35923.0
2018-04-05 05:00:00	NVDA	Stock	5.7222	5.7225	5.72	5.7225	61880.0
2018-04-05 06:00:00	NVDA	Stock	5.7163	5.7163	5.7163	5.7163	12000.0
2018-04-05 07:00:00	NVDA	Stock	5.7188	5.7428	5.7	5.7128	966960.0
2018-04-05 08:00:00	NVDA	Stock	5.7163	5.743	5.7	5.737	2003280.0
2018-04-05 09:00:00	NVDA	Stock	5.734	5.74	5.6	5.6575	98838880.0
2018-04-05 10:00:00	NVDA	Stock	5.6565	5.6775	5.5855	5.6203	100304880.0
2018-04-05 11:00:00	NVDA	Stock	5.6218	5.6498	5.6092	5.6265	70194600.0
2018-04-05 12:00:00	NVDA	Stock	5.6245	5.6425	5.5728	5.5965	64510920.0
2018-04-05 13:00:00	NVDA	Stock	5.5993	5.6165	5.4623	5.4965	168507200.0
2018-04-05 14:00:00	NVDA	Stock	5.4978	5.5625	5.476	5.5438	80552200.0
2018-04-05 15:00:00	NVDA	Stock	5.5448	5.5718	5.519	5.534	92042000.0
2018-04-05 16:00:00	NVDA	Stock	5.536	5.5845	5.5125	5.5312	4444000.0
2018-04-05 17:00:00	NVDA	Stock	5.5308	5.5338	5.5225	5.525	318240.0
2018-04-05 18:00:00	NVDA	Stock	5.525	5.5298	5.4775	5.4775	939880.0
2018-04-05 19:00:00	NVDA	Stock	5.4808	5.4808	5.4	5.4075	2773600.0
2018-04-05 04:00:00	AMZN	Stock	71.55	71.55	71.4	71.4	22380.0
2018-04-05 05:00:00	AMZN	Stock	71.3685	71.45	71.263	71.263	61620.0
2018-04-05 06:00:00	AMZN	Stock	71.3505	71.3845	71.2495	71.341	100760.0

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

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