PREVIEW / stock_1hour / 2017-02-10

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-02-10.parquet
  size:    1.0 MB
  rows:    48,349
  symbols: 3,108

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
2017-02-10 04:00:00	AAPL	Stock	33.12	33.1875	32.9625	33.025	25792.0
2017-02-10 05:00:00	AAPL	Stock	33.015	33.0375	32.9625	33.0375	41392.0
2017-02-10 06:00:00	AAPL	Stock	33.0325	33.0475	32.9825	33.025	48496.0
2017-02-10 07:00:00	AAPL	Stock	33.0375	33.075	33.0375	33.065	34612.0
2017-02-10 08:00:00	AAPL	Stock	33.0875	33.1175	33.0	33.1	236560.0
2017-02-10 09:00:00	AAPL	Stock	33.1	33.235	33.0725	33.1875	13844868.0
2017-02-10 10:00:00	AAPL	Stock	33.19	33.195	33.045	33.0575	12841420.0
2017-02-10 11:00:00	AAPL	Stock	33.0588	33.1175	33.025	33.09	8103884.0
2017-02-10 12:00:00	AAPL	Stock	33.0925	33.1125	33.0425	33.1078	7636700.0
2017-02-10 13:00:00	AAPL	Stock	33.1075	33.14	33.0882	33.115	5540676.0
2017-02-10 14:00:00	AAPL	Stock	33.115	33.125	33.0375	33.0575	5718768.0
2017-02-10 15:00:00	AAPL	Stock	33.0575	33.08	33.015	33.03	10307308.0
2017-02-10 16:00:00	AAPL	Stock	33.0125	33.0425	33.0075	33.0125	7475492.0
2017-02-10 17:00:00	AAPL	Stock	33.02	33.02	33.005	33.015	26548.0
2017-02-10 18:00:00	AAPL	Stock	33.0075	33.015	33.0	33.015	33164.0
2017-02-10 19:00:00	AAPL	Stock	33.015	33.015	33.005	33.0125	15484.0
2017-02-10 07:00:00	MSFT	Stock	64.21	64.21	64.21	64.21	123.0
2017-02-10 08:00:00	MSFT	Stock	64.23	64.25	64.1	64.25	6487.0
2017-02-10 09:00:00	MSFT	Stock	64.23	64.3	64.05	64.08	2369325.0
2017-02-10 10:00:00	MSFT	Stock	64.08	64.3	64.06	64.22	2603102.0
2017-02-10 11:00:00	MSFT	Stock	64.226	64.24	64.11	64.14	1694998.0
2017-02-10 12:00:00	MSFT	Stock	64.135	64.235	64.09	64.215	1213976.0
2017-02-10 13:00:00	MSFT	Stock	64.22	64.23	64.11	64.11	1133966.0
2017-02-10 14:00:00	MSFT	Stock	64.11	64.12	64.03	64.035	1706278.0
2017-02-10 15:00:00	MSFT	Stock	64.04	64.145	63.975	64.0	3865370.0
2017-02-10 16:00:00	MSFT	Stock	64.0	64.031	63.95	63.99	2335356.0
2017-02-10 17:00:00	MSFT	Stock	63.96	63.97	63.96	63.96	530.0
2017-02-10 19:00:00	MSFT	Stock	64.0	64.0	64.0	64.0	552.0
2017-02-10 04:00:00	NVDA	Stock	2.9275	2.955	2.9275	2.9363	181200.0
2017-02-10 05:00:00	NVDA	Stock	2.9338	2.945	2.9338	2.945	56600.0
2017-02-10 06:00:00	NVDA	Stock	2.9448	2.945	2.9205	2.9313	865640.0
2017-02-10 07:00:00	NVDA	Stock	2.9325	2.97	2.9313	2.9658	3773680.0
2017-02-10 08:00:00	NVDA	Stock	2.9605	3.025	2.9275	2.99	30748880.0
2017-02-10 09:00:00	NVDA	Stock	2.99	3.0175	2.831	2.8401	491271040.0
2017-02-10 10:00:00	NVDA	Stock	2.8388	2.8723	2.815	2.8558	359189120.0
2017-02-10 11:00:00	NVDA	Stock	2.8562	2.8925	2.8468	2.8843	197718200.0
2017-02-10 12:00:00	NVDA	Stock	2.8845	2.9018	2.864	2.8678	141932280.0
2017-02-10 13:00:00	NVDA	Stock	2.8682	2.8805	2.846	2.8542	101593360.0
2017-02-10 14:00:00	NVDA	Stock	2.8548	2.86	2.8392	2.8518	86932640.0
2017-02-10 15:00:00	NVDA	Stock	2.8518	2.8538	2.8265	2.8408	151606520.0
2017-02-10 16:00:00	NVDA	Stock	2.8405	2.8438	2.8378	2.8438	22129600.0
2017-02-10 17:00:00	NVDA	Stock	2.8438	2.844	2.84	2.842	506160.0
2017-02-10 18:00:00	NVDA	Stock	2.8415	2.8425	2.8378	2.8425	392000.0
2017-02-10 19:00:00	NVDA	Stock	2.8415	2.843	2.8405	2.843	402000.0
2017-02-10 07:00:00	AMZN	Stock	41.1	41.1825	41.1	41.1825	10800.0
2017-02-10 08:00:00	AMZN	Stock	41.175	41.25	41.168	41.22	84820.0
2017-02-10 09:00:00	AMZN	Stock	41.1885	41.293	41.1425	41.232	7357260.0
2017-02-10 10:00:00	AMZN	Stock	41.233	41.361	41.19	41.297	7706900.0
2017-02-10 11:00:00	AMZN	Stock	41.288	41.3545	41.2555	41.331	5558680.0
2017-02-10 12:00:00	AMZN	Stock	41.332	41.369	41.309	41.3255	2714580.0

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

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