PREVIEW / stock_1hour / 2016-10-25

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-10-25.parquet
  size:    1.0 MB
  rows:    47,493
  symbols: 3,206

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-10-25 04:00:00	AAPL	Stock	29.49	29.55	29.4625	29.525	59028.0
2016-10-25 05:00:00	AAPL	Stock	29.5375	29.5375	29.5	29.5	8584.0
2016-10-25 06:00:00	AAPL	Stock	29.5	29.575	29.5	29.5525	120252.0
2016-10-25 07:00:00	AAPL	Stock	29.5525	29.56	29.5	29.5	150412.0
2016-10-25 08:00:00	AAPL	Stock	29.5	31.58	29.4775	29.5175	586572.0
2016-10-25 09:00:00	AAPL	Stock	29.52	29.5325	29.425	29.444	20255652.0
2016-10-25 10:00:00	AAPL	Stock	29.445	29.46	29.3605	29.3808	22838820.0
2016-10-25 11:00:00	AAPL	Stock	29.3825	29.4325	29.3525	29.36	15649140.0
2016-10-25 12:00:00	AAPL	Stock	29.3608	29.425	29.3275	29.4125	14595296.0
2016-10-25 13:00:00	AAPL	Stock	29.4125	29.5	29.3875	29.4908	15437724.0
2016-10-25 14:00:00	AAPL	Stock	29.4912	29.5075	29.4375	29.4525	15806744.0
2016-10-25 15:00:00	AAPL	Stock	29.4525	29.59	29.435	29.565	32893020.0
2016-10-25 16:00:00	AAPL	Stock	29.5625	30.46	28.79	28.9725	28286512.0
2016-10-25 17:00:00	AAPL	Stock	28.975	29.5625	28.6425	28.8125	10228704.0
2016-10-25 18:00:00	AAPL	Stock	28.8025	28.8375	28.7	28.735	1460080.0
2016-10-25 19:00:00	AAPL	Stock	28.7375	28.795	28.7275	28.7375	525156.0
2016-10-25 04:00:00	MSFT	Stock	61.23	61.23	61.12	61.12	1798.0
2016-10-25 05:00:00	MSFT	Stock	61.12	61.17	61.01	61.01	2000.0
2016-10-25 06:00:00	MSFT	Stock	61.1	61.1	61.0	61.0	2230.0
2016-10-25 07:00:00	MSFT	Stock	60.98	61.07	60.95	61.0	10227.0
2016-10-25 08:00:00	MSFT	Stock	61.0	62.0	60.85	61.05	40563.0
2016-10-25 09:00:00	MSFT	Stock	61.08	61.37	60.83	61.3	6435020.0
2016-10-25 10:00:00	MSFT	Stock	61.295	61.36	60.85	60.953	6631674.0
2016-10-25 11:00:00	MSFT	Stock	60.955	61.045	60.88	60.9	3714428.0
2016-10-25 12:00:00	MSFT	Stock	60.9	61.02	60.8	61.015	2603511.0
2016-10-25 13:00:00	MSFT	Stock	61.015	61.05	60.98	61.03	2327929.0
2016-10-25 14:00:00	MSFT	Stock	61.02	61.037	60.88	60.89	2560207.0
2016-10-25 15:00:00	MSFT	Stock	60.89	61.06	60.83	61.01	5699752.0
2016-10-25 16:00:00	MSFT	Stock	60.99	61.02	60.81	60.99	2071809.0
2016-10-25 17:00:00	MSFT	Stock	60.84	60.9	60.77	60.8	6649.0
2016-10-25 18:00:00	MSFT	Stock	60.78	60.89	60.78	60.89	1650.0
2016-10-25 19:00:00	MSFT	Stock	60.8	60.82	60.8	60.82	1400.0
2016-10-25 08:00:00	NVDA	Stock	1.773	1.773	1.7638	1.7702	838160.0
2016-10-25 09:00:00	NVDA	Stock	1.772	1.7832	1.7562	1.7814	56851720.0
2016-10-25 10:00:00	NVDA	Stock	1.7815	1.7915	1.7781	1.7818	67931960.0
2016-10-25 11:00:00	NVDA	Stock	1.782	1.799	1.7804	1.7988	43809200.0
2016-10-25 12:00:00	NVDA	Stock	1.7981	1.8075	1.7933	1.8042	48555800.0
2016-10-25 13:00:00	NVDA	Stock	1.804	1.8041	1.789	1.7935	34449160.0
2016-10-25 14:00:00	NVDA	Stock	1.7935	1.7978	1.7924	1.7955	34274040.0
2016-10-25 15:00:00	NVDA	Stock	1.7954	1.798	1.791	1.7968	70440320.0
2016-10-25 16:00:00	NVDA	Stock	1.7968	1.7975	1.784	1.792	5042440.0
2016-10-25 17:00:00	NVDA	Stock	1.792	1.7925	1.785	1.785	380000.0
2016-10-25 18:00:00	NVDA	Stock	1.785	1.7872	1.7828	1.783	233440.0
2016-10-25 19:00:00	NVDA	Stock	1.7862	1.7898	1.7852	1.7898	65440.0
2016-10-25 04:00:00	AMZN	Stock	42.08	42.08	42.06	42.06	6000.0
2016-10-25 06:00:00	AMZN	Stock	41.999	42.054	41.986	42.0165	38420.0
2016-10-25 07:00:00	AMZN	Stock	42.0	42.0005	41.933	41.933	79540.0
2016-10-25 08:00:00	AMZN	Stock	41.9555	42.05	41.9375	41.9375	174280.0
2016-10-25 09:00:00	AMZN	Stock	41.9435	41.9655	41.685	41.842	9998540.0
2016-10-25 10:00:00	AMZN	Stock	41.8365	42.049	41.7605	42.0205	9789680.0

> showing 50 of 47,493 rows — these rows as CSV

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