PREVIEW / stock_1hour / 2015-03-17

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-03-17.parquet
  size:    1.0 MB
  rows:    48,499
  symbols: 3,504

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-03-17 04:00:00	AAPL	Stock	31.3125	31.3125	31.17	31.17	17196.0
2015-03-17 05:00:00	AAPL	Stock	31.15	31.16	31.1175	31.1275	7600.0
2015-03-17 06:00:00	AAPL	Stock	31.1275	31.23	31.0075	31.15	94584.0
2015-03-17 07:00:00	AAPL	Stock	31.1675	31.205	31.1375	31.1825	163164.0
2015-03-17 08:00:00	AAPL	Stock	31.1825	31.375	31.1375	31.3675	1172916.0
2015-03-17 09:00:00	AAPL	Stock	31.375	31.645	31.36	31.6085	36323028.0
2015-03-17 10:00:00	AAPL	Stock	31.607	31.7975	31.56	31.754	40194956.0
2015-03-17 11:00:00	AAPL	Stock	31.755	31.7575	31.545	31.705	27058680.0
2015-03-17 12:00:00	AAPL	Stock	31.7	31.7625	31.6285	31.7548	16438284.0
2015-03-17 13:00:00	AAPL	Stock	31.7502	31.825	31.715	31.8175	18576552.0
2015-03-17 14:00:00	AAPL	Stock	31.8175	31.83	31.73	31.775	15205416.0
2015-03-17 15:00:00	AAPL	Stock	31.775	31.825	31.76	31.7625	24879672.0
2015-03-17 16:00:00	AAPL	Stock	31.76	31.7875	31.6875	31.775	10935832.0
2015-03-17 17:00:00	AAPL	Stock	31.76	31.79	31.76	31.775	415960.0
2015-03-17 18:00:00	AAPL	Stock	31.775	31.785	31.7675	31.7675	123724.0
2015-03-17 19:00:00	AAPL	Stock	31.7675	31.8025	31.765	31.7925	102344.0
2015-03-17 05:00:00	MSFT	Stock	41.4	41.4	41.4	41.4	100.0
2015-03-17 07:00:00	MSFT	Stock	41.27	41.27	41.08	41.24	1670.0
2015-03-17 08:00:00	MSFT	Stock	41.25	41.34	41.18	41.29	3400.0
2015-03-17 09:00:00	MSFT	Stock	41.38	41.48	41.3	41.385	3896345.0
2015-03-17 10:00:00	MSFT	Stock	41.38	41.39	41.15	41.25	3966337.0
2015-03-17 11:00:00	MSFT	Stock	41.25	41.37	41.19	41.37	3929991.0
2015-03-17 12:00:00	MSFT	Stock	41.365	41.625	41.33	41.61	3141236.0
2015-03-17 13:00:00	MSFT	Stock	41.62	41.69	41.52	41.66	3429493.0
2015-03-17 14:00:00	MSFT	Stock	41.65	41.72	41.55	41.609	2939968.0
2015-03-17 15:00:00	MSFT	Stock	41.605	41.83	41.6	41.7	5794674.0
2015-03-17 16:00:00	MSFT	Stock	41.695	41.76	41.407	41.63	3255000.0
2015-03-17 17:00:00	MSFT	Stock	41.695	41.695	41.63	41.69	11719.0
2015-03-17 18:00:00	MSFT	Stock	41.66	41.66	41.64	41.65	989.0
2015-03-17 19:00:00	MSFT	Stock	41.65	41.67	41.65	41.67	1800.0
2015-03-17 09:00:00	NVDA	Stock	0.573	0.573	0.569	0.57	24415520.0
2015-03-17 10:00:00	NVDA	Stock	0.5702	0.5715	0.569	0.5715	21595280.0
2015-03-17 11:00:00	NVDA	Stock	0.5715	0.575	0.5702	0.5719	52453640.0
2015-03-17 12:00:00	NVDA	Stock	0.5722	0.5746	0.571	0.5745	19612920.0
2015-03-17 13:00:00	NVDA	Stock	0.5742	0.5782	0.5738	0.5778	29279080.0
2015-03-17 14:00:00	NVDA	Stock	0.5779	0.581	0.5775	0.5805	44895600.0
2015-03-17 15:00:00	NVDA	Stock	0.5805	0.5815	0.5785	0.5812	77787360.0
2015-03-17 16:00:00	NVDA	Stock	0.5812	0.5818	0.5761	0.5818	15923840.0
2015-03-17 17:00:00	NVDA	Stock	0.5812	0.5812	0.5812	0.5812	22480.0
2015-03-17 04:00:00	AMZN	Stock	18.627	18.627	18.627	18.627	7800.0
2015-03-17 07:00:00	AMZN	Stock	18.559	18.559	18.526	18.5355	8340.0
2015-03-17 08:00:00	AMZN	Stock	18.57	18.615	18.5515	18.615	15000.0
2015-03-17 09:00:00	AMZN	Stock	18.556	18.6345	18.482	18.6345	7392340.0
2015-03-17 10:00:00	AMZN	Stock	18.6195	18.6375	18.537	18.571	6036880.0
2015-03-17 11:00:00	AMZN	Stock	18.57	18.599	18.504	18.599	5017560.0
2015-03-17 12:00:00	AMZN	Stock	18.596	18.696	18.5755	18.6727	3941460.0
2015-03-17 13:00:00	AMZN	Stock	18.675	18.709	18.6442	18.7045	2489200.0
2015-03-17 14:00:00	AMZN	Stock	18.7025	18.725	18.65	18.675	2826640.0
2015-03-17 15:00:00	AMZN	Stock	18.6762	18.7045	18.59	18.5965	5759280.0
2015-03-17 16:00:00	AMZN	Stock	18.596	18.615	18.596	18.596	397120.0

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

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