PREVIEW / stock_1hour / 2017-01-06

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-01-06.parquet
  size:    1.0 MB
  rows:    48,098
  symbols: 3,136

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-01-06 06:00:00	AAPL	Stock	29.1425	29.1425	29.1425	29.1425	992.0
2017-01-06 07:00:00	AAPL	Stock	29.1525	29.2025	29.1525	29.175	8468.0
2017-01-06 08:00:00	AAPL	Stock	29.1525	29.2175	29.0	29.1375	314376.0
2017-01-06 09:00:00	AAPL	Stock	29.1525	29.425	29.1175	29.42	26756908.0
2017-01-06 10:00:00	AAPL	Stock	29.42	29.4475	29.35	29.405	18240540.0
2017-01-06 11:00:00	AAPL	Stock	29.4062	29.4925	29.375	29.4828	11442712.0
2017-01-06 12:00:00	AAPL	Stock	29.4835	29.54	29.4525	29.476	15332396.0
2017-01-06 13:00:00	AAPL	Stock	29.475	29.4925	29.4112	29.4575	8241700.0
2017-01-06 14:00:00	AAPL	Stock	29.46	29.54	29.46	29.491	12980116.0
2017-01-06 15:00:00	AAPL	Stock	29.49	29.5225	29.4525	29.4775	16461520.0
2017-01-06 16:00:00	AAPL	Stock	29.4775	29.5245	29.3932	29.49	8177668.0
2017-01-06 17:00:00	AAPL	Stock	29.49	29.49	29.4625	29.485	17912.0
2017-01-06 18:00:00	AAPL	Stock	29.485	29.4875	29.47	29.47	21084.0
2017-01-06 19:00:00	AAPL	Stock	29.4725	29.4725	29.45	29.46	56376.0
2017-01-06 08:00:00	MSFT	Stock	62.4	62.4	62.33	62.35	506.0
2017-01-06 09:00:00	MSFT	Stock	62.38	62.54	62.04	62.52	2512222.0
2017-01-06 10:00:00	MSFT	Stock	62.52	62.69	62.41	62.62	2630004.0
2017-01-06 11:00:00	MSFT	Stock	62.63	62.97	62.59	62.97	2134431.0
2017-01-06 12:00:00	MSFT	Stock	62.96	63.13	62.93	63.1	2644774.0
2017-01-06 13:00:00	MSFT	Stock	63.09	63.15	62.99	63.02	1404651.0
2017-01-06 14:00:00	MSFT	Stock	63.024	63.12	62.93	63.015	1709641.0
2017-01-06 15:00:00	MSFT	Stock	63.01	63.03	62.81	62.84	3404498.0
2017-01-06 16:00:00	MSFT	Stock	62.84	62.96	62.81	62.83	2153174.0
2017-01-06 17:00:00	MSFT	Stock	62.85	62.85	62.83	62.83	344.0
2017-01-06 18:00:00	MSFT	Stock	62.8	62.8	62.8	62.8	3109.0
2017-01-06 19:00:00	MSFT	Stock	62.84	62.84	62.8	62.8	3236.0
2017-01-06 04:00:00	NVDA	Stock	2.5375	2.5525	2.5375	2.5525	36400.0
2017-01-06 05:00:00	NVDA	Stock	2.557	2.557	2.557	2.557	8000.0
2017-01-06 06:00:00	NVDA	Stock	2.557	2.557	2.5548	2.5548	53440.0
2017-01-06 07:00:00	NVDA	Stock	2.5548	2.555	2.5475	2.5475	71600.0
2017-01-06 08:00:00	NVDA	Stock	2.54	2.57	2.54	2.5668	2036040.0
2017-01-06 09:00:00	NVDA	Stock	2.5662	2.5725	2.53	2.5613	120667360.0
2017-01-06 10:00:00	NVDA	Stock	2.561	2.5825	2.5458	2.5758	151159760.0
2017-01-06 11:00:00	NVDA	Stock	2.575	2.5925	2.5628	2.5845	112834560.0
2017-01-06 12:00:00	NVDA	Stock	2.5843	2.606	2.5758	2.6046	78198480.0
2017-01-06 13:00:00	NVDA	Stock	2.6043	2.6062	2.5925	2.6019	63641400.0
2017-01-06 14:00:00	NVDA	Stock	2.602	2.6038	2.5778	2.5822	64336480.0
2017-01-06 15:00:00	NVDA	Stock	2.5824	2.59	2.5753	2.5782	80723680.0
2017-01-06 16:00:00	NVDA	Stock	2.5773	2.5822	2.5753	2.5775	110741960.0
2017-01-06 17:00:00	NVDA	Stock	2.5773	2.5815	2.5765	2.581	77840.0
2017-01-06 18:00:00	NVDA	Stock	2.581	2.5813	2.5773	2.5775	196160.0
2017-01-06 19:00:00	NVDA	Stock	2.5775	2.5825	2.5775	2.5825	99280.0
2017-01-06 06:00:00	AMZN	Stock	39.05	39.137	39.05	39.137	8780.0
2017-01-06 07:00:00	AMZN	Stock	39.092	39.092	39.09	39.09	17560.0
2017-01-06 08:00:00	AMZN	Stock	38.9	39.1	38.9	39.0395	310120.0
2017-01-06 09:00:00	AMZN	Stock	39.0255	39.3945	38.924	39.3872	19302600.0
2017-01-06 10:00:00	AMZN	Stock	39.3795	39.54	39.2212	39.4685	17323820.0
2017-01-06 11:00:00	AMZN	Stock	39.4784	39.6715	39.453	39.65	12917340.0
2017-01-06 12:00:00	AMZN	Stock	39.65	39.972	39.6265	39.9404	11850020.0
2017-01-06 13:00:00	AMZN	Stock	39.9384	39.9615	39.7895	39.8599	10659380.0

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

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