PREVIEW / stock_1hour / 2016-03-08

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-03-08.parquet
  size:    1.0 MB
  rows:    48,811
  symbols: 3,338

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-08 04:00:00	AAPL	Stock	25.395	25.395	25.195	25.2375	10436.0
2016-03-08 05:00:00	AAPL	Stock	25.195	25.195	25.1675	25.195	8652.0
2016-03-08 06:00:00	AAPL	Stock	25.165	25.175	25.075	25.1725	46860.0
2016-03-08 07:00:00	AAPL	Stock	25.175	25.3225	25.17	25.305	107704.0
2016-03-08 08:00:00	AAPL	Stock	25.305	25.3225	25.1625	25.3	374652.0
2016-03-08 09:00:00	AAPL	Stock	25.3	25.3	25.1	25.225	16618496.0
2016-03-08 10:00:00	AAPL	Stock	25.2225	25.3025	25.1675	25.21	17424916.0
2016-03-08 11:00:00	AAPL	Stock	25.215	25.375	25.1985	25.36	17050436.0
2016-03-08 12:00:00	AAPL	Stock	25.36	25.44	25.3	25.36	10713232.0
2016-03-08 13:00:00	AAPL	Stock	25.3612	25.415	25.2815	25.3775	9067520.0
2016-03-08 14:00:00	AAPL	Stock	25.375	25.3925	25.24	25.2952	12902288.0
2016-03-08 15:00:00	AAPL	Stock	25.295	25.3775	25.205	25.26	23509312.0
2016-03-08 16:00:00	AAPL	Stock	25.2575	25.2875	25.2425	25.25	8535624.0
2016-03-08 17:00:00	AAPL	Stock	25.25	25.2575	25.245	25.245	29980.0
2016-03-08 18:00:00	AAPL	Stock	25.25	25.2575	25.225	25.2475	21332.0
2016-03-08 19:00:00	AAPL	Stock	25.24	25.2625	25.2175	25.26	16868.0
2016-03-08 06:00:00	MSFT	Stock	50.98	51.15	50.98	51.15	8717.0
2016-03-08 07:00:00	MSFT	Stock	51.02	51.03	50.9	50.9	3800.0
2016-03-08 08:00:00	MSFT	Stock	50.99	51.03	50.73	50.97	178564.0
2016-03-08 09:00:00	MSFT	Stock	50.96	51.63	50.595	51.506	4349479.0
2016-03-08 10:00:00	MSFT	Stock	51.5	51.75	51.19	51.4	4056312.0
2016-03-08 11:00:00	MSFT	Stock	51.4	51.8	51.3	51.78	3462285.0
2016-03-08 12:00:00	MSFT	Stock	51.78	52.08	51.74	51.83	3820650.0
2016-03-08 13:00:00	MSFT	Stock	51.83	52.13	51.82	52.07	2566367.0
2016-03-08 14:00:00	MSFT	Stock	52.06	52.09	51.745	51.8	2358109.0
2016-03-08 15:00:00	MSFT	Stock	51.795	51.92	51.58	51.65	7667492.0
2016-03-08 16:00:00	MSFT	Stock	51.65	51.84	51.65	51.8	3127139.0
2016-03-08 17:00:00	MSFT	Stock	51.8	51.85	51.8	51.85	500.0
2016-03-08 18:00:00	MSFT	Stock	51.68	51.85	51.68	51.85	1767.0
2016-03-08 19:00:00	MSFT	Stock	51.75	51.76	51.67	51.67	2950.0
2016-03-08 08:00:00	NVDA	Stock	0.8	0.809	0.8	0.809	28000.0
2016-03-08 09:00:00	NVDA	Stock	0.8062	0.8062	0.7941	0.799	24231440.0
2016-03-08 10:00:00	NVDA	Stock	0.799	0.7998	0.7911	0.7942	36147960.0
2016-03-08 11:00:00	NVDA	Stock	0.7944	0.7992	0.7942	0.7972	24518320.0
2016-03-08 12:00:00	NVDA	Stock	0.7975	0.8023	0.7952	0.7959	24965360.0
2016-03-08 13:00:00	NVDA	Stock	0.796	0.8012	0.795	0.8007	14421880.0
2016-03-08 14:00:00	NVDA	Stock	0.8005	0.8028	0.7958	0.7971	21790200.0
2016-03-08 15:00:00	NVDA	Stock	0.797	0.7988	0.7925	0.7938	49049480.0
2016-03-08 16:00:00	NVDA	Stock	0.7938	0.794	0.7938	0.794	29344480.0
2016-03-08 17:00:00	NVDA	Stock	0.7938	0.7938	0.7938	0.7938	4000.0
2016-03-08 07:00:00	AMZN	Stock	27.95	28.05	27.95	28.05	4000.0
2016-03-08 08:00:00	AMZN	Stock	28.008	28.02	27.925	27.955	152020.0
2016-03-08 09:00:00	AMZN	Stock	27.95	28.34	27.737	28.2315	15287780.0
2016-03-08 10:00:00	AMZN	Stock	28.2335	28.3875	28.192	28.2675	14157860.0
2016-03-08 11:00:00	AMZN	Stock	28.2696	28.3435	28.0915	28.332	9044300.0
2016-03-08 12:00:00	AMZN	Stock	28.319	28.5099	28.2572	28.38	7335360.0
2016-03-08 13:00:00	AMZN	Stock	28.3872	28.5675	28.3305	28.4664	8950520.0
2016-03-08 14:00:00	AMZN	Stock	28.4575	28.4642	28.1573	28.158	11905080.0
2016-03-08 15:00:00	AMZN	Stock	28.1585	28.226	27.95	28.013	14410620.0
2016-03-08 16:00:00	AMZN	Stock	28.013	28.3706	28.0005	28.0275	326360.0

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

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