PREVIEW / stock_1hour / 2019-01-15

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-01-15.parquet
  size:    1.1 MB
  rows:    49,134
  symbols: 2,697

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-01-15 04:00:00	AAPL	Stock	37.765	37.765	37.6	37.6	19464.0
2019-01-15 05:00:00	AAPL	Stock	37.7075	37.7075	37.625	37.6975	5416.0
2019-01-15 06:00:00	AAPL	Stock	37.69	37.7	37.6	37.6	23592.0
2019-01-15 07:00:00	AAPL	Stock	37.6	37.645	37.5775	37.6375	109312.0
2019-01-15 08:00:00	AAPL	Stock	37.65	37.6775	37.5275	37.53	326756.0
2019-01-15 09:00:00	AAPL	Stock	37.547	37.975	37.5025	37.89	13818244.0
2019-01-15 10:00:00	AAPL	Stock	37.89	38.1575	37.83	37.9725	16569332.0
2019-01-15 11:00:00	AAPL	Stock	37.9725	38.155	37.8325	38.135	9887580.0
2019-01-15 12:00:00	AAPL	Stock	38.133	38.2225	38.09	38.175	8927740.0
2019-01-15 13:00:00	AAPL	Stock	38.1775	38.2975	38.16	38.2678	8650844.0
2019-01-15 14:00:00	AAPL	Stock	38.2675	38.3475	37.96	38.165	11465608.0
2019-01-15 15:00:00	AAPL	Stock	38.165	38.3425	38.1475	38.2625	14783392.0
2019-01-15 16:00:00	AAPL	Stock	38.2675	38.3	38.1775	38.2275	7296320.0
2019-01-15 17:00:00	AAPL	Stock	38.225	38.275	38.225	38.25	38416.0
2019-01-15 18:00:00	AAPL	Stock	38.2375	38.3525	38.2375	38.335	122544.0
2019-01-15 19:00:00	AAPL	Stock	38.35	38.35	38.25	38.275	57848.0
2019-01-15 04:00:00	MSFT	Stock	102.97	102.97	102.59	102.59	800.0
2019-01-15 05:00:00	MSFT	Stock	102.7	102.7	102.31	102.5	3588.0
2019-01-15 06:00:00	MSFT	Stock	102.5	102.5	102.31	102.31	647.0
2019-01-15 07:00:00	MSFT	Stock	102.3	102.66	102.25	102.6	20055.0
2019-01-15 08:00:00	MSFT	Stock	102.4	102.8	102.26	102.62	52449.0
2019-01-15 09:00:00	MSFT	Stock	102.65	104.52	101.88	104.46	4487235.0
2019-01-15 10:00:00	MSFT	Stock	104.47	104.79	104.191	104.39	4895637.0
2019-01-15 11:00:00	MSFT	Stock	104.4	104.75	104.16	104.7	3187365.0
2019-01-15 12:00:00	MSFT	Stock	104.71	104.86	104.57	104.76	2211123.0
2019-01-15 13:00:00	MSFT	Stock	104.765	105.04	104.72	104.87	2350844.0
2019-01-15 14:00:00	MSFT	Stock	104.87	104.99	103.96	104.464	2919084.0
2019-01-15 15:00:00	MSFT	Stock	104.46	105.05	104.42	105.01	5224861.0
2019-01-15 16:00:00	MSFT	Stock	105.01	105.04	104.8	104.991	3484866.0
2019-01-15 17:00:00	MSFT	Stock	104.99	105.05	104.9	105.0	6279.0
2019-01-15 18:00:00	MSFT	Stock	105.05	105.24	105.0	105.12	5462.0
2019-01-15 19:00:00	MSFT	Stock	105.15	105.15	104.82	105.05	10854.0
2019-01-15 04:00:00	NVDA	Stock	3.79	3.8	3.7875	3.8	48280.0
2019-01-15 05:00:00	NVDA	Stock	3.8	3.82	3.8	3.81	49400.0
2019-01-15 06:00:00	NVDA	Stock	3.8125	3.8222	3.7892	3.7962	169480.0
2019-01-15 07:00:00	NVDA	Stock	3.8062	3.8062	3.7888	3.8	804360.0
2019-01-15 08:00:00	NVDA	Stock	3.795	3.8114	3.7895	3.7908	2059320.0
2019-01-15 09:00:00	NVDA	Stock	3.7925	3.8338	3.7752	3.799	118597120.0
2019-01-15 10:00:00	NVDA	Stock	3.8008	3.815	3.764	3.7888	131587440.0
2019-01-15 11:00:00	NVDA	Stock	3.7888	3.7983	3.7576	3.7689	80562040.0
2019-01-15 12:00:00	NVDA	Stock	3.7695	3.797	3.7664	3.786	52489320.0
2019-01-15 13:00:00	NVDA	Stock	3.7864	3.7975	3.7748	3.7828	37368160.0
2019-01-15 14:00:00	NVDA	Stock	3.781	3.794	3.7405	3.7556	63268440.0
2019-01-15 15:00:00	NVDA	Stock	3.7555	3.7568	3.7282	3.7465	83156320.0
2019-01-15 16:00:00	NVDA	Stock	3.7468	3.7538	3.735	3.7443	19047960.0
2019-01-15 17:00:00	NVDA	Stock	3.7472	3.7518	3.745	3.7478	191600.0
2019-01-15 18:00:00	NVDA	Stock	3.7518	3.7612	3.7478	3.7612	406920.0
2019-01-15 19:00:00	NVDA	Stock	3.7625	3.7625	3.75	3.75	337080.0
2019-01-15 04:00:00	AMZN	Stock	81.75	81.75	81.57	81.57	5440.0
2019-01-15 05:00:00	AMZN	Stock	81.542	81.5685	81.542	81.5685	4000.0

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

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