PREVIEW / stock_1hour / 2015-06-29

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-06-29.parquet
  size:    1.1 MB
  rows:    50,430
  symbols: 3,516

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
2015-06-29 04:00:00	AAPL	Stock	31.125	31.3425	31.125	31.3	189708.0
2015-06-29 05:00:00	AAPL	Stock	31.34	31.345	31.2875	31.295	57156.0
2015-06-29 06:00:00	AAPL	Stock	31.2625	31.325	31.2125	31.315	177784.0
2015-06-29 07:00:00	AAPL	Stock	31.33	31.4125	31.3	31.4125	440536.0
2015-06-29 08:00:00	AAPL	Stock	31.405	31.485	31.23	31.2875	1274068.0
2015-06-29 09:00:00	AAPL	Stock	31.285	31.6175	31.2825	31.5375	33838080.0
2015-06-29 10:00:00	AAPL	Stock	31.5375	31.61	31.4225	31.4335	26765252.0
2015-06-29 11:00:00	AAPL	Stock	31.435	31.4725	31.3575	31.4252	16743700.0
2015-06-29 12:00:00	AAPL	Stock	31.425	31.4475	31.3475	31.375	11091128.0
2015-06-29 13:00:00	AAPL	Stock	31.3725	31.4	31.31	31.3445	13171556.0
2015-06-29 14:00:00	AAPL	Stock	31.345	31.3525	31.225	31.2288	22651292.0
2015-06-29 15:00:00	AAPL	Stock	31.2285	31.2725	31.12	31.145	39449408.0
2015-06-29 16:00:00	AAPL	Stock	31.1325	31.3408	31.13	31.18	7086104.0
2015-06-29 17:00:00	AAPL	Stock	31.1775	31.1875	31.16	31.17	157048.0
2015-06-29 18:00:00	AAPL	Stock	31.17	31.1875	31.1325	31.15	195696.0
2015-06-29 19:00:00	AAPL	Stock	31.16	31.2	31.125	31.2	156752.0
2015-06-29 04:00:00	MSFT	Stock	45.05	45.05	44.9	44.9	2400.0
2015-06-29 05:00:00	MSFT	Stock	44.89	44.89	44.8	44.88	6294.0
2015-06-29 06:00:00	MSFT	Stock	44.81	44.84	44.7	44.79	9400.0
2015-06-29 07:00:00	MSFT	Stock	44.78	44.85	44.73	44.81	5200.0
2015-06-29 08:00:00	MSFT	Stock	44.85	44.99	44.75	44.79	22323.0
2015-06-29 09:00:00	MSFT	Stock	44.8	45.23	44.8	44.975	4309674.0
2015-06-29 10:00:00	MSFT	Stock	44.975	45.15	44.9	44.97	4326062.0
2015-06-29 11:00:00	MSFT	Stock	44.98	44.99	44.78	44.815	3647941.0
2015-06-29 12:00:00	MSFT	Stock	44.815	44.88	44.75	44.86	2273082.0
2015-06-29 13:00:00	MSFT	Stock	44.85	44.855	44.66	44.72	3227618.0
2015-06-29 14:00:00	MSFT	Stock	44.715	44.74	44.48	44.52	4281016.0
2015-06-29 15:00:00	MSFT	Stock	44.52	44.592	44.36	44.39	8154396.0
2015-06-29 16:00:00	MSFT	Stock	44.38	44.49	44.37	44.47	2518705.0
2015-06-29 17:00:00	MSFT	Stock	44.47	44.47	44.45	44.45	2375.0
2015-06-29 18:00:00	MSFT	Stock	44.4	44.46	44.4	44.4	17358.0
2015-06-29 19:00:00	MSFT	Stock	44.4	44.4	44.39	44.397	10775.0
2015-06-29 08:00:00	NVDA	Stock	0.515	0.515	0.514	0.514	38000.0
2015-06-29 09:00:00	NVDA	Stock	0.5115	0.5178	0.5098	0.5155	34050640.0
2015-06-29 10:00:00	NVDA	Stock	0.5154	0.5175	0.5108	0.511	46062400.0
2015-06-29 11:00:00	NVDA	Stock	0.5108	0.511	0.5038	0.5056	52584680.0
2015-06-29 12:00:00	NVDA	Stock	0.5058	0.5115	0.5053	0.5115	53692080.0
2015-06-29 13:00:00	NVDA	Stock	0.5112	0.5115	0.5078	0.5084	29494000.0
2015-06-29 14:00:00	NVDA	Stock	0.5084	0.5085	0.5048	0.5048	41578480.0
2015-06-29 15:00:00	NVDA	Stock	0.5048	0.5052	0.5022	0.503	107144240.0
2015-06-29 16:00:00	NVDA	Stock	0.503	0.5045	0.503	0.5043	6639760.0
2015-06-29 04:00:00	AMZN	Stock	21.7	21.7	21.7	21.7	2000.0
2015-06-29 06:00:00	AMZN	Stock	21.665	21.665	21.601	21.601	36000.0
2015-06-29 07:00:00	AMZN	Stock	21.665	21.6965	21.6335	21.6965	24780.0
2015-06-29 08:00:00	AMZN	Stock	21.698	21.698	21.65	21.673	61680.0
2015-06-29 09:00:00	AMZN	Stock	21.6502	21.85	21.6	21.774	7443500.0
2015-06-29 10:00:00	AMZN	Stock	21.7875	21.832	21.71	21.7335	5453900.0
2015-06-29 11:00:00	AMZN	Stock	21.7275	21.8125	21.7075	21.7905	4562320.0
2015-06-29 12:00:00	AMZN	Stock	21.784	21.8335	21.74	21.7645	3990060.0
2015-06-29 13:00:00	AMZN	Stock	21.75	21.7572	21.6285	21.64	5673400.0

> showing 50 of 50,430 rows — these rows as CSV

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