PREVIEW / stock_1hour / 2018-03-07

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-03-07.parquet
  size:    1.1 MB
  rows:    49,729
  symbols: 2,860

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-03-07 04:00:00	AAPL	Stock	43.75	43.75	43.65	43.75	53960.0
2018-03-07 05:00:00	AAPL	Stock	43.7475	43.815	43.7475	43.75	26192.0
2018-03-07 06:00:00	AAPL	Stock	43.75	43.75	43.6525	43.7025	50800.0
2018-03-07 07:00:00	AAPL	Stock	43.7225	43.8625	43.7125	43.8	418624.0
2018-03-07 08:00:00	AAPL	Stock	43.7925	43.87	43.7125	43.815	459392.0
2018-03-07 09:00:00	AAPL	Stock	43.825	43.9625	43.6925	43.715	17381740.0
2018-03-07 10:00:00	AAPL	Stock	43.715	43.8675	43.6638	43.832	15960708.0
2018-03-07 11:00:00	AAPL	Stock	43.83	43.8375	43.6725	43.6775	11125180.0
2018-03-07 12:00:00	AAPL	Stock	43.6775	43.8375	43.5675	43.805	12191628.0
2018-03-07 13:00:00	AAPL	Stock	43.8025	43.93	43.61	43.8125	11008276.0
2018-03-07 14:00:00	AAPL	Stock	43.8125	43.9025	43.73	43.765	9272316.0
2018-03-07 15:00:00	AAPL	Stock	43.7625	43.9	43.6825	43.755	23685908.0
2018-03-07 16:00:00	AAPL	Stock	43.765	43.765	43.705	43.715	11524176.0
2018-03-07 17:00:00	AAPL	Stock	43.715	43.735	43.7125	43.73	34664.0
2018-03-07 18:00:00	AAPL	Stock	43.7325	43.735	43.7075	43.7175	12788.0
2018-03-07 19:00:00	AAPL	Stock	43.7325	43.735	43.7125	43.725	20292.0
2018-03-07 04:00:00	MSFT	Stock	92.44	92.44	92.3	92.3	4871.0
2018-03-07 05:00:00	MSFT	Stock	92.45	92.48	92.45	92.48	1600.0
2018-03-07 06:00:00	MSFT	Stock	92.4	92.45	92.4	92.45	1806.0
2018-03-07 07:00:00	MSFT	Stock	92.41	92.82	92.41	92.6	20479.0
2018-03-07 08:00:00	MSFT	Stock	92.7	92.8	92.365	92.6	58871.0
2018-03-07 09:00:00	MSFT	Stock	92.61	93.54	92.44	93.085	3030828.0
2018-03-07 10:00:00	MSFT	Stock	93.09	93.476	92.94	93.25	3169866.0
2018-03-07 11:00:00	MSFT	Stock	93.24	93.265	92.66	92.67	2323689.0
2018-03-07 12:00:00	MSFT	Stock	92.67	93.15	92.43	93.11	2417892.0
2018-03-07 13:00:00	MSFT	Stock	93.1	93.54	92.83	93.48	2331730.0
2018-03-07 14:00:00	MSFT	Stock	93.485	93.74	93.36	93.455	2647002.0
2018-03-07 15:00:00	MSFT	Stock	93.46	93.941	93.405	93.86	4743255.0
2018-03-07 16:00:00	MSFT	Stock	93.86	93.86	93.49	93.49	3650529.0
2018-03-07 17:00:00	MSFT	Stock	93.77	93.78	93.77	93.78	1296.0
2018-03-07 18:00:00	MSFT	Stock	93.86	93.86	93.76	93.76	251123.0
2018-03-07 19:00:00	MSFT	Stock	93.75	93.78	93.66	93.78	2735.0
2018-03-07 04:00:00	NVDA	Stock	5.9508	5.9625	5.9312	5.9535	188280.0
2018-03-07 05:00:00	NVDA	Stock	5.9535	5.9682	5.95	5.95	287160.0
2018-03-07 06:00:00	NVDA	Stock	5.9528	5.9533	5.9458	5.9458	42320.0
2018-03-07 07:00:00	NVDA	Stock	5.9492	5.99	5.92	5.975	1952240.0
2018-03-07 08:00:00	NVDA	Stock	5.95	6.0675	5.9378	5.9625	4269000.0
2018-03-07 09:00:00	NVDA	Stock	5.965	6.0548	5.9303	5.9983	107273040.0
2018-03-07 10:00:00	NVDA	Stock	5.9968	6.0988	5.989	6.0813	128679880.0
2018-03-07 11:00:00	NVDA	Stock	6.082	6.0834	6.0075	6.008	61049560.0
2018-03-07 12:00:00	NVDA	Stock	6.0093	6.0285	5.989	6.019	71778920.0
2018-03-07 13:00:00	NVDA	Stock	6.019	6.0212	5.9728	6.0121	54159120.0
2018-03-07 14:00:00	NVDA	Stock	6.0132	6.0355	6.0058	6.0138	50015440.0
2018-03-07 15:00:00	NVDA	Stock	6.0149	6.055	6.0097	6.046	79304320.0
2018-03-07 16:00:00	NVDA	Stock	6.046	6.0463	6.0325	6.0338	5639880.0
2018-03-07 17:00:00	NVDA	Stock	6.029	6.0375	6.029	6.0375	159120.0
2018-03-07 18:00:00	NVDA	Stock	6.0375	6.0375	6.027	6.0325	190760.0
2018-03-07 19:00:00	NVDA	Stock	6.0325	6.0348	6.0288	6.0312	101240.0
2018-03-07 04:00:00	AMZN	Stock	75.9855	76.0	75.9	76.0	14620.0
2018-03-07 05:00:00	AMZN	Stock	76.1	76.1735	76.1	76.101	25560.0

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

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