PREVIEW / stock_1hour / 2016-03-30

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-03-30.parquet
  size:    1.0 MB
  rows:    48,452
  symbols: 3,349

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-03-30 04:00:00	AAPL	Stock	26.9775	27.0625	26.9775	27.0575	5328.0
2016-03-30 05:00:00	AAPL	Stock	27.0625	27.0625	27.0625	27.0625	680.0
2016-03-30 06:00:00	AAPL	Stock	27.0625	27.2225	27.03	27.2	197584.0
2016-03-30 07:00:00	AAPL	Stock	27.1975	27.3575	27.1625	27.25	514696.0
2016-03-30 08:00:00	AAPL	Stock	27.2275	27.2875	26.875	27.265	930752.0
2016-03-30 09:00:00	AAPL	Stock	27.2675	27.545	27.15	27.4932	41492172.0
2016-03-30 10:00:00	AAPL	Stock	27.4975	27.605	27.42	27.4525	30457408.0
2016-03-30 11:00:00	AAPL	Stock	27.4525	27.5175	27.2025	27.2998	24475740.0
2016-03-30 12:00:00	AAPL	Stock	27.2978	27.36	27.2188	27.2515	12143596.0
2016-03-30 13:00:00	AAPL	Stock	27.2525	27.375	27.1875	27.3525	13194052.0
2016-03-30 14:00:00	AAPL	Stock	27.3505	27.4325	27.2812	27.4275	12801384.0
2016-03-30 15:00:00	AAPL	Stock	27.425	27.4775	27.385	27.3975	21809152.0
2016-03-30 16:00:00	AAPL	Stock	27.39	27.5145	27.355	27.375	6010776.0
2016-03-30 17:00:00	AAPL	Stock	27.375	27.4	27.3675	27.4	97608.0
2016-03-30 18:00:00	AAPL	Stock	27.4	27.4075	27.3925	27.395	55624.0
2016-03-30 19:00:00	AAPL	Stock	27.395	27.4375	27.3825	27.39	66036.0
2016-03-30 04:00:00	MSFT	Stock	54.87	54.88	54.87	54.88	600.0
2016-03-30 06:00:00	MSFT	Stock	55.26	55.26	55.26	55.26	100.0
2016-03-30 07:00:00	MSFT	Stock	55.03	55.03	55.03	55.03	909.0
2016-03-30 08:00:00	MSFT	Stock	55.02	55.05	54.96	55.05	25329.0
2016-03-30 09:00:00	MSFT	Stock	55.02	55.5	54.86	55.495	3598310.0
2016-03-30 10:00:00	MSFT	Stock	55.49	55.64	55.32	55.525	3819254.0
2016-03-30 11:00:00	MSFT	Stock	55.53	55.59	55.03	55.06	2927470.0
2016-03-30 12:00:00	MSFT	Stock	55.06	55.13	54.94	55.125	1474482.0
2016-03-30 13:00:00	MSFT	Stock	55.12	55.3	55.11	55.19	1676411.0
2016-03-30 14:00:00	MSFT	Stock	55.18	55.25	55.09	55.245	1727930.0
2016-03-30 15:00:00	MSFT	Stock	55.24	55.32	55.01	55.05	4217030.0
2016-03-30 16:00:00	MSFT	Stock	55.05	55.316	55.0	55.05	2051858.0
2016-03-30 17:00:00	MSFT	Stock	55.03	55.05	55.03	55.05	1988.0
2016-03-30 18:00:00	MSFT	Stock	55.06	55.06	55.0	55.0	1300.0
2016-03-30 19:00:00	MSFT	Stock	55.06	55.06	55.06	55.06	100.0
2016-03-30 08:00:00	NVDA	Stock	0.888	0.888	0.888	0.888	7120.0
2016-03-30 09:00:00	NVDA	Stock	0.8902	0.9058	0.8875	0.8964	48231040.0
2016-03-30 10:00:00	NVDA	Stock	0.8963	0.9058	0.893	0.9039	58252200.0
2016-03-30 11:00:00	NVDA	Stock	0.9038	0.9062	0.8915	0.8965	47089800.0
2016-03-30 12:00:00	NVDA	Stock	0.8968	0.9002	0.892	0.8976	33130960.0
2016-03-30 13:00:00	NVDA	Stock	0.8978	0.9012	0.894	0.8958	47220480.0
2016-03-30 14:00:00	NVDA	Stock	0.8955	0.8966	0.8918	0.8945	50367240.0
2016-03-30 15:00:00	NVDA	Stock	0.8945	0.8968	0.8925	0.894	69120680.0
2016-03-30 16:00:00	NVDA	Stock	0.894	0.895	0.894	0.895	9054600.0
2016-03-30 17:00:00	NVDA	Stock	0.8985	0.8985	0.8985	0.8985	6000.0
2016-03-30 06:00:00	AMZN	Stock	29.9	29.9	29.9	29.9	2000.0
2016-03-30 07:00:00	AMZN	Stock	29.875	29.875	29.826	29.8485	57140.0
2016-03-30 08:00:00	AMZN	Stock	29.825	29.85	29.775	29.85	417180.0
2016-03-30 09:00:00	AMZN	Stock	29.85	30.112	29.75	30.095	16422220.0
2016-03-30 10:00:00	AMZN	Stock	30.0985	30.162	29.965	30.0375	13144700.0
2016-03-30 11:00:00	AMZN	Stock	30.0385	30.0475	29.8055	29.9072	9426380.0
2016-03-30 12:00:00	AMZN	Stock	29.911	29.932	29.8005	29.9015	5475040.0
2016-03-30 13:00:00	AMZN	Stock	29.9134	30.035	29.894	29.9795	5949580.0
2016-03-30 14:00:00	AMZN	Stock	29.9738	30.0425	29.884	29.968	6229900.0

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

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