PREVIEW / stock_1hour / 2016-01-13

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-01-13.parquet
  size:    1.0 MB
  rows:    49,030
  symbols: 3,397

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-01-13 04:00:00	AAPL	Stock	25.2375	25.25	25.18	25.19	31028.0
2016-01-13 05:00:00	AAPL	Stock	25.2125	25.22	25.135	25.1875	38500.0
2016-01-13 06:00:00	AAPL	Stock	25.1925	25.225	25.1	25.1225	90316.0
2016-01-13 07:00:00	AAPL	Stock	25.135	25.1725	25.0875	25.1	135696.0
2016-01-13 08:00:00	AAPL	Stock	25.1	25.205	25.0725	25.085	550476.0
2016-01-13 09:00:00	AAPL	Stock	25.065	25.205	24.97	25.1138	31709948.0
2016-01-13 10:00:00	AAPL	Stock	25.1125	25.1925	24.9625	25.065	31304900.0
2016-01-13 11:00:00	AAPL	Stock	25.0638	25.2975	25.02	25.1775	29769532.0
2016-01-13 12:00:00	AAPL	Stock	25.1775	25.1875	24.9775	25.03	22023480.0
2016-01-13 13:00:00	AAPL	Stock	25.03	25.045	24.565	24.6	27840432.0
2016-01-13 14:00:00	AAPL	Stock	24.5952	24.7275	24.4625	24.5375	32564512.0
2016-01-13 15:00:00	AAPL	Stock	24.5375	24.6675	24.325	24.3525	48342300.0
2016-01-13 16:00:00	AAPL	Stock	24.3475	24.375	24.325	24.37	7540912.0
2016-01-13 17:00:00	AAPL	Stock	24.3625	24.395	24.325	24.3375	431596.0
2016-01-13 18:00:00	AAPL	Stock	24.34	24.3725	24.3375	24.355	65152.0
2016-01-13 19:00:00	AAPL	Stock	24.355	24.3625	24.3175	24.325	129360.0
2016-01-13 04:00:00	MSFT	Stock	53.61	53.72	53.54	53.61	22010.0
2016-01-13 05:00:00	MSFT	Stock	53.66	54.0	53.61	54.0	43284.0
2016-01-13 06:00:00	MSFT	Stock	53.94	54.03	53.77	53.85	26516.0
2016-01-13 07:00:00	MSFT	Stock	53.85	53.85	53.5	53.5	77775.0
2016-01-13 08:00:00	MSFT	Stock	53.75	54.14	53.5	53.96	449079.0
2016-01-13 09:00:00	MSFT	Stock	53.95	54.1	53.735	53.92	7269157.0
2016-01-13 10:00:00	MSFT	Stock	53.92	53.96	53.72	53.85	8274390.0
2016-01-13 11:00:00	MSFT	Stock	53.84	53.84	53.05	53.12	9115553.0
2016-01-13 12:00:00	MSFT	Stock	53.12	53.34	52.8	52.84	5715989.0
2016-01-13 13:00:00	MSFT	Stock	52.84	52.96	52.18	52.27	7609047.0
2016-01-13 14:00:00	MSFT	Stock	52.26	52.26	51.304	51.79	9632185.0
2016-01-13 15:00:00	MSFT	Stock	51.79	52.25	51.565	51.66	11177892.0
2016-01-13 16:00:00	MSFT	Stock	51.64	52.521	51.64	51.77	3739117.0
2016-01-13 17:00:00	MSFT	Stock	51.77	51.77	51.64	51.72	76110.0
2016-01-13 18:00:00	MSFT	Stock	51.74	51.75	51.7	51.7	3875.0
2016-01-13 19:00:00	MSFT	Stock	51.65	51.73	51.64	51.69	2585.0
2016-01-13 08:00:00	NVDA	Stock	0.7563	0.7633	0.7563	0.7625	12000.0
2016-01-13 09:00:00	NVDA	Stock	0.7545	0.7652	0.7545	0.761	48869800.0
2016-01-13 10:00:00	NVDA	Stock	0.7612	0.7615	0.7525	0.754	47928080.0
2016-01-13 11:00:00	NVDA	Stock	0.7538	0.7595	0.7503	0.7532	59079040.0
2016-01-13 12:00:00	NVDA	Stock	0.7532	0.7551	0.75	0.7505	31263720.0
2016-01-13 13:00:00	NVDA	Stock	0.7505	0.7524	0.7422	0.7422	59139840.0
2016-01-13 14:00:00	NVDA	Stock	0.7423	0.7438	0.7332	0.7365	51636120.0
2016-01-13 15:00:00	NVDA	Stock	0.7368	0.7423	0.7308	0.7318	110132240.0
2016-01-13 16:00:00	NVDA	Stock	0.7315	0.7348	0.7303	0.7315	413600.0
2016-01-13 17:00:00	NVDA	Stock	0.7313	0.7313	0.7313	0.7313	10000.0
2016-01-13 04:00:00	AMZN	Stock	31.15	31.195	31.1395	31.1395	19060.0
2016-01-13 06:00:00	AMZN	Stock	31.0655	31.0655	31.0655	31.0655	6640.0
2016-01-13 07:00:00	AMZN	Stock	31.0465	31.1225	31.006	31.006	87880.0
2016-01-13 08:00:00	AMZN	Stock	31.1125	31.175	31.025	31.125	248360.0
2016-01-13 09:00:00	AMZN	Stock	31.125	31.125	30.4415	30.4752	12761880.0
2016-01-13 10:00:00	AMZN	Stock	30.4875	30.5	30.134	30.175	18373060.0
2016-01-13 11:00:00	AMZN	Stock	30.1755	30.3242	29.925	30.0865	15651760.0
2016-01-13 12:00:00	AMZN	Stock	30.0865	30.1694	29.979	30.0425	12201860.0

> showing 50 of 49,030 rows — these rows as CSV

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