PREVIEW / stock_1hour / 2018-01-30

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-01-30.parquet
  size:    1.1 MB
  rows:    50,790
  symbols: 2,895

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
2018-01-30 04:00:00	AAPL	Stock	42.0	42.0	41.775	41.8	5592.0
2018-01-30 05:00:00	AAPL	Stock	41.775	41.775	41.52	41.575	66512.0
2018-01-30 06:00:00	AAPL	Stock	41.595	41.66	41.5075	41.6425	108176.0
2018-01-30 07:00:00	AAPL	Stock	41.6225	41.6675	41.375	41.425	388368.0
2018-01-30 08:00:00	AAPL	Stock	41.475	41.6975	41.3775	41.445	1157576.0
2018-01-30 09:00:00	AAPL	Stock	41.4725	41.7325	41.175	41.6775	37001248.0
2018-01-30 10:00:00	AAPL	Stock	41.675	41.8325	41.465	41.7625	27915360.0
2018-01-30 11:00:00	AAPL	Stock	41.765	41.8425	41.436	41.475	19139232.0
2018-01-30 12:00:00	AAPL	Stock	41.475	41.6125	41.465	41.5	11075592.0
2018-01-30 13:00:00	AAPL	Stock	41.4975	41.5575	41.275	41.5075	24614064.0
2018-01-30 14:00:00	AAPL	Stock	41.5075	41.6638	41.4875	41.5812	13321604.0
2018-01-30 15:00:00	AAPL	Stock	41.58	41.765	41.5575	41.74	21001164.0
2018-01-30 16:00:00	AAPL	Stock	41.7425	41.805	41.7125	41.77	6988100.0
2018-01-30 17:00:00	AAPL	Stock	41.7525	41.8	41.7425	41.8	571660.0
2018-01-30 18:00:00	AAPL	Stock	41.7875	41.835	41.7575	41.805	101528.0
2018-01-30 19:00:00	AAPL	Stock	41.8125	41.82	41.7625	41.77	141900.0
2018-01-30 04:00:00	MSFT	Stock	93.2	93.2	93.0	93.2	3804.0
2018-01-30 05:00:00	MSFT	Stock	93.39	93.39	93.1	93.2	3506.0
2018-01-30 06:00:00	MSFT	Stock	93.19	93.37	93.04	93.37	4659.0
2018-01-30 07:00:00	MSFT	Stock	93.36	93.79	93.1	93.5	46713.0
2018-01-30 08:00:00	MSFT	Stock	93.21	94.12	93.13	93.5	125535.0
2018-01-30 09:00:00	MSFT	Stock	93.42	93.7	92.25	92.34	5334918.0
2018-01-30 10:00:00	MSFT	Stock	92.32	93.3	92.1	93.255	5610576.0
2018-01-30 11:00:00	MSFT	Stock	93.26	93.48	92.961	93.06	3154860.0
2018-01-30 12:00:00	MSFT	Stock	93.06	93.175	92.7	92.805	2332300.0
2018-01-30 13:00:00	MSFT	Stock	92.8	92.98	92.57	92.89	2364773.0
2018-01-30 14:00:00	MSFT	Stock	92.89	93.18	92.59	92.665	2400750.0
2018-01-30 15:00:00	MSFT	Stock	92.665	93.03	92.59	92.77	4116196.0
2018-01-30 16:00:00	MSFT	Stock	92.74	92.94	92.73	92.8	8806490.0
2018-01-30 17:00:00	MSFT	Stock	92.86	92.95	92.74	92.9	192997.0
2018-01-30 18:00:00	MSFT	Stock	92.9	92.94	92.8	92.8	12652.0
2018-01-30 19:00:00	MSFT	Stock	92.89	92.9	92.8	92.81	47340.0
2018-01-30 04:00:00	NVDA	Stock	6.1625	6.1625	6.1108	6.1148	107320.0
2018-01-30 05:00:00	NVDA	Stock	6.1123	6.1123	6.0998	6.1055	49360.0
2018-01-30 06:00:00	NVDA	Stock	6.1095	6.1115	6.09	6.1115	64720.0
2018-01-30 07:00:00	NVDA	Stock	6.102	6.1412	6.0753	6.0753	1704560.0
2018-01-30 08:00:00	NVDA	Stock	6.081	6.1288	6.039	6.04	4768760.0
2018-01-30 09:00:00	NVDA	Stock	6.0392	6.075	5.9602	5.9892	108237080.0
2018-01-30 10:00:00	NVDA	Stock	5.9908	6.1238	5.9782	6.1228	101313200.0
2018-01-30 11:00:00	NVDA	Stock	6.1235	6.1605	6.102	6.105	52160280.0
2018-01-30 12:00:00	NVDA	Stock	6.1049	6.1092	6.0645	6.0792	33096400.0
2018-01-30 13:00:00	NVDA	Stock	6.08	6.0955	6.027	6.0822	36209720.0
2018-01-30 14:00:00	NVDA	Stock	6.0825	6.0885	6.0392	6.0569	30476200.0
2018-01-30 15:00:00	NVDA	Stock	6.0569	6.1008	6.054	6.0675	51641440.0
2018-01-30 16:00:00	NVDA	Stock	6.0675	6.075	6.0362	6.068	31579000.0
2018-01-30 17:00:00	NVDA	Stock	6.0733	6.0738	6.0653	6.0678	914600.0
2018-01-30 18:00:00	NVDA	Stock	6.0678	6.0712	6.0575	6.0575	408520.0
2018-01-30 19:00:00	NVDA	Stock	6.0648	6.071	6.0565	6.0625	715400.0
2018-01-30 06:00:00	AMZN	Stock	70.575	70.695	70.575	70.65	14940.0
2018-01-30 07:00:00	AMZN	Stock	70.6815	71.55	70.6255	70.9	795380.0

> showing 50 of 50,790 rows — these rows as CSV

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