PREVIEW / stock_1hour / 2016-11-22

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-11-22.parquet
  size:    1.1 MB
  rows:    48,596
  symbols: 3,183

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-11-22 04:00:00	AAPL	Stock	28.0	28.01	27.975	28.01	35860.0
2016-11-22 05:00:00	AAPL	Stock	28.02	28.0275	28.02	28.025	43296.0
2016-11-22 06:00:00	AAPL	Stock	28.0025	28.0025	27.975	27.975	8664.0
2016-11-22 07:00:00	AAPL	Stock	27.9975	28.0175	27.975	28.01	80408.0
2016-11-22 08:00:00	AAPL	Stock	27.9975	28.0025	27.875	27.9425	236584.0
2016-11-22 09:00:00	AAPL	Stock	27.9425	28.105	27.915	28.02	15135208.0
2016-11-22 10:00:00	AAPL	Stock	28.02	28.0625	27.85	27.9025	14800976.0
2016-11-22 11:00:00	AAPL	Stock	27.9038	27.9725	27.8925	27.9425	10270008.0
2016-11-22 12:00:00	AAPL	Stock	27.945	27.9925	27.9225	27.9535	7148636.0
2016-11-22 13:00:00	AAPL	Stock	27.955	27.9975	27.9538	27.9812	6704672.0
2016-11-22 14:00:00	AAPL	Stock	27.9825	27.9825	27.9138	27.9405	9270824.0
2016-11-22 15:00:00	AAPL	Stock	27.941	27.9775	27.9275	27.9425	11202452.0
2016-11-22 16:00:00	AAPL	Stock	27.95	28.0075	27.935	27.9425	18957572.0
2016-11-22 17:00:00	AAPL	Stock	27.96	27.965	27.935	27.9625	83044.0
2016-11-22 18:00:00	AAPL	Stock	27.97	27.975	27.95	27.95	40100.0
2016-11-22 19:00:00	AAPL	Stock	27.9375	27.9525	27.935	27.9425	17396.0
2016-11-22 04:00:00	MSFT	Stock	61.08	61.08	61.08	61.08	121.0
2016-11-22 05:00:00	MSFT	Stock	61.04	61.05	61.04	61.05	200.0
2016-11-22 06:00:00	MSFT	Stock	61.03	61.03	61.02	61.02	200.0
2016-11-22 07:00:00	MSFT	Stock	61.0	61.0	61.0	61.0	100.0
2016-11-22 08:00:00	MSFT	Stock	60.91	61.03	60.91	60.99	4322.0
2016-11-22 09:00:00	MSFT	Stock	60.99	61.11	60.805	60.81	1912781.0
2016-11-22 10:00:00	MSFT	Stock	60.81	61.17	60.805	61.051	3705369.0
2016-11-22 11:00:00	MSFT	Stock	61.055	61.17	60.995	61.17	1962041.0
2016-11-22 12:00:00	MSFT	Stock	61.17	61.26	61.05	61.216	1927600.0
2016-11-22 13:00:00	MSFT	Stock	61.22	61.26	61.09	61.105	1778539.0
2016-11-22 14:00:00	MSFT	Stock	61.105	61.17	61.0	61.075	1714183.0
2016-11-22 15:00:00	MSFT	Stock	61.075	61.18	61.01	61.11	3106797.0
2016-11-22 16:00:00	MSFT	Stock	61.12	61.15	61.12	61.14	3153775.0
2016-11-22 17:00:00	MSFT	Stock	61.12	61.14	61.12	61.14	558151.0
2016-11-22 18:00:00	MSFT	Stock	61.1	61.1	61.1	61.1	100.0
2016-11-22 19:00:00	MSFT	Stock	61.14	61.14	61.14	61.14	127.0
2016-11-22 07:00:00	NVDA	Stock	2.33	2.33	2.33	2.33	24000.0
2016-11-22 08:00:00	NVDA	Stock	2.3275	2.3372	2.3275	2.33	212440.0
2016-11-22 09:00:00	NVDA	Stock	2.3325	2.3405	2.3095	2.321	56614160.0
2016-11-22 10:00:00	NVDA	Stock	2.321	2.3295	2.3128	2.3282	48232720.0
2016-11-22 11:00:00	NVDA	Stock	2.329	2.3435	2.322	2.323	54084640.0
2016-11-22 12:00:00	NVDA	Stock	2.3228	2.3285	2.3178	2.322	26919240.0
2016-11-22 13:00:00	NVDA	Stock	2.3218	2.34	2.3216	2.3376	24362520.0
2016-11-22 14:00:00	NVDA	Stock	2.3376	2.3408	2.3308	2.3374	29151080.0
2016-11-22 15:00:00	NVDA	Stock	2.3375	2.3422	2.3337	2.3412	46526040.0
2016-11-22 16:00:00	NVDA	Stock	2.3412	2.345	2.3402	2.345	23597240.0
2016-11-22 17:00:00	NVDA	Stock	2.345	2.3488	2.3438	2.3438	142320.0
2016-11-22 18:00:00	NVDA	Stock	2.345	2.348	2.345	2.3458	144160.0
2016-11-22 19:00:00	NVDA	Stock	2.3473	2.3473	2.345	2.3473	154240.0
2016-11-22 04:00:00	AMZN	Stock	39.25	39.25	39.25	39.25	2000.0
2016-11-22 05:00:00	AMZN	Stock	39.245	39.245	39.243	39.243	5660.0
2016-11-22 06:00:00	AMZN	Stock	39.2245	39.225	39.156	39.156	6000.0
2016-11-22 07:00:00	AMZN	Stock	39.1725	39.325	39.15	39.275	290240.0
2016-11-22 08:00:00	AMZN	Stock	39.285	39.355	39.2	39.2775	785000.0

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

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