PREVIEW / stock_1hour / 2018-07-23

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-07-23.parquet
  size:    1.1 MB
  rows:    48,801
  symbols: 2,802

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-07-23 04:00:00	AAPL	Stock	47.7125	47.7125	47.675	47.675	1628.0
2018-07-23 07:00:00	AAPL	Stock	47.6975	47.75	47.65	47.75	97364.0
2018-07-23 08:00:00	AAPL	Stock	47.6575	47.965	47.6575	47.7625	357220.0
2018-07-23 09:00:00	AAPL	Stock	47.7625	47.7825	47.415	47.52	9330204.0
2018-07-23 10:00:00	AAPL	Stock	47.52	47.59	47.39	47.5325	9105184.0
2018-07-23 11:00:00	AAPL	Stock	47.535	47.695	47.495	47.6725	5676720.0
2018-07-23 12:00:00	AAPL	Stock	47.675	47.855	47.6625	47.7762	4889572.0
2018-07-23 13:00:00	AAPL	Stock	47.775	47.88	47.745	47.855	4042948.0
2018-07-23 14:00:00	AAPL	Stock	47.8575	47.9575	47.84	47.955	4746120.0
2018-07-23 15:00:00	AAPL	Stock	47.955	47.99	47.8775	47.9	6142144.0
2018-07-23 16:00:00	AAPL	Stock	47.9025	48.0225	47.85	47.9175	12742976.0
2018-07-23 17:00:00	AAPL	Stock	47.9	47.925	47.8625	47.895	44724.0
2018-07-23 18:00:00	AAPL	Stock	47.9075	47.9375	47.8975	47.925	27800.0
2018-07-23 19:00:00	AAPL	Stock	47.945	47.9875	47.915	47.9725	28232.0
2018-07-23 04:00:00	MSFT	Stock	106.2	106.34	106.11	106.11	861.0
2018-07-23 05:00:00	MSFT	Stock	106.32	106.35	106.16	106.16	1100.0
2018-07-23 06:00:00	MSFT	Stock	106.29	106.29	106.02	106.1	3157.0
2018-07-23 07:00:00	MSFT	Stock	106.0	106.1	105.95	106.1	6181.0
2018-07-23 08:00:00	MSFT	Stock	106.12	106.4	106.0	106.29	21746.0
2018-07-23 09:00:00	MSFT	Stock	106.27	107.49	106.13	107.476	4243743.0
2018-07-23 10:00:00	MSFT	Stock	107.48	107.96	107.32	107.8	5207503.0
2018-07-23 11:00:00	MSFT	Stock	107.8	107.93	107.36	107.76	3236822.0
2018-07-23 12:00:00	MSFT	Stock	107.76	107.87	107.59	107.75	2043246.0
2018-07-23 13:00:00	MSFT	Stock	107.74	107.78	107.51	107.697	1794847.0
2018-07-23 14:00:00	MSFT	Stock	107.699	108.105	107.67	108.02	3003287.0
2018-07-23 15:00:00	MSFT	Stock	108.01	108.14	107.89	107.963	3763232.0
2018-07-23 16:00:00	MSFT	Stock	107.97	108.4	107.81	108.25	3535410.0
2018-07-23 17:00:00	MSFT	Stock	108.15	108.2	107.97	108.07	26695.0
2018-07-23 18:00:00	MSFT	Stock	108.09	108.15	108.07	108.1	16994.0
2018-07-23 19:00:00	MSFT	Stock	108.15	108.29	108.07	108.27	16624.0
2018-07-23 04:00:00	NVDA	Stock	6.2588	6.2588	6.2588	6.2588	10880.0
2018-07-23 07:00:00	NVDA	Stock	6.25	6.2525	6.2415	6.2525	64360.0
2018-07-23 08:00:00	NVDA	Stock	6.2525	6.2625	6.25	6.2595	178600.0
2018-07-23 09:00:00	NVDA	Stock	6.256	6.2722	6.082	6.118	64635200.0
2018-07-23 10:00:00	NVDA	Stock	6.118	6.2038	6.1108	6.1862	65461160.0
2018-07-23 11:00:00	NVDA	Stock	6.1878	6.2248	6.168	6.217	31133840.0
2018-07-23 12:00:00	NVDA	Stock	6.2161	6.2325	6.2033	6.2117	20016960.0
2018-07-23 13:00:00	NVDA	Stock	6.2123	6.245	6.2112	6.233	19946400.0
2018-07-23 14:00:00	NVDA	Stock	6.232	6.2405	6.225	6.2333	15115000.0
2018-07-23 15:00:00	NVDA	Stock	6.2312	6.2415	6.23	6.2345	20190480.0
2018-07-23 16:00:00	NVDA	Stock	6.2338	6.2662	6.232	6.246	27618400.0
2018-07-23 17:00:00	NVDA	Stock	6.2483	6.25	6.2353	6.239	127880.0
2018-07-23 18:00:00	NVDA	Stock	6.25	6.2563	6.249	6.2563	181200.0
2018-07-23 19:00:00	NVDA	Stock	6.2563	6.272	6.2563	6.2675	406600.0
2018-07-23 05:00:00	AMZN	Stock	90.5205	90.5205	90.5205	90.5205	2500.0
2018-07-23 07:00:00	AMZN	Stock	90.4115	90.5435	90.385	90.5435	155740.0
2018-07-23 08:00:00	AMZN	Stock	90.4995	90.95	90.451	90.85	334680.0
2018-07-23 09:00:00	AMZN	Stock	90.8125	90.95	88.4995	89.6935	25131140.0
2018-07-23 10:00:00	AMZN	Stock	89.6962	90.24	89.6591	90.075	14615800.0
2018-07-23 11:00:00	AMZN	Stock	90.0894	90.4145	89.8347	90.3553	8452580.0

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

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