PREVIEW / stock_1hour / 2016-04-21

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-04-21.parquet
  size:    1.0 MB
  rows:    48,497
  symbols: 3,323

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-04-21 04:00:00	AAPL	Stock	26.7875	26.7875	26.7875	26.7875	2000.0
2016-04-21 06:00:00	AAPL	Stock	26.7875	26.8175	26.7875	26.8175	5480.0
2016-04-21 07:00:00	AAPL	Stock	26.8175	26.8625	26.7875	26.825	66544.0
2016-04-21 08:00:00	AAPL	Stock	26.805	26.8825	26.7875	26.845	224456.0
2016-04-21 09:00:00	AAPL	Stock	26.8125	26.8425	26.38	26.49	26580356.0
2016-04-21 10:00:00	AAPL	Stock	26.488	26.6638	26.45	26.605	19801544.0
2016-04-21 11:00:00	AAPL	Stock	26.6058	26.64	26.4525	26.4552	15314564.0
2016-04-21 12:00:00	AAPL	Stock	26.455	26.5025	26.4225	26.425	9880084.0
2016-04-21 13:00:00	AAPL	Stock	26.425	26.4825	26.3812	26.4775	10542072.0
2016-04-21 14:00:00	AAPL	Stock	26.4775	26.5225	26.4325	26.4925	11467960.0
2016-04-21 15:00:00	AAPL	Stock	26.49	26.53	26.48	26.4925	16310720.0
2016-04-21 16:00:00	AAPL	Stock	26.4925	26.5962	26.345	26.3625	6418508.0
2016-04-21 17:00:00	AAPL	Stock	26.3625	26.37	26.25	26.2625	175072.0
2016-04-21 18:00:00	AAPL	Stock	26.28	26.3	26.2275	26.2725	204240.0
2016-04-21 19:00:00	AAPL	Stock	26.2575	26.3125	26.2525	26.3	101124.0
2016-04-21 06:00:00	MSFT	Stock	55.85	55.85	55.7	55.8	7650.0
2016-04-21 07:00:00	MSFT	Stock	55.85	55.85	55.75	55.75	14000.0
2016-04-21 08:00:00	MSFT	Stock	55.75	55.85	55.72	55.84	39638.0
2016-04-21 09:00:00	MSFT	Stock	55.8	56.01	55.415	55.505	5005545.0
2016-04-21 10:00:00	MSFT	Stock	55.51	56.115	55.5	56.05	4500613.0
2016-04-21 11:00:00	MSFT	Stock	56.05	56.23	55.875	55.88	4214099.0
2016-04-21 12:00:00	MSFT	Stock	55.885	55.905	55.63	55.855	3444465.0
2016-04-21 13:00:00	MSFT	Stock	55.855	55.99	55.685	55.83	3491566.0
2016-04-21 14:00:00	MSFT	Stock	55.824	55.88	55.62	55.85	3700221.0
2016-04-21 15:00:00	MSFT	Stock	55.85	55.97	55.71	55.788	6846201.0
2016-04-21 16:00:00	MSFT	Stock	55.8	56.5	52.9	54.15	3866642.0
2016-04-21 17:00:00	MSFT	Stock	54.15	54.19	52.91	52.95	637337.0
2016-04-21 18:00:00	MSFT	Stock	52.92	53.1	52.27	52.81	353571.0
2016-04-21 19:00:00	MSFT	Stock	52.81	52.96	52.72	52.92	65203.0
2016-04-21 09:00:00	NVDA	Stock	0.9115	0.9158	0.9062	0.909	15050760.0
2016-04-21 10:00:00	NVDA	Stock	0.9088	0.9158	0.9082	0.9148	40551120.0
2016-04-21 11:00:00	NVDA	Stock	0.9148	0.9158	0.9066	0.9069	27953320.0
2016-04-21 12:00:00	NVDA	Stock	0.907	0.9138	0.9066	0.913	16658160.0
2016-04-21 13:00:00	NVDA	Stock	0.9131	0.9145	0.9113	0.9126	15282600.0
2016-04-21 14:00:00	NVDA	Stock	0.9125	0.9135	0.9092	0.9118	14665400.0
2016-04-21 15:00:00	NVDA	Stock	0.9118	0.913	0.9102	0.9102	31114400.0
2016-04-21 16:00:00	NVDA	Stock	0.9102	0.9133	0.9102	0.9102	10933040.0
2016-04-21 17:00:00	NVDA	Stock	0.9078	0.9102	0.9075	0.9075	155480.0
2016-04-21 18:00:00	NVDA	Stock	0.9075	0.91	0.9075	0.91	31920.0
2016-04-21 19:00:00	NVDA	Stock	0.9075	0.908	0.907	0.907	78000.0
2016-04-21 07:00:00	AMZN	Stock	31.695	31.695	31.6895	31.6895	6480.0
2016-04-21 08:00:00	AMZN	Stock	31.675	31.6945	31.528	31.65	91220.0
2016-04-21 09:00:00	AMZN	Stock	31.6	31.725	31.5	31.5555	4763320.0
2016-04-21 10:00:00	AMZN	Stock	31.5555	31.8774	31.5375	31.8395	7713580.0
2016-04-21 11:00:00	AMZN	Stock	31.8415	31.891	31.576	31.606	5241240.0
2016-04-21 12:00:00	AMZN	Stock	31.591	31.674	31.5065	31.574	4698440.0
2016-04-21 13:00:00	AMZN	Stock	31.5745	31.719	31.5735	31.592	4479980.0
2016-04-21 14:00:00	AMZN	Stock	31.5935	31.6495	31.52	31.5526	5144140.0
2016-04-21 15:00:00	AMZN	Stock	31.5475	31.593	31.425	31.55	9702720.0
2016-04-21 16:00:00	AMZN	Stock	31.55	31.6	30.95	31.2875	1644480.0

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

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