PREVIEW / stock_1hour / 2015-10-28

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-10-28.parquet
  size:    1.0 MB
  rows:    48,343
  symbols: 3,430

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-10-28 04:00:00	AAPL	Stock	28.9475	29.155	28.9475	29.1475	120956.0
2015-10-28 05:00:00	AAPL	Stock	29.1475	29.245	29.1225	29.2	109288.0
2015-10-28 06:00:00	AAPL	Stock	29.1775	29.225	29.1375	29.225	194940.0
2015-10-28 07:00:00	AAPL	Stock	29.2375	29.335	28.9125	29.0	1155816.0
2015-10-28 08:00:00	AAPL	Stock	29.02	29.325	28.9225	29.1875	4034764.0
2015-10-28 09:00:00	AAPL	Stock	29.2	29.4875	29.0575	29.2275	70078800.0
2015-10-28 10:00:00	AAPL	Stock	29.225	29.25	29.015	29.215	53602956.0
2015-10-28 11:00:00	AAPL	Stock	29.2175	29.3625	29.095	29.3575	31817720.0
2015-10-28 12:00:00	AAPL	Stock	29.3575	29.51	29.3568	29.4325	32820384.0
2015-10-28 13:00:00	AAPL	Stock	29.4325	29.5325	29.375	29.4125	28080352.0
2015-10-28 14:00:00	AAPL	Stock	29.4125	29.53	29.2725	29.5275	38688368.0
2015-10-28 15:00:00	AAPL	Stock	29.525	29.825	29.375	29.825	56218968.0
2015-10-28 16:00:00	AAPL	Stock	29.8175	29.8375	29.77	29.78	7908364.0
2015-10-28 17:00:00	AAPL	Stock	29.775	29.7975	29.755	29.7625	145760.0
2015-10-28 18:00:00	AAPL	Stock	29.7625	29.7725	29.7525	29.7525	136992.0
2015-10-28 19:00:00	AAPL	Stock	29.7575	29.7675	29.725	29.75	151956.0
2015-10-28 04:00:00	MSFT	Stock	53.7	53.7	53.7	53.7	615.0
2015-10-28 05:00:00	MSFT	Stock	53.7	53.7	53.7	53.7	873.0
2015-10-28 06:00:00	MSFT	Stock	53.65	53.65	53.63	53.65	20927.0
2015-10-28 07:00:00	MSFT	Stock	53.63	53.65	53.63	53.64	2011.0
2015-10-28 08:00:00	MSFT	Stock	53.64	53.64	53.6	53.6	4800.0
2015-10-28 09:00:00	MSFT	Stock	53.59	53.775	53.41	53.526	3771820.0
2015-10-28 10:00:00	MSFT	Stock	53.525	53.54	52.86	53.0	8416187.0
2015-10-28 11:00:00	MSFT	Stock	53.0	53.44	52.99	53.26	5975485.0
2015-10-28 12:00:00	MSFT	Stock	53.255	53.355	53.14	53.285	3537648.0
2015-10-28 13:00:00	MSFT	Stock	53.285	53.7	53.165	53.65	3321627.0
2015-10-28 14:00:00	MSFT	Stock	53.64	53.65	52.87	52.995	6704685.0
2015-10-28 15:00:00	MSFT	Stock	52.995	53.98	52.94	53.98	9561841.0
2015-10-28 16:00:00	MSFT	Stock	53.98	54.0	53.88	53.88	3148215.0
2015-10-28 17:00:00	MSFT	Stock	53.91	53.91	53.89	53.91	4800.0
2015-10-28 18:00:00	MSFT	Stock	53.91	53.93	53.89	53.93	2671.0
2015-10-28 19:00:00	MSFT	Stock	53.93	53.96	53.93	53.96	768.0
2015-10-28 04:00:00	NVDA	Stock	0.719	0.719	0.719	0.719	16040.0
2015-10-28 09:00:00	NVDA	Stock	0.7155	0.7163	0.7105	0.7138	25376040.0
2015-10-28 10:00:00	NVDA	Stock	0.714	0.7168	0.7126	0.7133	23965120.0
2015-10-28 11:00:00	NVDA	Stock	0.7133	0.7138	0.709	0.7121	24579240.0
2015-10-28 12:00:00	NVDA	Stock	0.712	0.7125	0.7098	0.7121	13793400.0
2015-10-28 13:00:00	NVDA	Stock	0.7121	0.7155	0.7108	0.7142	34090240.0
2015-10-28 14:00:00	NVDA	Stock	0.7145	0.7145	0.705	0.7095	28820360.0
2015-10-28 15:00:00	NVDA	Stock	0.7095	0.7168	0.7093	0.7168	44198680.0
2015-10-28 16:00:00	NVDA	Stock	0.7168	0.718	0.711	0.7168	6436400.0
2015-10-28 17:00:00	NVDA	Stock	0.725	0.725	0.725	0.725	8000.0
2015-10-28 05:00:00	AMZN	Stock	30.62	30.62	30.62	30.62	2000.0
2015-10-28 06:00:00	AMZN	Stock	30.6515	30.6745	30.6515	30.6745	7000.0
2015-10-28 07:00:00	AMZN	Stock	30.674	30.7	30.674	30.675	58500.0
2015-10-28 08:00:00	AMZN	Stock	30.65	30.72	30.61	30.634	188540.0
2015-10-28 09:00:00	AMZN	Stock	30.616	30.796	30.559	30.7865	8161300.0
2015-10-28 10:00:00	AMZN	Stock	30.753	30.8	30.475	30.7382	13105360.0
2015-10-28 11:00:00	AMZN	Stock	30.7485	30.821	30.6775	30.7848	7170480.0
2015-10-28 12:00:00	AMZN	Stock	30.786	30.7895	30.703	30.741	11538200.0

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

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