PREVIEW / stock_1hour / 2016-07-20

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-07-20.parquet
  size:    1.0 MB
  rows:    48,086
  symbols: 3,267

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-20 04:00:00	AAPL	Stock	24.96	24.96	24.96	24.96	496.0
2016-07-20 05:00:00	AAPL	Stock	25.0325	25.04	25.0325	25.04	1600.0
2016-07-20 06:00:00	AAPL	Stock	25.01	25.01	25.01	25.01	400.0
2016-07-20 07:00:00	AAPL	Stock	25.01	25.04	25.01	25.0325	43576.0
2016-07-20 08:00:00	AAPL	Stock	25.025	25.0375	25.005	25.02	341048.0
2016-07-20 09:00:00	AAPL	Stock	25.02	25.115	24.97	25.055	17829528.0
2016-07-20 10:00:00	AAPL	Stock	25.0525	25.065	24.965	24.999	18495296.0
2016-07-20 11:00:00	AAPL	Stock	25.0	25.02	24.9775	25.0	10444116.0
2016-07-20 12:00:00	AAPL	Stock	25.0	25.0025	24.9375	24.9578	9202300.0
2016-07-20 13:00:00	AAPL	Stock	24.9578	25.0	24.945	24.9525	7709932.0
2016-07-20 14:00:00	AAPL	Stock	24.955	24.9825	24.9375	24.9525	8838288.0
2016-07-20 15:00:00	AAPL	Stock	24.9538	25.0025	24.9338	24.9825	17037020.0
2016-07-20 16:00:00	AAPL	Stock	24.99	25.0275	24.9625	25.025	9277684.0
2016-07-20 17:00:00	AAPL	Stock	25.0375	25.05	25.01	25.0225	205852.0
2016-07-20 18:00:00	AAPL	Stock	25.025	25.05	25.0125	25.0375	72120.0
2016-07-20 19:00:00	AAPL	Stock	25.03	25.0475	25.025	25.0475	24684.0
2016-07-20 04:00:00	MSFT	Stock	55.25	55.3	55.18	55.3	10700.0
2016-07-20 05:00:00	MSFT	Stock	55.34	55.49	55.23	55.49	3800.0
2016-07-20 06:00:00	MSFT	Stock	55.43	55.45	55.25	55.45	21591.0
2016-07-20 07:00:00	MSFT	Stock	55.45	55.7	55.35	55.64	163812.0
2016-07-20 08:00:00	MSFT	Stock	55.42	55.94	55.07	55.8	1270115.0
2016-07-20 09:00:00	MSFT	Stock	55.81	56.34	55.53	55.979	20241775.0
2016-07-20 10:00:00	MSFT	Stock	55.98	56.78	55.87	56.525	18084589.0
2016-07-20 11:00:00	MSFT	Stock	56.525	56.8	56.33	56.76	10325159.0
2016-07-20 12:00:00	MSFT	Stock	56.765	56.79	56.51	56.745	5597753.0
2016-07-20 13:00:00	MSFT	Stock	56.745	56.84	56.49	56.55	5140995.0
2016-07-20 14:00:00	MSFT	Stock	56.545	56.64	56.195	56.22	6118716.0
2016-07-20 15:00:00	MSFT	Stock	56.215	56.4	55.88	55.9	13599577.0
2016-07-20 16:00:00	MSFT	Stock	55.91	56.3	55.91	55.91	5128471.0
2016-07-20 17:00:00	MSFT	Stock	56.91	56.91	55.91	56.06	389103.0
2016-07-20 18:00:00	MSFT	Stock	56.05	56.09	56.04	56.09	31690.0
2016-07-20 19:00:00	MSFT	Stock	56.08	56.15	56.08	56.1	7546.0
2016-07-20 05:00:00	NVDA	Stock	1.344	1.344	1.344	1.344	28000.0
2016-07-20 07:00:00	NVDA	Stock	1.347	1.347	1.3443	1.3443	43800.0
2016-07-20 08:00:00	NVDA	Stock	1.347	1.3488	1.3468	1.3475	338480.0
2016-07-20 09:00:00	NVDA	Stock	1.344	1.344	1.337	1.3425	30343520.0
2016-07-20 10:00:00	NVDA	Stock	1.3424	1.3495	1.342	1.3485	28245400.0
2016-07-20 11:00:00	NVDA	Stock	1.3488	1.3565	1.346	1.3528	52997200.0
2016-07-20 12:00:00	NVDA	Stock	1.353	1.3588	1.3518	1.3582	30256920.0
2016-07-20 13:00:00	NVDA	Stock	1.3582	1.3608	1.3563	1.3606	25481680.0
2016-07-20 14:00:00	NVDA	Stock	1.3608	1.3626	1.357	1.3578	33862200.0
2016-07-20 15:00:00	NVDA	Stock	1.3579	1.3582	1.353	1.3555	61722560.0
2016-07-20 16:00:00	NVDA	Stock	1.3552	1.3572	1.3552	1.3572	1931320.0
2016-07-20 17:00:00	NVDA	Stock	1.355	1.355	1.3548	1.3548	162000.0
2016-07-20 18:00:00	NVDA	Stock	1.355	1.3555	1.355	1.3555	24000.0
2016-07-20 04:00:00	AMZN	Stock	37.125	37.125	37.125	37.125	2000.0
2016-07-20 06:00:00	AMZN	Stock	37.175	37.175	37.175	37.175	2000.0
2016-07-20 07:00:00	AMZN	Stock	37.172	37.1915	37.15	37.15	127900.0
2016-07-20 08:00:00	AMZN	Stock	37.15	37.15	37.105	37.1075	125080.0
2016-07-20 09:00:00	AMZN	Stock	37.1005	37.262	37.035	37.2255	6002960.0

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

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