PREVIEW / stock_1hour / 2019-07-05

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-07-05.parquet
  size:    1.1 MB
  rows:    48,213
  symbols: 2,553

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-07-05 04:00:00	AAPL	Stock	51.1025	51.1375	50.895	50.895	6560.0
2019-07-05 05:00:00	AAPL	Stock	50.9175	51.0	50.9175	50.95	5540.0
2019-07-05 06:00:00	AAPL	Stock	50.9675	51.0	50.9625	50.9625	7028.0
2019-07-05 07:00:00	AAPL	Stock	50.95	51.0275	50.95	51.025	32572.0
2019-07-05 08:00:00	AAPL	Stock	51.01	51.075	50.7475	50.825	362928.0
2019-07-05 09:00:00	AAPL	Stock	50.8525	51.115	50.725	50.9875	9321560.0
2019-07-05 10:00:00	AAPL	Stock	50.99	51.115	50.8525	50.9575	9300176.0
2019-07-05 11:00:00	AAPL	Stock	50.96	51.0025	50.8928	50.9725	5186008.0
2019-07-05 12:00:00	AAPL	Stock	50.975	51.135	50.943	51.0675	4606720.0
2019-07-05 13:00:00	AAPL	Stock	51.0682	51.24	51.0375	51.1975	4742232.0
2019-07-05 14:00:00	AAPL	Stock	51.195	51.27	51.1712	51.255	6370628.0
2019-07-05 15:00:00	AAPL	Stock	51.255	51.26	50.93	51.0625	11730768.0
2019-07-05 16:00:00	AAPL	Stock	51.0525	51.18	50.9775	51.0025	6830956.0
2019-07-05 17:00:00	AAPL	Stock	51.0225	51.0225	50.9625	50.975	45356.0
2019-07-05 18:00:00	AAPL	Stock	51.0	51.0125	50.99	50.9925	8076.0
2019-07-05 19:00:00	AAPL	Stock	50.9925	51.0075	50.97	51.0075	30304.0
2019-07-05 04:00:00	MSFT	Stock	137.73	138.01	137.5	137.5	18789.0
2019-07-05 05:00:00	MSFT	Stock	137.51	137.79	137.4	137.4	1106.0
2019-07-05 06:00:00	MSFT	Stock	137.4	137.78	137.35	137.41	2317.0
2019-07-05 07:00:00	MSFT	Stock	137.48	137.51	137.4	137.49	5813.0
2019-07-05 08:00:00	MSFT	Stock	137.35	137.64	136.2	136.75	45415.0
2019-07-05 09:00:00	MSFT	Stock	136.75	136.9	135.86	135.87	2388643.0
2019-07-05 10:00:00	MSFT	Stock	135.87	136.41	135.72	135.88	2193417.0
2019-07-05 11:00:00	MSFT	Stock	135.89	136.24	135.77	135.995	1667319.0
2019-07-05 12:00:00	MSFT	Stock	136.0	136.5	135.8	136.297	1271269.0
2019-07-05 13:00:00	MSFT	Stock	136.3	136.83	136.23	136.711	1035424.0
2019-07-05 14:00:00	MSFT	Stock	136.715	137.32	136.71	137.315	1163957.0
2019-07-05 15:00:00	MSFT	Stock	137.311	137.33	136.81	137.07	3148995.0
2019-07-05 16:00:00	MSFT	Stock	137.06	137.2	136.7	137.15	2793665.0
2019-07-05 17:00:00	MSFT	Stock	137.1	137.15	137.06	137.07	15527.0
2019-07-05 18:00:00	MSFT	Stock	137.07	137.1	137.07	137.1	1007.0
2019-07-05 19:00:00	MSFT	Stock	137.09	137.1	137.07	137.1	3890.0
2019-07-05 04:00:00	NVDA	Stock	4.0688	4.0688	4.0688	4.0688	10880.0
2019-07-05 05:00:00	NVDA	Stock	4.0618	4.0638	4.0618	4.0638	17200.0
2019-07-05 06:00:00	NVDA	Stock	4.0638	4.0638	4.0638	4.0638	4000.0
2019-07-05 07:00:00	NVDA	Stock	4.0623	4.0623	4.05	4.05	532840.0
2019-07-05 08:00:00	NVDA	Stock	4.06	4.06	4.0127	4.0248	1312480.0
2019-07-05 09:00:00	NVDA	Stock	4.0225	4.025	3.9638	3.9766	64144520.0
2019-07-05 10:00:00	NVDA	Stock	3.976	3.9842	3.942	3.961	78390440.0
2019-07-05 11:00:00	NVDA	Stock	3.962	3.98	3.9558	3.9655	44357360.0
2019-07-05 12:00:00	NVDA	Stock	3.966	3.9965	3.9645	3.9958	58866240.0
2019-07-05 13:00:00	NVDA	Stock	3.9965	4.0125	3.9938	4.0048	36983760.0
2019-07-05 14:00:00	NVDA	Stock	4.0048	4.0145	3.998	4.012	39245640.0
2019-07-05 15:00:00	NVDA	Stock	4.0115	4.0121	3.9958	4.0082	48543880.0
2019-07-05 16:00:00	NVDA	Stock	4.0058	4.0063	4.0	4.0058	2502920.0
2019-07-05 17:00:00	NVDA	Stock	4.0013	4.0038	3.9955	4.0038	592520.0
2019-07-05 18:00:00	NVDA	Stock	4.0038	4.0055	4.0013	4.0022	168600.0
2019-07-05 19:00:00	NVDA	Stock	4.0038	4.0045	4.0018	4.0018	161840.0
2019-07-05 07:00:00	AMZN	Stock	96.8	96.8	96.8	96.8	6000.0
2019-07-05 08:00:00	AMZN	Stock	96.8	96.9365	96.45	96.4918	383780.0

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

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