PREVIEW / stock_1hour / 2015-06-08

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-06-08.parquet
  size:    1.0 MB
  rows:    48,644
  symbols: 3,503

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
2015-06-08 04:00:00	AAPL	Stock	32.25	32.25	32.17	32.2125	33804.0
2015-06-08 05:00:00	AAPL	Stock	32.205	32.2375	32.205	32.2375	9812.0
2015-06-08 06:00:00	AAPL	Stock	32.22	32.23	32.19	32.205	31324.0
2015-06-08 07:00:00	AAPL	Stock	32.2	32.275	32.195	32.255	119636.0
2015-06-08 08:00:00	AAPL	Stock	32.2575	32.275	32.2	32.21	634748.0
2015-06-08 09:00:00	AAPL	Stock	32.2075	32.2425	32.0375	32.0925	23367360.0
2015-06-08 10:00:00	AAPL	Stock	32.0925	32.3025	32.0575	32.11	27803660.0
2015-06-08 11:00:00	AAPL	Stock	32.11	32.1825	31.975	32.03	19288372.0
2015-06-08 12:00:00	AAPL	Stock	32.03	32.03	31.84	31.8425	23309496.0
2015-06-08 13:00:00	AAPL	Stock	31.8425	31.9365	31.7075	31.8512	31854968.0
2015-06-08 14:00:00	AAPL	Stock	31.8525	32.135	31.795	32.103	28371756.0
2015-06-08 15:00:00	AAPL	Stock	32.105	32.1125	31.94	31.94	33991116.0
2015-06-08 16:00:00	AAPL	Stock	31.95	31.97	31.9375	31.955	11063604.0
2015-06-08 17:00:00	AAPL	Stock	31.955	31.96	31.9475	31.955	132884.0
2015-06-08 18:00:00	AAPL	Stock	31.955	31.9625	31.945	31.9475	72080.0
2015-06-08 19:00:00	AAPL	Stock	31.9425	31.955	31.9375	31.9425	109740.0
2015-06-08 04:00:00	MSFT	Stock	46.15	46.17	46.15	46.17	700.0
2015-06-08 06:00:00	MSFT	Stock	46.17	46.17	46.17	46.17	350.0
2015-06-08 07:00:00	MSFT	Stock	46.16	46.16	46.15	46.15	200.0
2015-06-08 08:00:00	MSFT	Stock	46.19	46.25	46.09	46.16	16399.0
2015-06-08 09:00:00	MSFT	Stock	46.13	46.43	46.055	46.19	2780706.0
2015-06-08 10:00:00	MSFT	Stock	46.2	46.26	46.05	46.17	2703246.0
2015-06-08 11:00:00	MSFT	Stock	46.18	46.25	45.86	45.89	2377433.0
2015-06-08 12:00:00	MSFT	Stock	45.89	45.98	45.72	45.73	1878653.0
2015-06-08 13:00:00	MSFT	Stock	45.73	45.88	45.71	45.76	2212226.0
2015-06-08 14:00:00	MSFT	Stock	45.76	45.97	45.67	45.96	2426859.0
2015-06-08 15:00:00	MSFT	Stock	45.965	45.97	45.72	45.74	4043067.0
2015-06-08 16:00:00	MSFT	Stock	45.73	46.19	45.73	45.77	2652067.0
2015-06-08 18:00:00	MSFT	Stock	45.78	45.78	45.73	45.73	11522.0
2015-06-08 19:00:00	MSFT	Stock	45.73	45.74	45.71	45.74	1900.0
2015-06-08 09:00:00	NVDA	Stock	0.5542	0.5585	0.5528	0.5528	33160560.0
2015-06-08 10:00:00	NVDA	Stock	0.5528	0.553	0.548	0.549	48028840.0
2015-06-08 11:00:00	NVDA	Stock	0.5492	0.5498	0.543	0.543	29562920.0
2015-06-08 12:00:00	NVDA	Stock	0.543	0.5445	0.5405	0.5406	29884240.0
2015-06-08 13:00:00	NVDA	Stock	0.5405	0.5422	0.5375	0.5398	38138160.0
2015-06-08 14:00:00	NVDA	Stock	0.5398	0.5422	0.5384	0.5418	21362080.0
2015-06-08 15:00:00	NVDA	Stock	0.5416	0.546	0.5409	0.5438	84078080.0
2015-06-08 16:00:00	NVDA	Stock	0.5438	0.5452	0.5438	0.5452	11936440.0
2015-06-08 08:00:00	AMZN	Stock	21.2935	21.35	21.2935	21.3475	37600.0
2015-06-08 09:00:00	AMZN	Stock	21.347	21.35	21.1075	21.1715	8193520.0
2015-06-08 10:00:00	AMZN	Stock	21.1795	21.2435	21.14	21.226	6176440.0
2015-06-08 11:00:00	AMZN	Stock	21.226	21.2745	21.185	21.1975	3602080.0
2015-06-08 12:00:00	AMZN	Stock	21.2045	21.2045	21.11	21.125	5587840.0
2015-06-08 13:00:00	AMZN	Stock	21.124	21.164	21.0713	21.151	6033260.0
2015-06-08 14:00:00	AMZN	Stock	21.1595	21.205	21.1	21.2	3936160.0
2015-06-08 15:00:00	AMZN	Stock	21.2015	21.2125	21.161	21.1755	5271540.0
2015-06-08 16:00:00	AMZN	Stock	21.175	21.18	21.175	21.18	1248500.0
2015-06-08 17:00:00	AMZN	Stock	21.1875	21.1875	21.1875	21.1875	3000.0
2015-06-08 18:00:00	AMZN	Stock	21.195	21.195	21.195	21.195	15800.0
2015-06-08 08:00:00	GOOGL	Stock	27.45	27.45	27.45	27.45	4000.0

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

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