PREVIEW / stock_1hour / 2016-05-10

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-05-10.parquet
  size:    1.0 MB
  rows:    47,995
  symbols: 3,279

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-05-10 04:00:00	AAPL	Stock	23.2625	23.2625	23.2625	23.2625	400.0
2016-05-10 05:00:00	AAPL	Stock	23.3725	23.375	23.3575	23.375	16696.0
2016-05-10 06:00:00	AAPL	Stock	23.325	23.35	23.3	23.3125	15220.0
2016-05-10 07:00:00	AAPL	Stock	23.3	23.3	23.225	23.2825	133264.0
2016-05-10 08:00:00	AAPL	Stock	23.2525	23.3	23.24	23.2925	177392.0
2016-05-10 09:00:00	AAPL	Stock	23.295	23.3475	23.0625	23.1025	22012952.0
2016-05-10 10:00:00	AAPL	Stock	23.105	23.2725	23.0275	23.2362	28297436.0
2016-05-10 11:00:00	AAPL	Stock	23.235	23.3725	23.2075	23.36	18833904.0
2016-05-10 12:00:00	AAPL	Stock	23.36	23.3925	23.325	23.3275	10264272.0
2016-05-10 13:00:00	AAPL	Stock	23.3275	23.3375	23.2725	23.3112	8819708.0
2016-05-10 14:00:00	AAPL	Stock	23.31	23.315	23.2175	23.2922	13723128.0
2016-05-10 15:00:00	AAPL	Stock	23.2925	23.3675	23.2838	23.35	18011316.0
2016-05-10 16:00:00	AAPL	Stock	23.355	23.355	23.3025	23.3375	4291708.0
2016-05-10 17:00:00	AAPL	Stock	23.3375	23.3375	23.315	23.3225	78300.0
2016-05-10 18:00:00	AAPL	Stock	23.3225	23.335	23.32	23.32	14820.0
2016-05-10 19:00:00	AAPL	Stock	23.33	23.33	23.32	23.325	24636.0
2016-05-10 07:00:00	MSFT	Stock	50.29	50.29	50.07	50.19	1100.0
2016-05-10 08:00:00	MSFT	Stock	50.1	50.2	50.1	50.11	2452.0
2016-05-10 09:00:00	MSFT	Stock	50.2	50.57	50.07	50.38	2419578.0
2016-05-10 10:00:00	MSFT	Stock	50.38	50.65	50.34	50.583	2569715.0
2016-05-10 11:00:00	MSFT	Stock	50.58	50.68	50.47	50.67	2051773.0
2016-05-10 12:00:00	MSFT	Stock	50.665	50.85	50.665	50.84	2105421.0
2016-05-10 13:00:00	MSFT	Stock	50.84	50.91	50.79	50.89	1908973.0
2016-05-10 14:00:00	MSFT	Stock	50.89	50.99	50.835	50.84	2768473.0
2016-05-10 15:00:00	MSFT	Stock	50.845	51.1	50.825	51.02	5417775.0
2016-05-10 16:00:00	MSFT	Stock	51.02	51.05	50.82	50.92	1815192.0
2016-05-10 17:00:00	MSFT	Stock	50.94	50.94	50.93	50.94	9684.0
2016-05-10 18:00:00	MSFT	Stock	50.95	50.95	50.95	50.95	200.0
2016-05-10 19:00:00	MSFT	Stock	50.94	50.94	50.92	50.92	2200.0
2016-05-10 07:00:00	NVDA	Stock	0.875	0.875	0.875	0.875	4000.0
2016-05-10 08:00:00	NVDA	Stock	0.8802	0.8802	0.88	0.88	24000.0
2016-05-10 09:00:00	NVDA	Stock	0.8855	0.8893	0.879	0.8893	26844560.0
2016-05-10 10:00:00	NVDA	Stock	0.8894	0.8968	0.8894	0.8951	51158720.0
2016-05-10 11:00:00	NVDA	Stock	0.895	0.9002	0.8936	0.895	41428000.0
2016-05-10 12:00:00	NVDA	Stock	0.8949	0.8994	0.8936	0.8984	29994160.0
2016-05-10 13:00:00	NVDA	Stock	0.8982	0.8985	0.8945	0.8975	24062960.0
2016-05-10 14:00:00	NVDA	Stock	0.8975	0.9005	0.897	0.8978	25124840.0
2016-05-10 15:00:00	NVDA	Stock	0.8978	0.8995	0.8958	0.899	49577240.0
2016-05-10 16:00:00	NVDA	Stock	0.8985	0.899	0.8975	0.899	1194320.0
2016-05-10 17:00:00	NVDA	Stock	0.899	0.9	0.899	0.899	589480.0
2016-05-10 18:00:00	NVDA	Stock	0.899	0.9033	0.899	0.9033	104440.0
2016-05-10 19:00:00	NVDA	Stock	0.9062	0.9062	0.9062	0.9062	120000.0
2016-05-10 04:00:00	AMZN	Stock	34.3375	34.4215	34.335	34.4215	40420.0
2016-05-10 05:00:00	AMZN	Stock	34.425	34.5	34.425	34.5	39000.0
2016-05-10 06:00:00	AMZN	Stock	34.55	34.95	34.55	34.75	214740.0
2016-05-10 07:00:00	AMZN	Stock	34.7	34.8	34.567	34.8	245580.0
2016-05-10 08:00:00	AMZN	Stock	34.76	34.795	33.9	34.575	840620.0
2016-05-10 09:00:00	AMZN	Stock	34.6	34.9855	34.6	34.9328	26542620.0
2016-05-10 10:00:00	AMZN	Stock	34.926	35.07	34.8142	34.905	17866500.0
2016-05-10 11:00:00	AMZN	Stock	34.901	34.96	34.7945	34.9491	11761120.0

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

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