PREVIEW / stock_1hour / 2018-08-29

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-29.parquet
  size:    1.1 MB
  rows:    49,071
  symbols: 2,797

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
2018-08-29 04:00:00	AAPL	Stock	55.0625	55.125	55.015	55.05	17136.0
2018-08-29 05:00:00	AAPL	Stock	55.05	55.05	54.99	55.05	31248.0
2018-08-29 06:00:00	AAPL	Stock	55.0	55.0	54.9825	54.9825	1404.0
2018-08-29 07:00:00	AAPL	Stock	54.9925	55.105	54.985	55.0875	111048.0
2018-08-29 08:00:00	AAPL	Stock	55.0	55.11	54.9525	55.0225	471400.0
2018-08-29 09:00:00	AAPL	Stock	55.0125	55.23	54.8525	55.1	14497568.0
2018-08-29 10:00:00	AAPL	Stock	55.0975	55.375	55.05	55.3425	14103376.0
2018-08-29 11:00:00	AAPL	Stock	55.3425	55.5648	55.2875	55.54	12220364.0
2018-08-29 12:00:00	AAPL	Stock	55.5382	55.555	55.4025	55.44	9157008.0
2018-08-29 13:00:00	AAPL	Stock	55.44	55.545	55.4025	55.5228	7054936.0
2018-08-29 14:00:00	AAPL	Stock	55.5225	55.705	55.515	55.6875	10813280.0
2018-08-29 15:00:00	AAPL	Stock	55.6888	55.8725	55.6825	55.745	18195260.0
2018-08-29 16:00:00	AAPL	Stock	55.7425	55.8675	55.7225	55.835	8890328.0
2018-08-29 17:00:00	AAPL	Stock	55.84	55.9075	55.7875	55.9075	206708.0
2018-08-29 18:00:00	AAPL	Stock	55.9	55.935	55.85	55.8925	106104.0
2018-08-29 19:00:00	AAPL	Stock	55.875	55.9375	55.855	55.9375	44728.0
2018-08-29 05:00:00	MSFT	Stock	110.76	110.76	110.76	110.76	400.0
2018-08-29 06:00:00	MSFT	Stock	110.32	110.32	110.32	110.32	233.0
2018-08-29 07:00:00	MSFT	Stock	110.32	110.4	110.17	110.39	2436.0
2018-08-29 08:00:00	MSFT	Stock	110.29	110.46	110.2	110.25	21806.0
2018-08-29 09:00:00	MSFT	Stock	110.24	111.35	110.24	111.06	2621037.0
2018-08-29 10:00:00	MSFT	Stock	111.05	111.735	110.945	111.62	2601653.0
2018-08-29 11:00:00	MSFT	Stock	111.61	112.0	111.42	111.76	2030376.0
2018-08-29 12:00:00	MSFT	Stock	111.76	111.77	111.505	111.66	1737963.0
2018-08-29 13:00:00	MSFT	Stock	111.66	111.67	111.51	111.58	1102778.0
2018-08-29 14:00:00	MSFT	Stock	111.58	111.63	111.5	111.61	1478802.0
2018-08-29 15:00:00	MSFT	Stock	111.61	112.03	111.605	112.02	4401664.0
2018-08-29 16:00:00	MSFT	Stock	112.02	112.02	111.88	112.02	2684354.0
2018-08-29 17:00:00	MSFT	Stock	112.0	112.1	112.0	112.07	8432.0
2018-08-29 18:00:00	MSFT	Stock	112.02	112.17	112.02	112.1	8504.0
2018-08-29 19:00:00	MSFT	Stock	112.15	112.15	112.1	112.11	2101.0
2018-08-29 07:00:00	NVDA	Stock	6.861	6.861	6.8328	6.8472	157760.0
2018-08-29 08:00:00	NVDA	Stock	6.8354	6.8625	6.8253	6.8425	886040.0
2018-08-29 09:00:00	NVDA	Stock	6.8399	6.9278	6.827	6.8882	69506880.0
2018-08-29 10:00:00	NVDA	Stock	6.8903	6.9312	6.8814	6.9228	66254320.0
2018-08-29 11:00:00	NVDA	Stock	6.9238	6.9295	6.9065	6.9112	32088160.0
2018-08-29 12:00:00	NVDA	Stock	6.9106	6.9362	6.9003	6.9345	32398560.0
2018-08-29 13:00:00	NVDA	Stock	6.9328	6.9658	6.926	6.964	45048040.0
2018-08-29 14:00:00	NVDA	Stock	6.9638	6.9715	6.953	6.9705	37341520.0
2018-08-29 15:00:00	NVDA	Stock	6.9707	6.9875	6.959	6.9623	78976080.0
2018-08-29 16:00:00	NVDA	Stock	6.9623	6.9702	6.9568	6.96	13919680.0
2018-08-29 17:00:00	NVDA	Stock	6.966	6.966	6.9535	6.958	174520.0
2018-08-29 18:00:00	NVDA	Stock	6.9623	6.9668	6.9568	6.965	788000.0
2018-08-29 19:00:00	NVDA	Stock	6.9605	6.9605	6.9575	6.9575	176800.0
2018-08-29 04:00:00	AMZN	Stock	97.25	98.12	97.25	97.8155	75760.0
2018-08-29 05:00:00	AMZN	Stock	97.85	97.85	97.85	97.85	4340.0
2018-08-29 06:00:00	AMZN	Stock	97.9	97.9335	97.875	97.9335	21680.0
2018-08-29 07:00:00	AMZN	Stock	97.9845	97.9845	97.6205	97.7	459580.0
2018-08-29 08:00:00	AMZN	Stock	97.8	98.0	96.875	97.675	663020.0
2018-08-29 09:00:00	AMZN	Stock	97.7	98.1775	97.447	98.007	16841800.0

> showing 50 of 49,071 rows — these rows as CSV

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