PREVIEW / stock_1hour / 2016-10-24

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-10-24.parquet
  size:    1.0 MB
  rows:    47,452
  symbols: 3,212

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-10-24 04:00:00	AAPL	Stock	29.1675	29.285	29.1675	29.285	2000.0
2016-10-24 05:00:00	AAPL	Stock	29.3125	29.365	29.3125	29.35	30076.0
2016-10-24 06:00:00	AAPL	Stock	29.35	29.37	29.3375	29.37	26208.0
2016-10-24 07:00:00	AAPL	Stock	29.35	29.3675	29.275	29.2925	65016.0
2016-10-24 08:00:00	AAPL	Stock	29.3575	29.3575	29.2475	29.28	390464.0
2016-10-24 09:00:00	AAPL	Stock	29.29	29.3975	29.225	29.3562	15120120.0
2016-10-24 10:00:00	AAPL	Stock	29.3575	29.3675	29.265	29.34	14402828.0
2016-10-24 11:00:00	AAPL	Stock	29.34	29.375	29.33	29.3388	9202436.0
2016-10-24 12:00:00	AAPL	Stock	29.3388	29.35	29.3025	29.3175	6460988.0
2016-10-24 13:00:00	AAPL	Stock	29.3198	29.41	29.3175	29.4045	8833216.0
2016-10-24 14:00:00	AAPL	Stock	29.405	29.435	29.3325	29.3625	8977552.0
2016-10-24 15:00:00	AAPL	Stock	29.36	29.42	29.335	29.4025	14039648.0
2016-10-24 16:00:00	AAPL	Stock	29.4125	29.4175	29.3425	29.415	7580768.0
2016-10-24 17:00:00	AAPL	Stock	29.41	29.415	29.4	29.4125	269648.0
2016-10-24 18:00:00	AAPL	Stock	29.4	29.4125	29.375	29.4125	49836.0
2016-10-24 19:00:00	AAPL	Stock	29.4125	29.425	29.4025	29.425	57540.0
2016-10-24 04:00:00	MSFT	Stock	59.94	60.05	59.94	59.96	4381.0
2016-10-24 05:00:00	MSFT	Stock	59.94	59.94	59.94	59.94	400.0
2016-10-24 06:00:00	MSFT	Stock	59.94	59.94	59.85	59.91	14935.0
2016-10-24 07:00:00	MSFT	Stock	59.91	59.91	59.79	59.79	14250.0
2016-10-24 08:00:00	MSFT	Stock	59.76	59.88	59.66	59.84	25802.0
2016-10-24 09:00:00	MSFT	Stock	59.8	60.5	59.77	60.415	7056936.0
2016-10-24 10:00:00	MSFT	Stock	60.415	60.59	60.35	60.47	6977085.0
2016-10-24 11:00:00	MSFT	Stock	60.47	60.7	60.46	60.48	4320847.0
2016-10-24 12:00:00	MSFT	Stock	60.471	60.53	60.38	60.515	4250769.0
2016-10-24 13:00:00	MSFT	Stock	60.515	60.86	60.5	60.86	5686130.0
2016-10-24 14:00:00	MSFT	Stock	60.86	60.88	60.71	60.85	5254078.0
2016-10-24 15:00:00	MSFT	Stock	60.85	61.0	60.77	60.99	11365596.0
2016-10-24 16:00:00	MSFT	Stock	60.99	61.0	60.92	60.96	4871586.0
2016-10-24 17:00:00	MSFT	Stock	60.95	61.0	60.9	60.99	1261576.0
2016-10-24 18:00:00	MSFT	Stock	60.97	60.99	60.93	60.96	5077.0
2016-10-24 19:00:00	MSFT	Stock	60.97	61.0	60.97	61.0	2995.0
2016-10-24 04:00:00	NVDA	Stock	1.695	1.6988	1.695	1.6978	36000.0
2016-10-24 05:00:00	NVDA	Stock	1.6978	1.6978	1.6978	1.6978	20000.0
2016-10-24 06:00:00	NVDA	Stock	1.6978	1.6978	1.6978	1.6978	10000.0
2016-10-24 07:00:00	NVDA	Stock	1.6978	1.7003	1.6975	1.7003	65600.0
2016-10-24 08:00:00	NVDA	Stock	1.7062	1.7062	1.6955	1.7	122280.0
2016-10-24 09:00:00	NVDA	Stock	1.6988	1.7375	1.6988	1.7328	42856920.0
2016-10-24 10:00:00	NVDA	Stock	1.733	1.7413	1.7295	1.7405	41582440.0
2016-10-24 11:00:00	NVDA	Stock	1.7398	1.7438	1.736	1.7414	31925120.0
2016-10-24 12:00:00	NVDA	Stock	1.7413	1.7475	1.7375	1.7464	26660640.0
2016-10-24 13:00:00	NVDA	Stock	1.7462	1.751	1.7453	1.7484	33570440.0
2016-10-24 14:00:00	NVDA	Stock	1.7485	1.7622	1.7484	1.7618	39343720.0
2016-10-24 15:00:00	NVDA	Stock	1.7618	1.7698	1.7608	1.7678	88440800.0
2016-10-24 16:00:00	NVDA	Stock	1.7678	1.769	1.764	1.764	23875480.0
2016-10-24 17:00:00	NVDA	Stock	1.766	1.767	1.7655	1.767	62000.0
2016-10-24 18:00:00	NVDA	Stock	1.767	1.7675	1.767	1.7675	52000.0
2016-10-24 19:00:00	NVDA	Stock	1.7675	1.7675	1.7665	1.7665	65200.0
2016-10-24 04:00:00	AMZN	Stock	41.2	41.2255	41.2	41.21	16000.0
2016-10-24 05:00:00	AMZN	Stock	41.2115	41.2115	41.15	41.1935	29020.0

> showing 50 of 47,452 rows — these rows as CSV

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