PREVIEW / stock_1hour / 2017-12-20

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-12-20.parquet
  size:    1.1 MB
  rows:    49,663
  symbols: 2,930

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
2017-12-20 04:00:00	AAPL	Stock	43.775	43.775	43.775	43.775	1200.0
2017-12-20 05:00:00	AAPL	Stock	43.8	43.8125	43.8	43.8075	13624.0
2017-12-20 06:00:00	AAPL	Stock	43.8	43.8	43.75	43.7675	14388.0
2017-12-20 07:00:00	AAPL	Stock	43.7625	43.795	43.75	43.755	162864.0
2017-12-20 08:00:00	AAPL	Stock	43.8	43.8	43.7225	43.75	359004.0
2017-12-20 09:00:00	AAPL	Stock	43.7425	43.855	43.355	43.5075	18962204.0
2017-12-20 10:00:00	AAPL	Stock	43.51	43.5725	43.3125	43.3875	13991352.0
2017-12-20 11:00:00	AAPL	Stock	43.385	43.61	43.375	43.5775	9612272.0
2017-12-20 12:00:00	AAPL	Stock	43.575	43.675	43.525	43.635	7224340.0
2017-12-20 13:00:00	AAPL	Stock	43.635	43.705	43.605	43.685	5552576.0
2017-12-20 14:00:00	AAPL	Stock	43.685	43.6925	43.49	43.5475	6945052.0
2017-12-20 15:00:00	AAPL	Stock	43.5475	43.66	43.5325	43.59	9310456.0
2017-12-20 16:00:00	AAPL	Stock	43.5875	43.6025	43.57	43.5875	11192564.0
2017-12-20 17:00:00	AAPL	Stock	43.575	43.5825	43.5625	43.5825	24332.0
2017-12-20 18:00:00	AAPL	Stock	43.5825	43.5875	43.5675	43.5675	32780.0
2017-12-20 19:00:00	AAPL	Stock	43.59	43.59	43.56	43.56	22652.0
2017-12-20 07:00:00	MSFT	Stock	86.15	86.35	86.15	86.3	2626.0
2017-12-20 08:00:00	MSFT	Stock	86.34	86.47	86.31	86.4	14599.0
2017-12-20 09:00:00	MSFT	Stock	86.39	86.47	85.08	85.25	2605664.0
2017-12-20 10:00:00	MSFT	Stock	85.25	85.28	84.81	84.91	2278122.0
2017-12-20 11:00:00	MSFT	Stock	84.91	85.11	84.71	85.08	2401298.0
2017-12-20 12:00:00	MSFT	Stock	85.075	85.3	85.02	85.1	1714370.0
2017-12-20 13:00:00	MSFT	Stock	85.11	85.56	85.09	85.44	1571862.0
2017-12-20 14:00:00	MSFT	Stock	85.45	85.52	85.26	85.52	1349416.0
2017-12-20 15:00:00	MSFT	Stock	85.52	85.7	85.47	85.59	3208658.0
2017-12-20 16:00:00	MSFT	Stock	85.52	85.57	85.47	85.57	3797225.0
2017-12-20 17:00:00	MSFT	Stock	85.57	86.0	85.52	85.52	106104.0
2017-12-20 18:00:00	MSFT	Stock	85.88	85.91	85.81	85.83	7348.0
2017-12-20 19:00:00	MSFT	Stock	85.9	85.92	85.84	85.92	3725.0
2017-12-20 05:00:00	NVDA	Stock	4.9312	4.95	4.931	4.95	78400.0
2017-12-20 06:00:00	NVDA	Stock	4.9432	4.9445	4.9375	4.9425	93320.0
2017-12-20 07:00:00	NVDA	Stock	4.9375	4.955	4.9298	4.955	728960.0
2017-12-20 08:00:00	NVDA	Stock	4.955	4.9615	4.9362	4.9522	1674120.0
2017-12-20 09:00:00	NVDA	Stock	4.95	4.9522	4.8638	4.9005	64459440.0
2017-12-20 10:00:00	NVDA	Stock	4.9008	4.9108	4.8712	4.8829	41445680.0
2017-12-20 11:00:00	NVDA	Stock	4.8835	4.9207	4.8768	4.9188	31303320.0
2017-12-20 12:00:00	NVDA	Stock	4.9185	4.9333	4.918	4.9208	27532680.0
2017-12-20 13:00:00	NVDA	Stock	4.9218	4.9318	4.9138	4.9178	17473960.0
2017-12-20 14:00:00	NVDA	Stock	4.9185	4.921	4.9041	4.9075	15038800.0
2017-12-20 15:00:00	NVDA	Stock	4.9074	4.924	4.8948	4.9188	35674000.0
2017-12-20 16:00:00	NVDA	Stock	4.92	4.9245	4.9075	4.92	17483720.0
2017-12-20 17:00:00	NVDA	Stock	4.9088	4.9128	4.9083	4.91	46520.0
2017-12-20 18:00:00	NVDA	Stock	4.9128	4.9128	4.906	4.9112	81280.0
2017-12-20 19:00:00	NVDA	Stock	4.906	4.915	4.906	4.9062	139840.0
2017-12-20 07:00:00	AMZN	Stock	59.54	59.599	59.54	59.574	47860.0
2017-12-20 08:00:00	AMZN	Stock	59.5875	59.599	59.55	59.56	190980.0
2017-12-20 09:00:00	AMZN	Stock	59.561	59.587	58.8	58.979	8883580.0
2017-12-20 10:00:00	AMZN	Stock	58.982	59.1779	58.9045	58.979	6904400.0
2017-12-20 11:00:00	AMZN	Stock	58.998	59.085	58.872	59.015	6213620.0
2017-12-20 12:00:00	AMZN	Stock	59.023	59.1255	58.981	59.0	2712540.0

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

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