PREVIEW / stock_1hour / 2017-04-18

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-04-18.parquet
  size:    1.0 MB
  rows:    48,133
  symbols: 3,050

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-04-18 04:00:00	AAPL	Stock	35.4075	35.42	35.4075	35.4075	2960.0
2017-04-18 05:00:00	AAPL	Stock	35.3925	35.3925	35.35	35.35	12092.0
2017-04-18 06:00:00	AAPL	Stock	35.385	35.3975	35.325	35.35	26564.0
2017-04-18 07:00:00	AAPL	Stock	35.375	35.4	35.36	35.4	65260.0
2017-04-18 08:00:00	AAPL	Stock	35.375	35.4	35.375	35.39	107612.0
2017-04-18 09:00:00	AAPL	Stock	35.3925	35.4925	35.3025	35.485	8970392.0
2017-04-18 10:00:00	AAPL	Stock	35.485	35.51	35.3825	35.4175	8856916.0
2017-04-18 11:00:00	AAPL	Stock	35.42	35.4638	35.3275	35.335	6844416.0
2017-04-18 12:00:00	AAPL	Stock	35.3325	35.365	35.2775	35.3375	5821080.0
2017-04-18 13:00:00	AAPL	Stock	35.34	35.3875	35.3125	35.3462	4020392.0
2017-04-18 14:00:00	AAPL	Stock	35.345	35.3902	35.3125	35.3362	5211260.0
2017-04-18 15:00:00	AAPL	Stock	35.3375	35.3625	35.2812	35.305	8883004.0
2017-04-18 16:00:00	AAPL	Stock	35.295	35.3125	35.2775	35.3075	4783556.0
2017-04-18 17:00:00	AAPL	Stock	35.31	35.3275	35.31	35.325	19900.0
2017-04-18 18:00:00	AAPL	Stock	35.3175	35.3325	35.3175	35.33	12164.0
2017-04-18 19:00:00	AAPL	Stock	35.3125	35.3325	35.3125	35.3325	37808.0
2017-04-18 04:00:00	MSFT	Stock	65.2	65.2	65.2	65.2	100.0
2017-04-18 06:00:00	MSFT	Stock	65.25	65.25	65.25	65.25	100.0
2017-04-18 08:00:00	MSFT	Stock	65.34	65.44	65.3	65.3	5475.0
2017-04-18 09:00:00	MSFT	Stock	65.44	65.66	65.16	65.63	1881533.0
2017-04-18 10:00:00	MSFT	Stock	65.625	65.71	65.38	65.465	2381265.0
2017-04-18 11:00:00	MSFT	Stock	65.461	65.545	65.25	65.285	2450515.0
2017-04-18 12:00:00	MSFT	Stock	65.28	65.4	65.24	65.33	1757810.0
2017-04-18 13:00:00	MSFT	Stock	65.33	65.46	65.28	65.4	1060181.0
2017-04-18 14:00:00	MSFT	Stock	65.399	65.43	65.28	65.377	1196868.0
2017-04-18 15:00:00	MSFT	Stock	65.38	65.49	65.33	65.39	2179093.0
2017-04-18 16:00:00	MSFT	Stock	65.38	65.39	65.26	65.26	1099679.0
2017-04-18 19:00:00	MSFT	Stock	65.31	65.31	65.31	65.31	1213.0
2017-04-18 04:00:00	NVDA	Stock	2.475	2.475	2.47	2.47	44400.0
2017-04-18 05:00:00	NVDA	Stock	2.47	2.47	2.4683	2.4683	60920.0
2017-04-18 06:00:00	NVDA	Stock	2.4683	2.4683	2.461	2.461	33800.0
2017-04-18 07:00:00	NVDA	Stock	2.4608	2.47	2.4608	2.4688	71160.0
2017-04-18 08:00:00	NVDA	Stock	2.4688	2.47	2.4633	2.4683	384760.0
2017-04-18 09:00:00	NVDA	Stock	2.4683	2.474	2.4478	2.4625	76614600.0
2017-04-18 10:00:00	NVDA	Stock	2.4638	2.468	2.44	2.466	78590120.0
2017-04-18 11:00:00	NVDA	Stock	2.466	2.476	2.462	2.4654	42155040.0
2017-04-18 12:00:00	NVDA	Stock	2.4654	2.4728	2.4608	2.4665	23283400.0
2017-04-18 13:00:00	NVDA	Stock	2.4665	2.4718	2.4612	2.4688	19603480.0
2017-04-18 14:00:00	NVDA	Stock	2.4688	2.483	2.468	2.4823	32281760.0
2017-04-18 15:00:00	NVDA	Stock	2.4823	2.4885	2.4791	2.482	56286840.0
2017-04-18 16:00:00	NVDA	Stock	2.4823	2.4825	2.476	2.4765	7052640.0
2017-04-18 17:00:00	NVDA	Stock	2.4765	2.4795	2.4753	2.4795	186280.0
2017-04-18 18:00:00	NVDA	Stock	2.4763	2.4805	2.4763	2.4805	92800.0
2017-04-18 19:00:00	NVDA	Stock	2.4763	2.4788	2.4763	2.4763	50000.0
2017-04-18 05:00:00	AMZN	Stock	45.0655	45.0655	45.0655	45.0655	2680.0
2017-04-18 06:00:00	AMZN	Stock	44.95	44.95	44.95	44.95	2000.0
2017-04-18 07:00:00	AMZN	Stock	44.95	44.9945	44.95	44.9945	18600.0
2017-04-18 08:00:00	AMZN	Stock	44.9875	45.025	44.95	45.02	234760.0
2017-04-18 09:00:00	AMZN	Stock	45.0025	45.4805	44.963	45.4215	15768440.0
2017-04-18 10:00:00	AMZN	Stock	45.4122	45.4335	45.0755	45.2185	7884540.0

> showing 50 of 48,133 rows — these rows as CSV

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