PREVIEW / stock_1hour / 2019-03-05

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-03-05.parquet
  size:    1.1 MB
  rows:    49,649
  symbols: 2,638

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
2019-03-05 04:00:00	AAPL	Stock	44.04	44.075	44.04	44.045	2416.0
2019-03-05 05:00:00	AAPL	Stock	44.025	44.025	43.9375	43.9375	4020.0
2019-03-05 06:00:00	AAPL	Stock	43.95	43.95	43.95	43.95	9584.0
2019-03-05 07:00:00	AAPL	Stock	43.95	43.95	43.85	43.875	47044.0
2019-03-05 08:00:00	AAPL	Stock	43.9375	44.0325	43.825	43.935	127420.0
2019-03-05 09:00:00	AAPL	Stock	43.935	44.0	43.6915	43.72	10104076.0
2019-03-05 10:00:00	AAPL	Stock	43.72	43.885	43.635	43.7925	12985532.0
2019-03-05 11:00:00	AAPL	Stock	43.7925	43.9875	43.7675	43.8775	8886668.0
2019-03-05 12:00:00	AAPL	Stock	43.8775	43.8875	43.7725	43.815	5692532.0
2019-03-05 13:00:00	AAPL	Stock	43.8175	43.8675	43.7888	43.845	4539384.0
2019-03-05 14:00:00	AAPL	Stock	43.845	43.925	43.8418	43.9162	4286400.0
2019-03-05 15:00:00	AAPL	Stock	43.9162	43.9625	43.87	43.8775	9550956.0
2019-03-05 16:00:00	AAPL	Stock	43.88	43.911	43.85	43.855	13784404.0
2019-03-05 17:00:00	AAPL	Stock	43.85	43.86	43.8025	43.8125	23240.0
2019-03-05 18:00:00	AAPL	Stock	43.8125	43.8575	43.7525	43.7525	16552.0
2019-03-05 19:00:00	AAPL	Stock	43.8375	43.8375	43.76	43.775	22392.0
2019-03-05 04:00:00	MSFT	Stock	112.42	112.42	112.42	112.42	100.0
2019-03-05 05:00:00	MSFT	Stock	112.25	112.25	112.25	112.25	100.0
2019-03-05 06:00:00	MSFT	Stock	112.25	112.25	112.21	112.21	420.0
2019-03-05 07:00:00	MSFT	Stock	112.13	112.13	111.9	112.05	7600.0
2019-03-05 08:00:00	MSFT	Stock	112.06	112.29	111.95	112.15	26766.0
2019-03-05 09:00:00	MSFT	Stock	112.1	112.39	111.254	111.5	1998420.0
2019-03-05 10:00:00	MSFT	Stock	111.5	111.87	111.23	111.63	2213368.0
2019-03-05 11:00:00	MSFT	Stock	111.62	111.91	111.455	111.68	1544187.0
2019-03-05 12:00:00	MSFT	Stock	111.68	111.74	111.49	111.65	1065522.0
2019-03-05 13:00:00	MSFT	Stock	111.65	111.8	111.45	111.575	1180334.0
2019-03-05 14:00:00	MSFT	Stock	111.575	111.87	111.51	111.86	949741.0
2019-03-05 15:00:00	MSFT	Stock	111.85	112.01	111.66	111.68	2779476.0
2019-03-05 16:00:00	MSFT	Stock	111.7	111.89	111.7	111.75	5101060.0
2019-03-05 17:00:00	MSFT	Stock	111.844	111.844	111.517	111.6	5011.0
2019-03-05 18:00:00	MSFT	Stock	111.55	111.65	111.5	111.55	7430.0
2019-03-05 19:00:00	MSFT	Stock	111.5	111.55	111.4	111.45	5614.0
2019-03-05 07:00:00	NVDA	Stock	3.9272	3.9328	3.9	3.9008	253440.0
2019-03-05 08:00:00	NVDA	Stock	3.908	3.9292	3.8765	3.9038	1043280.0
2019-03-05 09:00:00	NVDA	Stock	3.9038	3.9156	3.849	3.8626	50495200.0
2019-03-05 10:00:00	NVDA	Stock	3.8648	3.9095	3.8642	3.9039	64728680.0
2019-03-05 11:00:00	NVDA	Stock	3.9032	3.9298	3.895	3.9263	47397880.0
2019-03-05 12:00:00	NVDA	Stock	3.9258	3.9388	3.9232	3.932	24745200.0
2019-03-05 13:00:00	NVDA	Stock	3.932	3.9514	3.9295	3.9365	27235120.0
2019-03-05 14:00:00	NVDA	Stock	3.9364	3.9457	3.9155	3.9238	35734400.0
2019-03-05 15:00:00	NVDA	Stock	3.9232	3.9362	3.9118	3.9128	52267280.0
2019-03-05 16:00:00	NVDA	Stock	3.913	3.9238	3.91	3.915	25180240.0
2019-03-05 17:00:00	NVDA	Stock	3.915	3.915	3.9038	3.9147	146080.0
2019-03-05 18:00:00	NVDA	Stock	3.9098	3.915	3.9042	3.915	96000.0
2019-03-05 19:00:00	NVDA	Stock	3.9053	3.9125	3.9038	3.905	206520.0
2019-03-05 05:00:00	AMZN	Stock	84.951	84.951	84.951	84.951	5340.0
2019-03-05 06:00:00	AMZN	Stock	84.9925	84.9925	84.9925	84.9925	4760.0
2019-03-05 07:00:00	AMZN	Stock	85.0055	85.0495	84.695	84.7	204280.0
2019-03-05 08:00:00	AMZN	Stock	85.096	85.179	84.65	85.013	405280.0
2019-03-05 09:00:00	AMZN	Stock	85.0305	85.39	84.4505	84.84	15205320.0

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

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