PREVIEW / stock_1hour / 2018-05-03

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-05-03.parquet
  size:    1.1 MB
  rows:    49,260
  symbols: 2,826

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-05-03 04:00:00	AAPL	Stock	44.06	44.0875	44.0	44.01	34852.0
2018-05-03 05:00:00	AAPL	Stock	44.01	44.06	43.94	44.0	30624.0
2018-05-03 06:00:00	AAPL	Stock	44.02	44.0925	44.0	44.0525	30124.0
2018-05-03 07:00:00	AAPL	Stock	44.0725	44.1125	43.925	43.9375	320144.0
2018-05-03 08:00:00	AAPL	Stock	44.0625	44.125	43.9	43.95	511284.0
2018-05-03 09:00:00	AAPL	Stock	43.95	44.1875	43.7025	44.175	21946588.0
2018-05-03 10:00:00	AAPL	Stock	44.1625	44.18	43.6102	43.6987	22483748.0
2018-05-03 11:00:00	AAPL	Stock	43.7	43.9325	43.6225	43.8752	13972144.0
2018-05-03 12:00:00	AAPL	Stock	43.88	44.2225	43.74	44.215	12458324.0
2018-05-03 13:00:00	AAPL	Stock	44.21	44.335	44.1075	44.235	13911532.0
2018-05-03 14:00:00	AAPL	Stock	44.2375	44.375	44.15	44.2175	11622484.0
2018-05-03 15:00:00	AAPL	Stock	44.2258	44.3	44.12	44.2225	16887676.0
2018-05-03 16:00:00	AAPL	Stock	44.2225	44.325	44.0372	44.27	7434940.0
2018-05-03 17:00:00	AAPL	Stock	44.24	44.2675	44.24	44.25	28980.0
2018-05-03 18:00:00	AAPL	Stock	44.2575	44.3125	44.2575	44.31	36260.0
2018-05-03 19:00:00	AAPL	Stock	44.2875	44.3	44.2	44.25	73780.0
2018-05-03 07:00:00	MSFT	Stock	93.78	93.78	93.1	93.15	13991.0
2018-05-03 08:00:00	MSFT	Stock	93.64	93.64	92.9	93.16	24009.0
2018-05-03 09:00:00	MSFT	Stock	93.2	94.05	92.7	94.01	2910441.0
2018-05-03 10:00:00	MSFT	Stock	94.01	94.04	92.45	92.675	4346884.0
2018-05-03 11:00:00	MSFT	Stock	92.67	93.38	92.49	93.21	3098246.0
2018-05-03 12:00:00	MSFT	Stock	93.21	94.23	92.83	94.15	3037643.0
2018-05-03 13:00:00	MSFT	Stock	94.15	94.38	93.69	94.18	3050229.0
2018-05-03 14:00:00	MSFT	Stock	94.17	94.925	94.04	94.37	3190888.0
2018-05-03 15:00:00	MSFT	Stock	94.375	94.74	93.83	94.09	4436234.0
2018-05-03 16:00:00	MSFT	Stock	94.07	94.44	93.707	94.3	3927692.0
2018-05-03 17:00:00	MSFT	Stock	94.13	94.34	94.13	94.32	774.0
2018-05-03 18:00:00	MSFT	Stock	94.32	94.42	94.25	94.27	5050.0
2018-05-03 19:00:00	MSFT	Stock	94.3	94.37	94.15	94.15	1988.0
2018-05-03 04:00:00	NVDA	Stock	5.7613	5.7625	5.7268	5.744	30920.0
2018-05-03 05:00:00	NVDA	Stock	5.7432	5.7595	5.7375	5.7575	245160.0
2018-05-03 06:00:00	NVDA	Stock	5.7375	5.7623	5.7375	5.7623	158600.0
2018-05-03 07:00:00	NVDA	Stock	5.73	5.7475	5.6875	5.691	1484800.0
2018-05-03 08:00:00	NVDA	Stock	5.7312	5.7368	5.685	5.6975	2476000.0
2018-05-03 09:00:00	NVDA	Stock	5.695	5.7188	5.6505	5.707	58509920.0
2018-05-03 10:00:00	NVDA	Stock	5.7054	5.736	5.6443	5.6615	59485960.0
2018-05-03 11:00:00	NVDA	Stock	5.6615	5.7038	5.6488	5.6975	40230360.0
2018-05-03 12:00:00	NVDA	Stock	5.6984	5.7965	5.6803	5.7913	48049960.0
2018-05-03 13:00:00	NVDA	Stock	5.7928	5.8223	5.77	5.8002	53621560.0
2018-05-03 14:00:00	NVDA	Stock	5.8015	5.842	5.79	5.8077	45670640.0
2018-05-03 15:00:00	NVDA	Stock	5.8095	5.8512	5.8072	5.8248	71928120.0
2018-05-03 16:00:00	NVDA	Stock	5.8248	5.837	5.8248	5.8278	3302080.0
2018-05-03 17:00:00	NVDA	Stock	5.8338	5.841	5.8278	5.8403	787560.0
2018-05-03 18:00:00	NVDA	Stock	5.8443	5.8495	5.84	5.8482	803920.0
2018-05-03 19:00:00	NVDA	Stock	5.8482	5.8495	5.83	5.8325	659680.0
2018-05-03 06:00:00	AMZN	Stock	78.5005	78.5005	78.445	78.4505	16000.0
2018-05-03 07:00:00	AMZN	Stock	78.3625	78.377	78.15	78.2	78920.0
2018-05-03 08:00:00	AMZN	Stock	78.0838	78.47	78.0838	78.2945	270360.0
2018-05-03 09:00:00	AMZN	Stock	78.275	78.5955	77.905	78.4155	13256580.0
2018-05-03 10:00:00	AMZN	Stock	78.4005	78.515	77.3565	77.587	15620680.0

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

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