PREVIEW / stock_1hour / 2017-06-14

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-06-14.parquet
  size:    1.0 MB
  rows:    48,258
  symbols: 3,029

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-06-14 05:00:00	AAPL	Stock	36.745	36.8175	36.7425	36.8	17024.0
2017-06-14 06:00:00	AAPL	Stock	36.755	36.8425	36.7525	36.8125	15876.0
2017-06-14 07:00:00	AAPL	Stock	36.8125	36.8675	36.805	36.8175	81168.0
2017-06-14 08:00:00	AAPL	Stock	36.835	36.8675	36.7125	36.7725	262112.0
2017-06-14 09:00:00	AAPL	Stock	36.7725	36.875	36.5275	36.66	11753424.0
2017-06-14 10:00:00	AAPL	Stock	36.66	36.66	36.38	36.4325	15307316.0
2017-06-14 11:00:00	AAPL	Stock	36.435	36.545	36.345	36.525	10349176.0
2017-06-14 12:00:00	AAPL	Stock	36.5255	36.5275	36.3525	36.3775	7276044.0
2017-06-14 13:00:00	AAPL	Stock	36.3805	36.465	36.3725	36.3975	6127652.0
2017-06-14 14:00:00	AAPL	Stock	36.395	36.5375	36.1525	36.19	21654572.0
2017-06-14 15:00:00	AAPL	Stock	36.1875	36.33	35.96	36.29	32309120.0
2017-06-14 16:00:00	AAPL	Stock	36.29	36.33	36.2575	36.29	7323912.0
2017-06-14 17:00:00	AAPL	Stock	36.275	36.29	36.2625	36.265	43716.0
2017-06-14 18:00:00	AAPL	Stock	36.2625	36.275	36.1325	36.18	91248.0
2017-06-14 19:00:00	AAPL	Stock	36.15	36.1625	36.1275	36.15	83712.0
2017-06-14 04:00:00	MSFT	Stock	70.7	70.7	70.7	70.7	100.0
2017-06-14 07:00:00	MSFT	Stock	70.84	70.87	70.81	70.81	2700.0
2017-06-14 08:00:00	MSFT	Stock	70.7	70.99	70.65	70.95	26278.0
2017-06-14 09:00:00	MSFT	Stock	70.95	71.1	70.74	70.9	1816301.0
2017-06-14 10:00:00	MSFT	Stock	70.91	70.995	70.49	70.79	2432172.0
2017-06-14 11:00:00	MSFT	Stock	70.79	71.08	70.7	71.08	2113554.0
2017-06-14 12:00:00	MSFT	Stock	71.075	71.075	70.82	70.87	2002217.0
2017-06-14 13:00:00	MSFT	Stock	70.87	71.04	70.75	70.82	1750934.0
2017-06-14 14:00:00	MSFT	Stock	70.82	71.05	69.8	70.01	3971696.0
2017-06-14 15:00:00	MSFT	Stock	70.01	70.32	69.43	70.27	7701592.0
2017-06-14 16:00:00	MSFT	Stock	70.27	70.33	70.2	70.27	2098441.0
2017-06-14 17:00:00	MSFT	Stock	70.19	70.21	70.19	70.19	850.0
2017-06-14 18:00:00	MSFT	Stock	70.17	70.17	70.17	70.17	100.0
2017-06-14 19:00:00	MSFT	Stock	70.1	70.1	69.82	69.82	1450.0
2017-06-14 04:00:00	NVDA	Stock	3.8125	3.8318	3.8125	3.8318	23760.0
2017-06-14 06:00:00	NVDA	Stock	3.8125	3.8188	3.8	3.8188	533920.0
2017-06-14 07:00:00	NVDA	Stock	3.8258	3.8345	3.8125	3.818	1629520.0
2017-06-14 08:00:00	NVDA	Stock	3.825	3.8322	3.79	3.7925	4853800.0
2017-06-14 09:00:00	NVDA	Stock	3.7925	3.805	3.7125	3.7378	177951120.0
2017-06-14 10:00:00	NVDA	Stock	3.7395	3.8128	3.738	3.8002	205301200.0
2017-06-14 11:00:00	NVDA	Stock	3.8022	3.8275	3.7678	3.8275	119680560.0
2017-06-14 12:00:00	NVDA	Stock	3.8265	3.8515	3.8142	3.8414	130062320.0
2017-06-14 13:00:00	NVDA	Stock	3.8422	3.8425	3.7913	3.798	99500000.0
2017-06-14 14:00:00	NVDA	Stock	3.7995	3.8292	3.7443	3.7653	184618800.0
2017-06-14 15:00:00	NVDA	Stock	3.765	3.7978	3.7275	3.793	166134000.0
2017-06-14 16:00:00	NVDA	Stock	3.793	3.7965	3.7812	3.7825	47190120.0
2017-06-14 17:00:00	NVDA	Stock	3.788	3.79	3.755	3.7588	1031200.0
2017-06-14 18:00:00	NVDA	Stock	3.7612	3.7785	3.7508	3.7508	992280.0
2017-06-14 19:00:00	NVDA	Stock	3.7515	3.7562	3.7375	3.74	2105440.0
2017-06-14 06:00:00	AMZN	Stock	49.175	49.2	49.17	49.2	32820.0
2017-06-14 07:00:00	AMZN	Stock	49.2	49.2885	49.175	49.18	103720.0
2017-06-14 08:00:00	AMZN	Stock	49.1725	49.224	49.063	49.15	444880.0
2017-06-14 09:00:00	AMZN	Stock	49.1675	49.517	49.0565	49.448	13072400.0
2017-06-14 10:00:00	AMZN	Stock	49.4425	49.483	49.175	49.3232	10596960.0
2017-06-14 11:00:00	AMZN	Stock	49.3285	49.3419	49.165	49.2855	4729860.0

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

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