PREVIEW / stock_1hour / 2015-12-28

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-12-28.parquet
  size:    1.0 MB
  rows:    49,009
  symbols: 3,423

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-12-28 05:00:00	AAPL	Stock	26.925	26.925	26.9075	26.9075	4044.0
2015-12-28 07:00:00	AAPL	Stock	26.8425	26.8725	26.7925	26.825	30040.0
2015-12-28 08:00:00	AAPL	Stock	26.8525	26.925	26.825	26.925	108240.0
2015-12-28 09:00:00	AAPL	Stock	26.925	26.9375	26.675	26.6935	15498000.0
2015-12-28 10:00:00	AAPL	Stock	26.695	26.7375	26.5452	26.5525	19864300.0
2015-12-28 11:00:00	AAPL	Stock	26.5525	26.82	26.55	26.7925	14838780.0
2015-12-28 12:00:00	AAPL	Stock	26.7925	26.8188	26.7125	26.744	8611004.0
2015-12-28 13:00:00	AAPL	Stock	26.745	26.835	26.72	26.737	7380524.0
2015-12-28 14:00:00	AAPL	Stock	26.7375	26.765	26.6975	26.702	7680912.0
2015-12-28 15:00:00	AAPL	Stock	26.704	26.7175	26.6275	26.705	16915264.0
2015-12-28 16:00:00	AAPL	Stock	26.705	26.72	26.6875	26.7125	7579516.0
2015-12-28 17:00:00	AAPL	Stock	26.72	26.72	26.7075	26.7075	38292.0
2015-12-28 18:00:00	AAPL	Stock	26.7175	26.73	26.7175	26.725	48428.0
2015-12-28 19:00:00	AAPL	Stock	26.7225	26.7225	26.7075	26.7175	14624.0
2015-12-28 07:00:00	MSFT	Stock	55.23	55.23	55.23	55.23	600.0
2015-12-28 08:00:00	MSFT	Stock	55.39	55.5	55.3	55.5	5900.0
2015-12-28 09:00:00	MSFT	Stock	55.38	55.5	55.03	55.27	2432442.0
2015-12-28 10:00:00	MSFT	Stock	55.28	55.285	54.98	55.04	2727912.0
2015-12-28 11:00:00	MSFT	Stock	55.04	55.34	55.01	55.3	2353862.0
2015-12-28 12:00:00	MSFT	Stock	55.3	55.42	55.22	55.37	1845331.0
2015-12-28 13:00:00	MSFT	Stock	55.37	55.73	55.368	55.61	2483404.0
2015-12-28 14:00:00	MSFT	Stock	55.61	55.9	55.61	55.89	2773389.0
2015-12-28 15:00:00	MSFT	Stock	55.89	55.95	55.76	55.95	4638265.0
2015-12-28 16:00:00	MSFT	Stock	55.95	56.01	55.525	56.01	1235954.0
2015-12-28 17:00:00	MSFT	Stock	56.01	56.01	55.95	56.0	4372.0
2015-12-28 18:00:00	MSFT	Stock	56.0	56.0	56.0	56.0	100.0
2015-12-28 19:00:00	MSFT	Stock	55.98	55.98	55.98	55.98	2912.0
2015-12-28 08:00:00	NVDA	Stock	0.8232	0.8232	0.8212	0.8212	76000.0
2015-12-28 09:00:00	NVDA	Stock	0.8212	0.8292	0.8118	0.8164	24750360.0
2015-12-28 10:00:00	NVDA	Stock	0.8164	0.8168	0.809	0.8101	20868480.0
2015-12-28 11:00:00	NVDA	Stock	0.81	0.8185	0.809	0.8172	17794360.0
2015-12-28 12:00:00	NVDA	Stock	0.817	0.8203	0.817	0.82	13195680.0
2015-12-28 13:00:00	NVDA	Stock	0.8199	0.8246	0.8195	0.8229	11663640.0
2015-12-28 14:00:00	NVDA	Stock	0.8228	0.826	0.822	0.8252	11295520.0
2015-12-28 15:00:00	NVDA	Stock	0.8252	0.8285	0.8245	0.8285	29664520.0
2015-12-28 16:00:00	NVDA	Stock	0.8285	0.8292	0.8285	0.8285	6727280.0
2015-12-28 04:00:00	AMZN	Stock	33.25	33.25	33.25	33.25	2000.0
2015-12-28 05:00:00	AMZN	Stock	33.149	33.149	33.149	33.149	2000.0
2015-12-28 07:00:00	AMZN	Stock	33.1685	33.1685	33.049	33.063	14400.0
2015-12-28 08:00:00	AMZN	Stock	33.15	33.2895	33.05	33.2155	258880.0
2015-12-28 09:00:00	AMZN	Stock	33.2495	33.62	33.225	33.5355	13683120.0
2015-12-28 10:00:00	AMZN	Stock	33.5425	33.575	33.3645	33.383	10476920.0
2015-12-28 11:00:00	AMZN	Stock	33.3735	33.465	33.3	33.4002	5554500.0
2015-12-28 12:00:00	AMZN	Stock	33.3895	33.461	33.3504	33.4145	3580400.0
2015-12-28 13:00:00	AMZN	Stock	33.416	33.654	33.3935	33.617	7303620.0
2015-12-28 14:00:00	AMZN	Stock	33.618	33.7243	33.5905	33.6515	5655060.0
2015-12-28 15:00:00	AMZN	Stock	33.6478	33.775	33.6	33.7605	9657860.0
2015-12-28 16:00:00	AMZN	Stock	33.76	33.792	33.5344	33.75	498960.0
2015-12-28 17:00:00	AMZN	Stock	33.75	33.75	33.7055	33.7375	30380.0
2015-12-28 18:00:00	AMZN	Stock	33.75	33.75	33.75	33.75	12000.0

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

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