PREVIEW / stock_1hour / 2015-06-05

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-06-05.parquet
  size:    1.0 MB
  rows:    48,297
  symbols: 3,469

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-05 04:00:00	AAPL	Stock	32.4075	32.45	32.375	32.3825	5328.0
2015-06-05 05:00:00	AAPL	Stock	32.3925	32.3925	32.3925	32.3925	3564.0
2015-06-05 06:00:00	AAPL	Stock	32.3675	32.3675	32.2825	32.29	15668.0
2015-06-05 07:00:00	AAPL	Stock	32.295	32.3675	32.2925	32.365	86868.0
2015-06-05 08:00:00	AAPL	Stock	32.365	32.4775	32.295	32.3925	1166592.0
2015-06-05 09:00:00	AAPL	Stock	32.3825	32.4225	32.09	32.24	26434504.0
2015-06-05 10:00:00	AAPL	Stock	32.2412	32.37	32.2017	32.23	24729172.0
2015-06-05 11:00:00	AAPL	Stock	32.23	32.29	32.1525	32.1825	14168220.0
2015-06-05 12:00:00	AAPL	Stock	32.18	32.225	32.0975	32.21	14886080.0
2015-06-05 13:00:00	AAPL	Stock	32.2075	32.2375	32.1425	32.185	10722364.0
2015-06-05 14:00:00	AAPL	Stock	32.1875	32.23	32.165	32.2125	12504676.0
2015-06-05 15:00:00	AAPL	Stock	32.2125	32.225	32.15	32.1625	21592804.0
2015-06-05 16:00:00	AAPL	Stock	32.1625	32.23	32.1625	32.1725	7641232.0
2015-06-05 17:00:00	AAPL	Stock	32.175	32.175	32.15	32.15	321512.0
2015-06-05 18:00:00	AAPL	Stock	32.1675	32.17	32.125	32.1675	42372.0
2015-06-05 19:00:00	AAPL	Stock	32.17	32.1748	32.15	32.17	51568.0
2015-06-05 07:00:00	MSFT	Stock	46.48	46.48	46.48	46.48	375.0
2015-06-05 08:00:00	MSFT	Stock	46.55	46.55	46.25	46.29	38905.0
2015-06-05 09:00:00	MSFT	Stock	46.28	46.38	45.84	46.1	4067234.0
2015-06-05 10:00:00	MSFT	Stock	46.1	46.52	46.09	46.225	4312589.0
2015-06-05 11:00:00	MSFT	Stock	46.23	46.43	46.17	46.228	2293894.0
2015-06-05 12:00:00	MSFT	Stock	46.225	46.345	46.16	46.305	2172723.0
2015-06-05 13:00:00	MSFT	Stock	46.305	46.34	46.19	46.19	1832409.0
2015-06-05 14:00:00	MSFT	Stock	46.2	46.36	46.18	46.295	2617822.0
2015-06-05 15:00:00	MSFT	Stock	46.3	46.34	46.14	46.15	5055912.0
2015-06-05 16:00:00	MSFT	Stock	46.14	46.246	46.14	46.19	1977752.0
2015-06-05 17:00:00	MSFT	Stock	46.15	46.19	46.15	46.18	3297.0
2015-06-05 18:00:00	MSFT	Stock	46.21	46.21	46.15	46.15	1206.0
2015-06-05 19:00:00	MSFT	Stock	46.19	46.2	46.19	46.19	1800.0
2015-06-05 08:00:00	NVDA	Stock	0.55	0.55	0.55	0.55	12000.0
2015-06-05 09:00:00	NVDA	Stock	0.5505	0.553	0.5448	0.5522	60256480.0
2015-06-05 10:00:00	NVDA	Stock	0.5522	0.5539	0.552	0.5535	36928640.0
2015-06-05 11:00:00	NVDA	Stock	0.5538	0.559	0.5535	0.558	49730560.0
2015-06-05 12:00:00	NVDA	Stock	0.558	0.5588	0.5572	0.5579	22233520.0
2015-06-05 13:00:00	NVDA	Stock	0.558	0.5585	0.557	0.5575	15681040.0
2015-06-05 14:00:00	NVDA	Stock	0.5578	0.5582	0.5572	0.5575	20888680.0
2015-06-05 15:00:00	NVDA	Stock	0.5578	0.558	0.5565	0.5566	63359680.0
2015-06-05 16:00:00	NVDA	Stock	0.5568	0.557	0.5546	0.5546	3311720.0
2015-06-05 04:00:00	AMZN	Stock	21.6055	21.6055	21.6055	21.6055	2000.0
2015-06-05 07:00:00	AMZN	Stock	21.5895	21.5895	21.5895	21.5895	5000.0
2015-06-05 08:00:00	AMZN	Stock	21.516	21.58	21.5	21.5	109860.0
2015-06-05 09:00:00	AMZN	Stock	21.463	21.54	21.325	21.4085	6324500.0
2015-06-05 10:00:00	AMZN	Stock	21.401	21.5115	21.384	21.4	6014440.0
2015-06-05 11:00:00	AMZN	Stock	21.4	21.484	21.3605	21.4085	4123740.0
2015-06-05 12:00:00	AMZN	Stock	21.4	21.4385	21.3405	21.433	4211820.0
2015-06-05 13:00:00	AMZN	Stock	21.4405	21.4605	21.408	21.4455	2691860.0
2015-06-05 14:00:00	AMZN	Stock	21.4515	21.495	21.4	21.4145	3827600.0
2015-06-05 15:00:00	AMZN	Stock	21.4155	21.437	21.325	21.347	8834960.0
2015-06-05 16:00:00	AMZN	Stock	21.3475	21.3575	21.3475	21.35	166920.0
2015-06-05 17:00:00	AMZN	Stock	21.35	21.3585	21.35	21.3585	26000.0

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

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