PREVIEW / stock_1hour / 2016-02-22

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-02-22.parquet
  size:    1.0 MB
  rows:    48,794
  symbols: 3,365

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-02-22 04:00:00	AAPL	Stock	24.095	24.3125	24.095	24.3125	26968.0
2016-02-22 05:00:00	AAPL	Stock	24.2525	24.265	24.1925	24.265	3256.0
2016-02-22 06:00:00	AAPL	Stock	24.2725	24.275	24.2025	24.2025	9308.0
2016-02-22 07:00:00	AAPL	Stock	24.2025	24.2025	24.1325	24.15	109520.0
2016-02-22 08:00:00	AAPL	Stock	24.1425	24.19	24.0625	24.1075	555212.0
2016-02-22 09:00:00	AAPL	Stock	24.1125	24.1825	23.98	24.1375	20871992.0
2016-02-22 10:00:00	AAPL	Stock	24.1375	24.1875	24.0325	24.0688	20130040.0
2016-02-22 11:00:00	AAPL	Stock	24.0688	24.0975	23.985	24.0575	15989868.0
2016-02-22 12:00:00	AAPL	Stock	24.0565	24.075	24.0012	24.008	11582588.0
2016-02-22 13:00:00	AAPL	Stock	24.0075	24.125	24.0	24.1175	12210648.0
2016-02-22 14:00:00	AAPL	Stock	24.12	24.18	24.065	24.1525	17877180.0
2016-02-22 15:00:00	AAPL	Stock	24.1545	24.225	24.1	24.2175	21348272.0
2016-02-22 16:00:00	AAPL	Stock	24.2175	24.22	24.0948	24.175	5672408.0
2016-02-22 17:00:00	AAPL	Stock	24.1875	24.2	24.145	24.165	128532.0
2016-02-22 18:00:00	AAPL	Stock	24.1625	24.1825	24.155	24.155	19120.0
2016-02-22 19:00:00	AAPL	Stock	24.155	24.1625	24.1525	24.1625	21276.0
2016-02-22 04:00:00	MSFT	Stock	52.0	52.0	52.0	52.0	100.0
2016-02-22 06:00:00	MSFT	Stock	52.3	52.3	52.3	52.3	400.0
2016-02-22 07:00:00	MSFT	Stock	52.45	52.45	52.4	52.4	1789.0
2016-02-22 08:00:00	MSFT	Stock	52.38	52.4	52.3	52.35	31238.0
2016-02-22 09:00:00	MSFT	Stock	52.33	52.83	52.28	52.83	3213650.0
2016-02-22 10:00:00	MSFT	Stock	52.83	52.97	52.73	52.785	3383384.0
2016-02-22 11:00:00	MSFT	Stock	52.78	53.0	52.74	52.86	2994797.0
2016-02-22 12:00:00	MSFT	Stock	52.86	52.875	52.7	52.72	1979077.0
2016-02-22 13:00:00	MSFT	Stock	52.725	52.91	52.68	52.85	1444095.0
2016-02-22 14:00:00	MSFT	Stock	52.845	52.85	52.5	52.535	2054759.0
2016-02-22 15:00:00	MSFT	Stock	52.535	52.65	52.37	52.64	5104390.0
2016-02-22 16:00:00	MSFT	Stock	52.64	52.66	52.36	52.36	2996047.0
2016-02-22 17:00:00	MSFT	Stock	52.45	52.45	52.4	52.4	293.0
2016-02-22 18:00:00	MSFT	Stock	52.45	52.45	52.45	52.45	350.0
2016-02-22 19:00:00	MSFT	Stock	52.45	52.45	52.45	52.45	417.0
2016-02-22 09:00:00	NVDA	Stock	0.77	0.796	0.77	0.7948	75790520.0
2016-02-22 10:00:00	NVDA	Stock	0.7948	0.7968	0.79	0.792	83862200.0
2016-02-22 11:00:00	NVDA	Stock	0.792	0.7938	0.7868	0.7912	57001320.0
2016-02-22 12:00:00	NVDA	Stock	0.7912	0.7924	0.7872	0.7889	45634520.0
2016-02-22 13:00:00	NVDA	Stock	0.7888	0.7905	0.787	0.7887	30111280.0
2016-02-22 14:00:00	NVDA	Stock	0.7885	0.7888	0.7825	0.7865	43115160.0
2016-02-22 15:00:00	NVDA	Stock	0.7864	0.788	0.7825	0.788	90022000.0
2016-02-22 16:00:00	NVDA	Stock	0.788	0.788	0.7858	0.787	17927680.0
2016-02-22 17:00:00	NVDA	Stock	0.785	0.785	0.785	0.785	10800.0
2016-02-22 07:00:00	AMZN	Stock	27.15	27.175	27.0515	27.0515	102540.0
2016-02-22 08:00:00	AMZN	Stock	27.0925	27.175	26.99	27.045	355580.0
2016-02-22 09:00:00	AMZN	Stock	27.036	27.555	27.0	27.473	20203260.0
2016-02-22 10:00:00	AMZN	Stock	27.4515	27.825	27.3805	27.761	20795460.0
2016-02-22 11:00:00	AMZN	Stock	27.754	28.0245	27.7385	27.9645	14249000.0
2016-02-22 12:00:00	AMZN	Stock	27.9445	27.964	27.825	27.8435	8341100.0
2016-02-22 13:00:00	AMZN	Stock	27.842	28.0325	27.803	27.9442	9208020.0
2016-02-22 14:00:00	AMZN	Stock	27.9345	28.009	27.882	27.962	8987040.0
2016-02-22 15:00:00	AMZN	Stock	27.9535	28.0	27.788	27.9745	21769020.0
2016-02-22 16:00:00	AMZN	Stock	27.9565	27.975	27.8995	27.925	624780.0

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

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