PREVIEW / stock_1hour / 2016-07-22

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-07-22.parquet
  size:    1.0 MB
  rows:    47,665
  symbols: 3,265

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-07-22 04:00:00	AAPL	Stock	24.8125	24.8125	24.8125	24.8125	6000.0
2016-07-22 05:00:00	AAPL	Stock	24.8575	24.86	24.8575	24.86	9740.0
2016-07-22 06:00:00	AAPL	Stock	24.82	24.82	24.79	24.79	3916.0
2016-07-22 07:00:00	AAPL	Stock	24.7925	24.795	24.7475	24.76	59088.0
2016-07-22 08:00:00	AAPL	Stock	24.7725	24.7725	24.7375	24.76	270668.0
2016-07-22 09:00:00	AAPL	Stock	24.76	24.825	24.5775	24.665	23852400.0
2016-07-22 10:00:00	AAPL	Stock	24.665	24.75	24.6477	24.662	15047140.0
2016-07-22 11:00:00	AAPL	Stock	24.6625	24.7275	24.6375	24.7225	10537596.0
2016-07-22 12:00:00	AAPL	Stock	24.7225	24.7625	24.7	24.7	8968108.0
2016-07-22 13:00:00	AAPL	Stock	24.7	24.7025	24.645	24.6635	8222232.0
2016-07-22 14:00:00	AAPL	Stock	24.6638	24.6775	24.64	24.6625	7145240.0
2016-07-22 15:00:00	AAPL	Stock	24.6648	24.6675	24.6175	24.665	21453764.0
2016-07-22 16:00:00	AAPL	Stock	24.665	24.731	24.6025	24.625	9849044.0
2016-07-22 17:00:00	AAPL	Stock	24.62	24.665	24.62	24.63	247564.0
2016-07-22 18:00:00	AAPL	Stock	24.635	24.66	24.5875	24.605	118372.0
2016-07-22 19:00:00	AAPL	Stock	24.605	24.61	24.5875	24.595	60332.0
2016-07-22 06:00:00	MSFT	Stock	55.75	55.75	55.75	55.75	600.0
2016-07-22 07:00:00	MSFT	Stock	55.76	55.76	55.76	55.76	4186.0
2016-07-22 08:00:00	MSFT	Stock	55.7	55.84	55.7	55.84	12662.0
2016-07-22 09:00:00	MSFT	Stock	55.83	56.19	55.78	56.175	3829152.0
2016-07-22 10:00:00	MSFT	Stock	56.18	56.59	56.15	56.39	5378576.0
2016-07-22 11:00:00	MSFT	Stock	56.39	56.5	56.28	56.46	2909379.0
2016-07-22 12:00:00	MSFT	Stock	56.46	56.51	56.425	56.45	2195732.0
2016-07-22 13:00:00	MSFT	Stock	56.452	56.46	56.285	56.405	2170936.0
2016-07-22 14:00:00	MSFT	Stock	56.405	56.625	56.345	56.59	2979656.0
2016-07-22 15:00:00	MSFT	Stock	56.59	56.628	56.465	56.57	7687838.0
2016-07-22 16:00:00	MSFT	Stock	56.57	56.61	56.48	56.49	3552965.0
2016-07-22 17:00:00	MSFT	Stock	56.5	56.57	56.48	56.49	254567.0
2016-07-22 18:00:00	MSFT	Stock	56.55	56.55	56.49	56.5	1000.0
2016-07-22 19:00:00	MSFT	Stock	56.49	56.5	56.49	56.49	3325.0
2016-07-22 04:00:00	NVDA	Stock	1.3383	1.3383	1.3383	1.3383	4000.0
2016-07-22 07:00:00	NVDA	Stock	1.3395	1.34	1.3395	1.34	16000.0
2016-07-22 08:00:00	NVDA	Stock	1.34	1.34	1.3368	1.3368	251760.0
2016-07-22 09:00:00	NVDA	Stock	1.3378	1.3432	1.3255	1.3432	33450720.0
2016-07-22 10:00:00	NVDA	Stock	1.3432	1.3495	1.3358	1.3488	42262720.0
2016-07-22 11:00:00	NVDA	Stock	1.3485	1.3529	1.3425	1.3528	35481920.0
2016-07-22 12:00:00	NVDA	Stock	1.353	1.3572	1.3505	1.3563	33034360.0
2016-07-22 13:00:00	NVDA	Stock	1.3563	1.3635	1.3552	1.3632	29920520.0
2016-07-22 14:00:00	NVDA	Stock	1.363	1.366	1.3608	1.3658	26540120.0
2016-07-22 15:00:00	NVDA	Stock	1.3658	1.3668	1.3615	1.3668	66342320.0
2016-07-22 16:00:00	NVDA	Stock	1.3665	1.3668	1.366	1.366	18076760.0
2016-07-22 17:00:00	NVDA	Stock	1.3688	1.3688	1.3675	1.368	30000.0
2016-07-22 19:00:00	NVDA	Stock	1.3678	1.3678	1.3668	1.3668	12120.0
2016-07-22 08:00:00	AMZN	Stock	37.325	37.325	37.25	37.25	55360.0
2016-07-22 09:00:00	AMZN	Stock	37.29	37.4	37.2	37.3051	5363900.0
2016-07-22 10:00:00	AMZN	Stock	37.312	37.4245	37.289	37.3925	6443840.0
2016-07-22 11:00:00	AMZN	Stock	37.4015	37.564	37.3535	37.536	5424760.0
2016-07-22 12:00:00	AMZN	Stock	37.5345	37.5345	37.458	37.473	2837600.0
2016-07-22 13:00:00	AMZN	Stock	37.4748	37.4836	37.446	37.477	2014500.0
2016-07-22 14:00:00	AMZN	Stock	37.479	37.479	37.325	37.3495	3564200.0

> showing 50 of 47,665 rows — these rows as CSV

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