PREVIEW / stock_1hour / 2016-03-03

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-03-03.parquet
  size:    1.0 MB
  rows:    48,930
  symbols: 3,352

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-03 05:00:00	AAPL	Stock	25.2175	25.2175	25.2175	25.2175	1000.0
2016-03-03 06:00:00	AAPL	Stock	25.2125	25.2125	25.2125	25.2125	1200.0
2016-03-03 07:00:00	AAPL	Stock	25.19	25.2125	25.15	25.175	29320.0
2016-03-03 08:00:00	AAPL	Stock	25.19	25.2175	25.1275	25.1525	229568.0
2016-03-03 09:00:00	AAPL	Stock	25.145	25.3825	25.1125	25.3175	16930780.0
2016-03-03 10:00:00	AAPL	Stock	25.3175	25.4275	25.265	25.3125	27495612.0
2016-03-03 11:00:00	AAPL	Stock	25.314	25.3375	25.155	25.205	20881008.0
2016-03-03 12:00:00	AAPL	Stock	25.205	25.2475	25.16	25.225	12345108.0
2016-03-03 13:00:00	AAPL	Stock	25.2225	25.325	25.205	25.325	11836080.0
2016-03-03 14:00:00	AAPL	Stock	25.3225	25.3625	25.2675	25.3575	10856652.0
2016-03-03 15:00:00	AAPL	Stock	25.36	25.4175	25.32	25.375	22085300.0
2016-03-03 16:00:00	AAPL	Stock	25.375	25.425	25.1875	25.3875	8207764.0
2016-03-03 17:00:00	AAPL	Stock	25.4225	25.4725	25.4	25.41	82960.0
2016-03-03 18:00:00	AAPL	Stock	25.4175	25.425	25.4025	25.4225	67712.0
2016-03-03 19:00:00	AAPL	Stock	25.425	25.4625	25.405	25.4625	77344.0
2016-03-03 05:00:00	MSFT	Stock	52.5	52.5	52.4	52.4	300.0
2016-03-03 08:00:00	MSFT	Stock	52.85	52.94	52.85	52.87	2450.0
2016-03-03 09:00:00	MSFT	Stock	52.9	52.97	52.45	52.485	1694033.0
2016-03-03 10:00:00	MSFT	Stock	52.49	52.51	51.905	51.94	4828574.0
2016-03-03 11:00:00	MSFT	Stock	51.94	52.0	51.78	51.98	2982028.0
2016-03-03 12:00:00	MSFT	Stock	51.99	52.08	51.8	51.92	2157454.0
2016-03-03 13:00:00	MSFT	Stock	51.915	52.26	51.915	52.155	2672565.0
2016-03-03 14:00:00	MSFT	Stock	52.16	52.38	52.065	52.347	2522429.0
2016-03-03 15:00:00	MSFT	Stock	52.35	52.43	52.17	52.35	3921771.0
2016-03-03 16:00:00	MSFT	Stock	52.35	52.37	52.28	52.28	1628691.0
2016-03-03 17:00:00	MSFT	Stock	52.29	52.35	52.29	52.35	1100.0
2016-03-03 18:00:00	MSFT	Stock	52.3	52.35	52.3	52.3	3048.0
2016-03-03 19:00:00	MSFT	Stock	52.33	52.34	52.33	52.34	1108.0
2016-03-03 08:00:00	NVDA	Stock	0.8235	0.8235	0.8235	0.8235	4000.0
2016-03-03 09:00:00	NVDA	Stock	0.8218	0.826	0.815	0.8155	21271920.0
2016-03-03 10:00:00	NVDA	Stock	0.8155	0.8172	0.8078	0.8119	38783040.0
2016-03-03 11:00:00	NVDA	Stock	0.812	0.8145	0.8052	0.8116	29046480.0
2016-03-03 12:00:00	NVDA	Stock	0.8118	0.8138	0.809	0.8128	17911960.0
2016-03-03 13:00:00	NVDA	Stock	0.8126	0.814	0.81	0.8132	20826440.0
2016-03-03 14:00:00	NVDA	Stock	0.8132	0.8138	0.8108	0.8113	28675320.0
2016-03-03 15:00:00	NVDA	Stock	0.8114	0.8162	0.8106	0.8162	49572200.0
2016-03-03 16:00:00	NVDA	Stock	0.8162	0.8175	0.8132	0.8175	66799000.0
2016-03-03 17:00:00	NVDA	Stock	0.82	0.82	0.82	0.82	8840.0
2016-03-03 18:00:00	NVDA	Stock	0.8212	0.8222	0.8212	0.822	89440.0
2016-03-03 19:00:00	NVDA	Stock	0.82	0.8212	0.82	0.8212	46000.0
2016-03-03 04:00:00	AMZN	Stock	29.05	29.05	29.05	29.05	2400.0
2016-03-03 06:00:00	AMZN	Stock	29.0	29.0	29.0	29.0	5320.0
2016-03-03 08:00:00	AMZN	Stock	28.968	28.968	28.8995	28.903	26600.0
2016-03-03 09:00:00	AMZN	Stock	28.9075	28.9933	28.6665	28.8029	5579140.0
2016-03-03 10:00:00	AMZN	Stock	28.812	28.941	28.6555	28.907	8094100.0
2016-03-03 11:00:00	AMZN	Stock	28.907	28.938	28.72	28.8025	8513100.0
2016-03-03 12:00:00	AMZN	Stock	28.8048	28.834	28.712	28.815	3857440.0
2016-03-03 13:00:00	AMZN	Stock	28.8156	28.95	28.778	28.89	4325680.0
2016-03-03 14:00:00	AMZN	Stock	28.8875	28.93	28.8161	28.8775	6358040.0
2016-03-03 15:00:00	AMZN	Stock	28.8809	28.944	28.813	28.8735	8692500.0

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

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