PREVIEW / stock_1hour / 2017-08-09

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-09.parquet
  size:    1.1 MB
  rows:    48,458
  symbols: 2,991

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-08-09 04:00:00	AAPL	Stock	39.845	39.845	39.7525	39.8	14228.0
2017-08-09 05:00:00	AAPL	Stock	39.8625	39.8625	39.7875	39.7875	4624.0
2017-08-09 06:00:00	AAPL	Stock	39.775	39.82	39.75	39.8	27808.0
2017-08-09 07:00:00	AAPL	Stock	39.79	39.85	39.6875	39.7275	179320.0
2017-08-09 08:00:00	AAPL	Stock	39.825	39.8625	39.6825	39.8225	514436.0
2017-08-09 09:00:00	AAPL	Stock	39.8225	40.142	39.7625	40.0925	17432772.0
2017-08-09 10:00:00	AAPL	Stock	40.0938	40.2625	39.8225	40.16	15654272.0
2017-08-09 11:00:00	AAPL	Stock	40.16	40.185	39.975	40.1825	11639708.0
2017-08-09 12:00:00	AAPL	Stock	40.185	40.195	40.0425	40.0792	8744572.0
2017-08-09 13:00:00	AAPL	Stock	40.08	40.31	40.08	40.3	9927716.0
2017-08-09 14:00:00	AAPL	Stock	40.3025	40.3175	40.1025	40.1625	10122600.0
2017-08-09 15:00:00	AAPL	Stock	40.1625	40.3025	40.1	40.275	15910444.0
2017-08-09 16:00:00	AAPL	Stock	40.2775	40.3075	40.1115	40.29	3518920.0
2017-08-09 17:00:00	AAPL	Stock	40.3	40.3	40.265	40.28	182556.0
2017-08-09 18:00:00	AAPL	Stock	40.285	40.3125	40.285	40.3025	136676.0
2017-08-09 19:00:00	AAPL	Stock	40.3075	40.3225	40.2925	40.3	112012.0
2017-08-09 06:00:00	MSFT	Stock	72.5	72.5	72.33	72.33	692.0
2017-08-09 07:00:00	MSFT	Stock	72.35	72.4	72.35	72.4	1000.0
2017-08-09 08:00:00	MSFT	Stock	72.5	72.5	72.06	72.09	32760.0
2017-08-09 09:00:00	MSFT	Stock	72.15	72.39	72.01	72.275	3341710.0
2017-08-09 10:00:00	MSFT	Stock	72.28	72.48	72.139	72.33	2801095.0
2017-08-09 11:00:00	MSFT	Stock	72.33	72.505	72.12	72.455	2068921.0
2017-08-09 12:00:00	MSFT	Stock	72.46	72.51	72.35	72.36	1388128.0
2017-08-09 13:00:00	MSFT	Stock	72.36	72.46	72.3	72.355	1331454.0
2017-08-09 14:00:00	MSFT	Stock	72.355	72.39	72.22	72.38	1733232.0
2017-08-09 15:00:00	MSFT	Stock	72.38	72.51	72.26	72.45	4164299.0
2017-08-09 16:00:00	MSFT	Stock	72.47	72.5	72.394	72.48	2598922.0
2017-08-09 17:00:00	MSFT	Stock	72.5	72.51	72.47	72.5	3666.0
2017-08-09 18:00:00	MSFT	Stock	72.47	72.47	72.47	72.47	898.0
2017-08-09 19:00:00	MSFT	Stock	72.49	72.49	72.47	72.47	2597.0
2017-08-09 04:00:00	NVDA	Stock	4.23	4.23	4.22	4.22	55360.0
2017-08-09 05:00:00	NVDA	Stock	4.2152	4.221	4.2152	4.221	80120.0
2017-08-09 06:00:00	NVDA	Stock	4.2125	4.2128	4.205	4.2098	105280.0
2017-08-09 07:00:00	NVDA	Stock	4.2075	4.215	4.1915	4.2102	842160.0
2017-08-09 08:00:00	NVDA	Stock	4.2088	4.268	4.1962	4.2235	3371480.0
2017-08-09 09:00:00	NVDA	Stock	4.2235	4.2398	4.1918	4.2329	81977720.0
2017-08-09 10:00:00	NVDA	Stock	4.2336	4.2675	4.2182	4.2555	87130680.0
2017-08-09 11:00:00	NVDA	Stock	4.2542	4.2668	4.2368	4.2645	60375240.0
2017-08-09 12:00:00	NVDA	Stock	4.2642	4.2898	4.2588	4.2732	71594440.0
2017-08-09 13:00:00	NVDA	Stock	4.2741	4.2867	4.2688	4.284	38923560.0
2017-08-09 14:00:00	NVDA	Stock	4.2845	4.286	4.2563	4.266	44721000.0
2017-08-09 15:00:00	NVDA	Stock	4.2658	4.3038	4.2653	4.3025	103509880.0
2017-08-09 16:00:00	NVDA	Stock	4.3052	4.3095	4.27	4.3085	15894600.0
2017-08-09 17:00:00	NVDA	Stock	4.3082	4.31	4.3052	4.3082	897480.0
2017-08-09 18:00:00	NVDA	Stock	4.3055	4.3173	4.3055	4.315	1106560.0
2017-08-09 19:00:00	NVDA	Stock	4.317	4.317	4.307	4.309	1633640.0
2017-08-09 07:00:00	AMZN	Stock	49.175	49.235	49.1745	49.235	31620.0
2017-08-09 08:00:00	AMZN	Stock	49.21	49.595	49.15	49.25	241680.0
2017-08-09 09:00:00	AMZN	Stock	49.215	49.4	49.053	49.376	10244300.0
2017-08-09 10:00:00	AMZN	Stock	49.3728	49.375	49.1255	49.211	8320760.0

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

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