PREVIEW / stock_1hour / 2016-02-04

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-02-04.parquet
  size:    1.0 MB
  rows:    48,257
  symbols: 3,360

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
2016-02-04 04:00:00	AAPL	Stock	24.0025	24.1	23.97	24.0975	11536.0
2016-02-04 05:00:00	AAPL	Stock	24.06	24.06	24.06	24.06	400.0
2016-02-04 06:00:00	AAPL	Stock	24.06	24.06	24.0075	24.01	7600.0
2016-02-04 07:00:00	AAPL	Stock	23.975	24.0	23.91	23.91	23096.0
2016-02-04 08:00:00	AAPL	Stock	23.9575	23.9875	23.7625	23.785	566740.0
2016-02-04 09:00:00	AAPL	Stock	23.8	24.0925	23.7975	23.9725	16545040.0
2016-02-04 10:00:00	AAPL	Stock	23.9675	24.3325	23.8575	24.285	30303792.0
2016-02-04 11:00:00	AAPL	Stock	24.2825	24.2925	23.865	23.91	22351572.0
2016-02-04 12:00:00	AAPL	Stock	23.9078	24.1775	23.8875	24.09	15534700.0
2016-02-04 13:00:00	AAPL	Stock	24.0925	24.1528	23.9675	24.0318	13605880.0
2016-02-04 14:00:00	AAPL	Stock	24.035	24.0975	23.935	24.09	13729164.0
2016-02-04 15:00:00	AAPL	Stock	24.0875	24.175	23.9675	24.15	25997816.0
2016-02-04 16:00:00	AAPL	Stock	24.15	24.17	24.0672	24.125	8278692.0
2016-02-04 17:00:00	AAPL	Stock	24.1125	24.14	24.0875	24.13	74320.0
2016-02-04 18:00:00	AAPL	Stock	24.125	24.125	24.1025	24.1225	42200.0
2016-02-04 19:00:00	AAPL	Stock	24.125	24.1375	24.12	24.125	45076.0
2016-02-04 06:00:00	MSFT	Stock	52.26	52.26	52.26	52.26	500.0
2016-02-04 07:00:00	MSFT	Stock	52.26	52.26	52.04	52.05	1600.0
2016-02-04 08:00:00	MSFT	Stock	52.0	52.0	51.66	51.75	17707.0
2016-02-04 09:00:00	MSFT	Stock	51.88	52.1	51.4	51.63	5174732.0
2016-02-04 10:00:00	MSFT	Stock	51.64	52.81	51.37	52.5	10564694.0
2016-02-04 11:00:00	MSFT	Stock	52.5	52.52	51.48	51.53	4947394.0
2016-02-04 12:00:00	MSFT	Stock	51.535	52.02	51.5	51.805	3517799.0
2016-02-04 13:00:00	MSFT	Stock	51.8	52.055	51.64	51.67	3106982.0
2016-02-04 14:00:00	MSFT	Stock	51.68	51.87	51.41	51.85	5361021.0
2016-02-04 15:00:00	MSFT	Stock	51.859	52.025	51.561	52.0	6514263.0
2016-02-04 16:00:00	MSFT	Stock	52.0	52.0	51.67	51.67	3862518.0
2016-02-04 17:00:00	MSFT	Stock	51.75	51.75	51.63	51.7	2449.0
2016-02-04 18:00:00	MSFT	Stock	51.89	52.0	51.8	51.8	6349.0
2016-02-04 19:00:00	MSFT	Stock	51.83	51.83	51.68	51.68	470.0
2016-02-04 07:00:00	NVDA	Stock	0.7055	0.7055	0.705	0.705	44000.0
2016-02-04 08:00:00	NVDA	Stock	0.7045	0.7045	0.7012	0.7012	111920.0
2016-02-04 09:00:00	NVDA	Stock	0.705	0.7115	0.6982	0.7038	27057680.0
2016-02-04 10:00:00	NVDA	Stock	0.7038	0.7213	0.6995	0.7195	51656760.0
2016-02-04 11:00:00	NVDA	Stock	0.7195	0.7196	0.7055	0.7056	33750320.0
2016-02-04 12:00:00	NVDA	Stock	0.7058	0.7086	0.7038	0.7042	51472720.0
2016-02-04 13:00:00	NVDA	Stock	0.704	0.7075	0.7011	0.7024	27167600.0
2016-02-04 14:00:00	NVDA	Stock	0.7025	0.7045	0.6982	0.7045	40856040.0
2016-02-04 15:00:00	NVDA	Stock	0.7042	0.706	0.7019	0.7052	67430720.0
2016-02-04 16:00:00	NVDA	Stock	0.7052	0.7064	0.703	0.7052	15079000.0
2016-02-04 05:00:00	AMZN	Stock	26.5125	26.5125	26.5125	26.5125	2000.0
2016-02-04 06:00:00	AMZN	Stock	26.658	26.658	26.563	26.563	6340.0
2016-02-04 07:00:00	AMZN	Stock	26.6	26.6055	26.5055	26.5055	212280.0
2016-02-04 08:00:00	AMZN	Stock	26.6	26.632	26.16	26.24	371400.0
2016-02-04 09:00:00	AMZN	Stock	26.225	26.4725	26.078	26.226	19780360.0
2016-02-04 10:00:00	AMZN	Stock	26.2435	26.787	25.961	26.7795	27232400.0
2016-02-04 11:00:00	AMZN	Stock	26.783	26.81	26.415	26.4855	14835940.0
2016-02-04 12:00:00	AMZN	Stock	26.5075	26.614	26.383	26.465	7337140.0
2016-02-04 13:00:00	AMZN	Stock	26.4705	26.9495	26.4608	26.629	15256780.0
2016-02-04 14:00:00	AMZN	Stock	26.622	26.6295	26.35	26.5258	7070640.0

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

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