PREVIEW / stock_1hour / 2018-12-24

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-12-24.parquet
  size:    771 KB
  rows:    32,445
  symbols: 2,694

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-12-24 04:00:00	AAPL	Stock	37.6575	38.4325	37.6575	37.8625	24832.0
2018-12-24 05:00:00	AAPL	Stock	37.8125	37.8775	37.8125	37.8775	5136.0
2018-12-24 06:00:00	AAPL	Stock	37.8725	37.875	37.725	37.725	35980.0
2018-12-24 07:00:00	AAPL	Stock	37.7	37.7325	37.2075	37.25	476396.0
2018-12-24 08:00:00	AAPL	Stock	37.3125	37.8	37.19	37.22	1100460.0
2018-12-24 09:00:00	AAPL	Stock	37.245	37.5425	36.855	37.1072	36042944.0
2018-12-24 10:00:00	AAPL	Stock	37.1062	37.8875	36.815	37.6875	38834940.0
2018-12-24 11:00:00	AAPL	Stock	37.6925	37.84	37.05	37.1375	18256736.0
2018-12-24 12:00:00	AAPL	Stock	37.1375	37.2675	36.65	36.65	26303436.0
2018-12-24 13:00:00	AAPL	Stock	36.6475	36.885	36.575	36.575	10602088.0
2018-12-24 14:00:00	AAPL	Stock	36.57	36.6875	36.54	36.64	291704.0
2018-12-24 15:00:00	AAPL	Stock	36.6275	36.69	36.6125	36.6625	40528.0
2018-12-24 16:00:00	AAPL	Stock	36.6675	36.6875	36.6325	36.6875	21496.0
2018-12-24 05:00:00	MSFT	Stock	98.6	98.6	98.6	98.6	200.0
2018-12-24 06:00:00	MSFT	Stock	98.7	98.95	98.55	98.79	4750.0
2018-12-24 07:00:00	MSFT	Stock	98.65	98.74	97.25	97.25	32379.0
2018-12-24 08:00:00	MSFT	Stock	98.4	98.69	97.12	97.55	73241.0
2018-12-24 09:00:00	MSFT	Stock	97.5	98.0	94.53	95.72	8450043.0
2018-12-24 10:00:00	MSFT	Stock	95.72	97.85	94.86	96.76	10888164.0
2018-12-24 11:00:00	MSFT	Stock	96.77	97.01	94.93	95.16	6952712.0
2018-12-24 12:00:00	MSFT	Stock	95.155	95.63	93.98	94.01	9643715.0
2018-12-24 13:00:00	MSFT	Stock	94.0	94.7	93.75	93.85	3672647.0
2018-12-24 14:00:00	MSFT	Stock	93.88	93.9	93.67	93.76	24369.0
2018-12-24 15:00:00	MSFT	Stock	93.8	93.95	93.76	93.78	15276.0
2018-12-24 16:00:00	MSFT	Stock	93.95	93.98	93.8	93.8	1380.0
2018-12-24 04:00:00	NVDA	Stock	3.25	3.25	3.25	3.25	4000.0
2018-12-24 05:00:00	NVDA	Stock	3.2498	3.2498	3.2375	3.2375	40000.0
2018-12-24 06:00:00	NVDA	Stock	3.2348	3.2375	3.2325	3.2325	87000.0
2018-12-24 07:00:00	NVDA	Stock	3.2312	3.2325	3.1592	3.1592	1177520.0
2018-12-24 08:00:00	NVDA	Stock	3.1726	3.225	3.1505	3.1588	4000440.0
2018-12-24 09:00:00	NVDA	Stock	3.1618	3.2495	3.1125	3.1465	106097080.0
2018-12-24 10:00:00	NVDA	Stock	3.1495	3.2383	3.135	3.2269	119371560.0
2018-12-24 11:00:00	NVDA	Stock	3.2275	3.2425	3.2043	3.2182	67721600.0
2018-12-24 12:00:00	NVDA	Stock	3.2188	3.233	3.173	3.175	103692480.0
2018-12-24 13:00:00	NVDA	Stock	3.177	3.1878	3.1625	3.17	26523160.0
2018-12-24 14:00:00	NVDA	Stock	3.1675	3.1743	3.1591	3.1722	178600.0
2018-12-24 15:00:00	NVDA	Stock	3.1675	3.175	3.165	3.1722	146920.0
2018-12-24 16:00:00	NVDA	Stock	3.1703	3.1703	3.1578	3.1578	66040.0
2018-12-24 04:00:00	AMZN	Stock	69.074	69.074	69.074	69.074	5380.0
2018-12-24 06:00:00	AMZN	Stock	69.0	69.0	69.0	69.0	5700.0
2018-12-24 07:00:00	AMZN	Stock	69.29	69.29	67.723	67.723	417920.0
2018-12-24 08:00:00	AMZN	Stock	68.15	69.0	67.1	67.475	1081840.0
2018-12-24 09:00:00	AMZN	Stock	67.5155	68.16	65.35	66.252	28458300.0
2018-12-24 10:00:00	AMZN	Stock	66.2334	69.8015	66.0	69.0375	35985020.0
2018-12-24 11:00:00	AMZN	Stock	69.041	69.2993	67.5	67.6515	16837180.0
2018-12-24 12:00:00	AMZN	Stock	67.6756	68.075	67.0	67.137	19575940.0
2018-12-24 13:00:00	AMZN	Stock	67.134	67.2097	66.701	67.198	3621680.0
2018-12-24 14:00:00	AMZN	Stock	66.803	67.198	66.725	66.725	97580.0
2018-12-24 15:00:00	AMZN	Stock	66.784	66.8	66.7215	66.7215	15700.0
2018-12-24 16:00:00	AMZN	Stock	66.85	66.85	66.85	66.85	2440.0

> showing 50 of 32,445 rows — these rows as CSV

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