PREVIEW / stock_1hour / 2018-02-02

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-02-02.parquet
  size:    1.1 MB
  rows:    50,614
  symbols: 2,902

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-02-02 04:00:00	AAPL	Stock	42.8875	43.0825	42.875	42.8925	183840.0
2018-02-02 05:00:00	AAPL	Stock	42.9	42.9475	42.0625	42.25	802240.0
2018-02-02 06:00:00	AAPL	Stock	42.2425	42.35	41.825	42.185	1260824.0
2018-02-02 07:00:00	AAPL	Stock	42.1825	42.3625	42.005	42.255	2727572.0
2018-02-02 08:00:00	AAPL	Stock	42.2125	42.345	41.375	41.4375	6831736.0
2018-02-02 09:00:00	AAPL	Stock	41.445	41.7	40.8	40.905	66077668.0
2018-02-02 10:00:00	AAPL	Stock	40.9042	41.05	40.715	40.9125	45347904.0
2018-02-02 11:00:00	AAPL	Stock	40.91	40.965	40.6825	40.7362	32273156.0
2018-02-02 12:00:00	AAPL	Stock	40.735	40.7875	40.605	40.6775	26946220.0
2018-02-02 13:00:00	AAPL	Stock	40.6725	40.6775	40.22	40.5925	30451468.0
2018-02-02 14:00:00	AAPL	Stock	40.595	40.605	40.25	40.4125	27653004.0
2018-02-02 15:00:00	AAPL	Stock	40.4125	40.4675	40.025	40.1025	47841016.0
2018-02-02 16:00:00	AAPL	Stock	40.0375	40.5535	40.0375	40.17	20828540.0
2018-02-02 17:00:00	AAPL	Stock	40.165	40.2125	40.15	40.1825	244380.0
2018-02-02 18:00:00	AAPL	Stock	40.175	40.175	40.0	40.0675	327188.0
2018-02-02 19:00:00	AAPL	Stock	40.07	40.125	40.0	40.005	265748.0
2018-02-02 04:00:00	MSFT	Stock	94.64	94.64	93.18	93.32	16670.0
2018-02-02 05:00:00	MSFT	Stock	93.12	93.4	93.11	93.4	2327.0
2018-02-02 06:00:00	MSFT	Stock	93.31	93.41	93.31	93.4	3563.0
2018-02-02 07:00:00	MSFT	Stock	93.53	93.64	93.33	93.6	32984.0
2018-02-02 08:00:00	MSFT	Stock	93.45	94.45	93.35	93.96	102271.0
2018-02-02 09:00:00	MSFT	Stock	93.99	94.15	92.88	93.174	5698662.0
2018-02-02 10:00:00	MSFT	Stock	93.18	93.27	91.645	93.04	7339004.0
2018-02-02 11:00:00	MSFT	Stock	93.03	93.11	92.03	92.08	3889989.0
2018-02-02 12:00:00	MSFT	Stock	92.072	92.4	91.75	92.115	4789741.0
2018-02-02 13:00:00	MSFT	Stock	92.11	92.4	91.82	92.35	3367345.0
2018-02-02 14:00:00	MSFT	Stock	92.35	92.61	92.11	92.26	4540583.0
2018-02-02 15:00:00	MSFT	Stock	92.25	92.61	91.76	91.76	7025644.0
2018-02-02 16:00:00	MSFT	Stock	91.5	92.397	91.5	91.98	6726515.0
2018-02-02 17:00:00	MSFT	Stock	91.8	91.92	91.63	91.63	5895.0
2018-02-02 18:00:00	MSFT	Stock	91.65	91.8	91.5	91.55	9286.0
2018-02-02 19:00:00	MSFT	Stock	91.5	91.6	91.5	91.59	2972.0
2018-02-02 04:00:00	NVDA	Stock	6.04	6.04	5.9873	5.9873	168000.0
2018-02-02 06:00:00	NVDA	Stock	5.9625	5.9625	5.9312	5.9375	135880.0
2018-02-02 07:00:00	NVDA	Stock	5.9265	5.9473	5.8813	5.9175	3885960.0
2018-02-02 08:00:00	NVDA	Stock	5.925	6.05	5.8625	5.8978	5565000.0
2018-02-02 09:00:00	NVDA	Stock	5.8975	5.9362	5.808	5.8428	133936640.0
2018-02-02 10:00:00	NVDA	Stock	5.8438	5.9492	5.7792	5.9208	132281760.0
2018-02-02 11:00:00	NVDA	Stock	5.9239	5.928	5.8452	5.8485	54598760.0
2018-02-02 12:00:00	NVDA	Stock	5.8505	5.9333	5.8418	5.8998	43890160.0
2018-02-02 13:00:00	NVDA	Stock	5.9	5.9062	5.8688	5.8948	29167360.0
2018-02-02 14:00:00	NVDA	Stock	5.895	5.9018	5.85	5.8656	58567320.0
2018-02-02 15:00:00	NVDA	Stock	5.866	5.8953	5.8333	5.8378	93784280.0
2018-02-02 16:00:00	NVDA	Stock	5.8375	5.8485	5.8175	5.8198	23182240.0
2018-02-02 17:00:00	NVDA	Stock	5.8175	5.8225	5.8075	5.8115	540920.0
2018-02-02 18:00:00	NVDA	Stock	5.817	5.817	5.795	5.795	646400.0
2018-02-02 19:00:00	NVDA	Stock	5.7963	5.8125	5.795	5.8062	603360.0
2018-02-02 04:00:00	AMZN	Stock	73.5865	73.699	73.3885	73.45	79460.0
2018-02-02 05:00:00	AMZN	Stock	73.353	73.353	73.284	73.284	35520.0
2018-02-02 06:00:00	AMZN	Stock	73.2055	73.5	72.8395	73.051	262060.0

> showing 50 of 50,614 rows — these rows as CSV

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