PREVIEW / stock_1hour / 2016-06-24

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-06-24.parquet
  size:    1.1 MB
  rows:    52,596
  symbols: 3,289

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-06-24 04:00:00	AAPL	Stock	23.3925	23.3925	23.075	23.225	423828.0
2016-06-24 05:00:00	AAPL	Stock	23.225	23.33	23.225	23.2975	135232.0
2016-06-24 06:00:00	AAPL	Stock	23.275	23.4725	23.1375	23.195	612656.0
2016-06-24 07:00:00	AAPL	Stock	23.2	23.3625	23.1825	23.3225	416284.0
2016-06-24 08:00:00	AAPL	Stock	23.325	23.445	23.13	23.35	1583740.0
2016-06-24 09:00:00	AAPL	Stock	23.35	23.6638	23.1625	23.5725	40207692.0
2016-06-24 10:00:00	AAPL	Stock	23.565	23.6225	23.4275	23.4575	31812812.0
2016-06-24 11:00:00	AAPL	Stock	23.4565	23.5925	23.3925	23.53	23336700.0
2016-06-24 12:00:00	AAPL	Stock	23.5325	23.545	23.3875	23.4125	17287644.0
2016-06-24 13:00:00	AAPL	Stock	23.415	23.475	23.385	23.41	15871120.0
2016-06-24 14:00:00	AAPL	Stock	23.4125	23.435	23.2562	23.3075	21848208.0
2016-06-24 15:00:00	AAPL	Stock	23.3062	23.4638	23.2025	23.3425	47687976.0
2016-06-24 16:00:00	AAPL	Stock	23.3362	23.3875	23.3362	23.37	52445164.0
2016-06-24 17:00:00	AAPL	Stock	23.375	23.3825	23.35	23.3675	156300.0
2016-06-24 18:00:00	AAPL	Stock	23.355	23.3725	23.325	23.325	128980.0
2016-06-24 19:00:00	AAPL	Stock	23.325	23.3375	23.3	23.315	151316.0
2016-06-24 04:00:00	MSFT	Stock	51.51	51.51	49.74	50.5	9305.0
2016-06-24 06:00:00	MSFT	Stock	50.06	50.06	49.86	50.0	7415.0
2016-06-24 07:00:00	MSFT	Stock	50.33	50.41	49.95	50.21	24619.0
2016-06-24 08:00:00	MSFT	Stock	50.25	50.59	49.86	50.45	69447.0
2016-06-24 09:00:00	MSFT	Stock	50.45	50.76	49.75	50.68	9101302.0
2016-06-24 10:00:00	MSFT	Stock	50.68	50.94	50.25	50.26	7927117.0
2016-06-24 11:00:00	MSFT	Stock	50.265	50.35	49.95	50.06	6838543.0
2016-06-24 12:00:00	MSFT	Stock	50.07	50.1	49.75	49.845	4943811.0
2016-06-24 13:00:00	MSFT	Stock	49.85	50.135	49.77	49.945	3930515.0
2016-06-24 14:00:00	MSFT	Stock	49.95	50.06	49.71	49.87	6096659.0
2016-06-24 15:00:00	MSFT	Stock	49.87	50.03	49.52	49.76	20248941.0
2016-06-24 16:00:00	MSFT	Stock	49.83	49.91	49.73	49.77	38627766.0
2016-06-24 17:00:00	MSFT	Stock	49.77	49.83	49.6	49.65	82093.0
2016-06-24 18:00:00	MSFT	Stock	49.63	49.97	49.62	49.62	4858.0
2016-06-24 19:00:00	MSFT	Stock	49.69	49.69	49.55	49.64	3877.0
2016-06-24 04:00:00	NVDA	Stock	1.1875	1.1875	1.1375	1.1582	38040.0
2016-06-24 05:00:00	NVDA	Stock	1.1625	1.1625	1.1625	1.1625	5200.0
2016-06-24 06:00:00	NVDA	Stock	1.1625	1.1625	1.143	1.1538	107560.0
2016-06-24 07:00:00	NVDA	Stock	1.1625	1.1793	1.1538	1.1568	436760.0
2016-06-24 08:00:00	NVDA	Stock	1.1635	1.1798	1.1538	1.1688	1547480.0
2016-06-24 09:00:00	NVDA	Stock	1.1672	1.1832	1.1545	1.179	89161840.0
2016-06-24 10:00:00	NVDA	Stock	1.1788	1.184	1.1635	1.1638	93555440.0
2016-06-24 11:00:00	NVDA	Stock	1.1638	1.1676	1.1579	1.1622	69037040.0
2016-06-24 12:00:00	NVDA	Stock	1.1624	1.1638	1.1475	1.1495	61755360.0
2016-06-24 13:00:00	NVDA	Stock	1.1495	1.1565	1.147	1.1474	38261400.0
2016-06-24 14:00:00	NVDA	Stock	1.1475	1.1498	1.1325	1.1394	93048920.0
2016-06-24 15:00:00	NVDA	Stock	1.1394	1.1512	1.1359	1.143	125397880.0
2016-06-24 16:00:00	NVDA	Stock	1.1432	1.1435	1.1378	1.1378	238937240.0
2016-06-24 17:00:00	NVDA	Stock	1.1388	1.1388	1.1375	1.1378	116360.0
2016-06-24 18:00:00	NVDA	Stock	1.1395	1.1432	1.138	1.138	20400.0
2016-06-24 19:00:00	NVDA	Stock	1.1328	1.1375	1.1325	1.1325	237600.0
2016-06-24 04:00:00	AMZN	Stock	35.6	35.6	34.4	34.525	171300.0
2016-06-24 05:00:00	AMZN	Stock	34.68	34.75	34.645	34.645	61300.0
2016-06-24 06:00:00	AMZN	Stock	34.606	34.6725	34.3505	34.3505	226520.0

> showing 50 of 52,596 rows — these rows as CSV

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