PREVIEW / stock_1hour / 2016-01-28

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-01-28.parquet
  size:    1.0 MB
  rows:    48,474
  symbols: 3,361

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-28 04:00:00	AAPL	Stock	23.5	23.75	23.5	23.75	77308.0
2016-01-28 05:00:00	AAPL	Stock	23.7125	23.7125	23.625	23.625	10184.0
2016-01-28 06:00:00	AAPL	Stock	23.575	23.6375	23.5275	23.5375	84116.0
2016-01-28 07:00:00	AAPL	Stock	23.535	23.5375	23.425	23.475	206480.0
2016-01-28 08:00:00	AAPL	Stock	23.4925	23.5625	23.375	23.47	828772.0
2016-01-28 09:00:00	AAPL	Stock	23.4725	23.5875	23.3025	23.4075	37945148.0
2016-01-28 10:00:00	AAPL	Stock	23.4062	23.4557	23.0975	23.36	47949764.0
2016-01-28 11:00:00	AAPL	Stock	23.36	23.47	23.2425	23.2525	23354308.0
2016-01-28 12:00:00	AAPL	Stock	23.2525	23.4875	23.25	23.355	21540472.0
2016-01-28 13:00:00	AAPL	Stock	23.3525	23.4688	23.31	23.37	17011164.0
2016-01-28 14:00:00	AAPL	Stock	23.3675	23.63	23.36	23.4738	22009868.0
2016-01-28 15:00:00	AAPL	Stock	23.4725	23.6	23.415	23.52	28626696.0
2016-01-28 16:00:00	AAPL	Stock	23.5225	23.5375	23.4	23.4175	4298000.0
2016-01-28 17:00:00	AAPL	Stock	23.4075	23.4475	23.3875	23.425	126216.0
2016-01-28 18:00:00	AAPL	Stock	23.425	23.5225	23.4125	23.455	74892.0
2016-01-28 19:00:00	AAPL	Stock	23.45	23.45	23.4125	23.4125	40316.0
2016-01-28 04:00:00	MSFT	Stock	51.85	51.85	51.85	51.85	1249.0
2016-01-28 06:00:00	MSFT	Stock	51.7	51.7	51.52	51.52	5831.0
2016-01-28 07:00:00	MSFT	Stock	51.4	51.68	51.4	51.65	5996.0
2016-01-28 08:00:00	MSFT	Stock	51.66	51.67	51.43	51.57	43662.0
2016-01-28 09:00:00	MSFT	Stock	51.57	52.15	51.465	52.075	5638458.0
2016-01-28 10:00:00	MSFT	Stock	52.07	52.07	51.25	51.49	6973136.0
2016-01-28 11:00:00	MSFT	Stock	51.485	51.89	51.28	51.365	5112150.0
2016-01-28 12:00:00	MSFT	Stock	51.36	52.21	51.34	51.89	5258468.0
2016-01-28 13:00:00	MSFT	Stock	51.885	52.02	51.45	51.57	6091384.0
2016-01-28 14:00:00	MSFT	Stock	51.56	52.02	51.514	51.76	6113508.0
2016-01-28 15:00:00	MSFT	Stock	51.76	52.2	51.72	52.06	12040956.0
2016-01-28 16:00:00	MSFT	Stock	52.055	56.37	51.3	54.1	9382049.0
2016-01-28 17:00:00	MSFT	Stock	54.06	54.09	52.5	52.85	950189.0
2016-01-28 18:00:00	MSFT	Stock	52.85	54.4	52.75	54.1	638204.0
2016-01-28 19:00:00	MSFT	Stock	54.1	54.45	53.8	54.25	74236.0
2016-01-28 09:00:00	NVDA	Stock	0.7145	0.7173	0.702	0.703	28303240.0
2016-01-28 10:00:00	NVDA	Stock	0.7028	0.703	0.6875	0.69	77263320.0
2016-01-28 11:00:00	NVDA	Stock	0.69	0.696	0.6878	0.6902	39452960.0
2016-01-28 12:00:00	NVDA	Stock	0.69	0.699	0.69	0.6962	18503120.0
2016-01-28 13:00:00	NVDA	Stock	0.6962	0.7008	0.6945	0.6988	26291840.0
2016-01-28 14:00:00	NVDA	Stock	0.6985	0.7042	0.6971	0.6978	24099920.0
2016-01-28 15:00:00	NVDA	Stock	0.6978	0.7026	0.6969	0.7012	41768840.0
2016-01-28 16:00:00	NVDA	Stock	0.7012	0.7012	0.7012	0.7012	575600.0
2016-01-28 04:00:00	AMZN	Stock	30.25	30.25	30.1	30.175	55520.0
2016-01-28 05:00:00	AMZN	Stock	30.15	30.15	30.068	30.115	36800.0
2016-01-28 06:00:00	AMZN	Stock	30.125	30.1475	29.933	30.09	136280.0
2016-01-28 07:00:00	AMZN	Stock	30.187	30.3395	30.124	30.2325	1083040.0
2016-01-28 08:00:00	AMZN	Stock	30.232	30.35	30.163	30.25	2009960.0
2016-01-28 09:00:00	AMZN	Stock	30.25	30.823	30.2155	30.4264	36209800.0
2016-01-28 10:00:00	AMZN	Stock	30.4175	30.5652	29.8775	30.3455	26242180.0
2016-01-28 11:00:00	AMZN	Stock	30.3455	30.727	30.3398	30.681	19287780.0
2016-01-28 12:00:00	AMZN	Stock	30.6715	31.443	30.625	31.306	27667480.0
2016-01-28 13:00:00	AMZN	Stock	31.303	31.375	31.0143	31.275	19475700.0
2016-01-28 14:00:00	AMZN	Stock	31.2766	31.6	31.254	31.3355	22298460.0

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

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