PREVIEW / stock_1hour / 2017-04-25

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-04-25.parquet
  size:    1.1 MB
  rows:    48,793
  symbols: 3,069

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
2017-04-25 04:00:00	AAPL	Stock	35.985	35.985	35.985	35.985	4000.0
2017-04-25 05:00:00	AAPL	Stock	35.975	35.975	35.9625	35.9625	6416.0
2017-04-25 07:00:00	AAPL	Stock	35.975	35.99	35.965	35.99	32972.0
2017-04-25 08:00:00	AAPL	Stock	35.99	36.05	35.98	36.015	151316.0
2017-04-25 09:00:00	AAPL	Stock	36.015	36.115	35.925	36.04	11044896.0
2017-04-25 10:00:00	AAPL	Stock	36.04	36.115	36.025	36.1	9785216.0
2017-04-25 11:00:00	AAPL	Stock	36.0975	36.175	36.09	36.1425	7865928.0
2017-04-25 12:00:00	AAPL	Stock	36.145	36.1725	36.11	36.111	4697920.0
2017-04-25 13:00:00	AAPL	Stock	36.1115	36.1875	36.1075	36.1788	5639456.0
2017-04-25 14:00:00	AAPL	Stock	36.1788	36.205	36.155	36.1592	7014444.0
2017-04-25 15:00:00	AAPL	Stock	36.16	36.225	36.1275	36.1325	13148860.0
2017-04-25 16:00:00	AAPL	Stock	36.135	36.1375	36.1125	36.1125	7850796.0
2017-04-25 17:00:00	AAPL	Stock	36.1125	36.12	36.065	36.075	120896.0
2017-04-25 18:00:00	AAPL	Stock	36.07	36.1	36.07	36.1	9280.0
2017-04-25 19:00:00	AAPL	Stock	36.1	36.125	36.1	36.12	65816.0
2017-04-25 04:00:00	MSFT	Stock	67.39	67.39	67.39	67.39	150.0
2017-04-25 07:00:00	MSFT	Stock	67.7	67.73	67.6	67.73	1478.0
2017-04-25 08:00:00	MSFT	Stock	67.7	67.95	67.6	67.8	20038.0
2017-04-25 09:00:00	MSFT	Stock	67.85	67.98	67.6	67.81	3056678.0
2017-04-25 10:00:00	MSFT	Stock	67.8	68.0	67.73	67.9	2792399.0
2017-04-25 11:00:00	MSFT	Stock	67.9	68.0	67.84	67.93	3376610.0
2017-04-25 12:00:00	MSFT	Stock	67.93	67.98	67.83	67.83	1959872.0
2017-04-25 13:00:00	MSFT	Stock	67.835	67.93	67.76	67.825	2398547.0
2017-04-25 14:00:00	MSFT	Stock	67.82	67.865	67.79	67.835	2338141.0
2017-04-25 15:00:00	MSFT	Stock	67.834	68.04	67.834	67.92	5962187.0
2017-04-25 16:00:00	MSFT	Stock	67.95	68.05	67.887	68.0	6724976.0
2017-04-25 17:00:00	MSFT	Stock	67.94	68.0	67.92	67.94	4865.0
2017-04-25 18:00:00	MSFT	Stock	67.94	68.06	67.92	68.0	8355.0
2017-04-25 19:00:00	MSFT	Stock	67.92	68.0	67.92	68.0	1800.0
2017-04-25 07:00:00	NVDA	Stock	2.5762	2.5762	2.5653	2.5653	139720.0
2017-04-25 08:00:00	NVDA	Stock	2.5712	2.582	2.5712	2.582	673760.0
2017-04-25 09:00:00	NVDA	Stock	2.5815	2.5958	2.5668	2.5703	42775640.0
2017-04-25 10:00:00	NVDA	Stock	2.5702	2.6037	2.5683	2.5952	81644880.0
2017-04-25 11:00:00	NVDA	Stock	2.5952	2.6168	2.5928	2.6161	45899840.0
2017-04-25 12:00:00	NVDA	Stock	2.6158	2.622	2.6143	2.6185	30846320.0
2017-04-25 13:00:00	NVDA	Stock	2.6188	2.6268	2.6178	2.6263	31970960.0
2017-04-25 14:00:00	NVDA	Stock	2.6264	2.6333	2.616	2.6195	40676720.0
2017-04-25 15:00:00	NVDA	Stock	2.6198	2.6268	2.6134	2.6183	51205120.0
2017-04-25 16:00:00	NVDA	Stock	2.6185	2.6208	2.6133	2.6135	34724680.0
2017-04-25 17:00:00	NVDA	Stock	2.6135	2.6175	2.6135	2.6175	42560.0
2017-04-25 18:00:00	NVDA	Stock	2.616	2.6185	2.6158	2.6185	121840.0
2017-04-25 19:00:00	NVDA	Stock	2.6225	2.6225	2.6183	2.6183	84920.0
2017-04-25 04:00:00	AMZN	Stock	45.2205	45.285	45.15	45.1575	67200.0
2017-04-25 05:00:00	AMZN	Stock	45.1755	45.1755	45.1325	45.14	34060.0
2017-04-25 06:00:00	AMZN	Stock	45.153	45.2395	45.15	45.2	60560.0
2017-04-25 07:00:00	AMZN	Stock	45.197	45.2	45.17	45.1875	62140.0
2017-04-25 08:00:00	AMZN	Stock	45.2	45.3	45.184	45.25	441720.0
2017-04-25 09:00:00	AMZN	Stock	45.275	45.3915	45.15	45.2275	12347100.0
2017-04-25 10:00:00	AMZN	Stock	45.223	45.474	45.1765	45.3855	10401160.0
2017-04-25 11:00:00	AMZN	Stock	45.3805	45.405	45.309	45.3915	5202360.0

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

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