PREVIEW / stock_1hour / 2020-02-28

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-02-28.parquet
  size:    1.2 MB
  rows:    56,526
  symbols: 2,468

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
2020-02-28 04:00:00	AAPL	Stock	66.2	66.3425	65.375	65.9725	534736.0
2020-02-28 05:00:00	AAPL	Stock	66.0	66.6125	65.75	66.4875	468220.0
2020-02-28 06:00:00	AAPL	Stock	66.47	66.85	66.125	66.5975	524504.0
2020-02-28 07:00:00	AAPL	Stock	66.45	67.3375	66.125	66.9075	1153192.0
2020-02-28 08:00:00	AAPL	Stock	67.0	67.2725	65.25	65.25	2729228.0
2020-02-28 09:00:00	AAPL	Stock	65.25	66.3125	64.0925	65.1225	61869756.0
2020-02-28 10:00:00	AAPL	Stock	65.105	67.1925	64.2725	67.125	62493036.0
2020-02-28 11:00:00	AAPL	Stock	67.1225	69.6025	66.04	67.5375	52268316.0
2020-02-28 12:00:00	AAPL	Stock	67.5	68.68	66.755	68.487	30443612.0
2020-02-28 13:00:00	AAPL	Stock	68.483	68.795	66.31	66.73	27167844.0
2020-02-28 14:00:00	AAPL	Stock	66.72	68.12	65.915	67.2205	31861204.0
2020-02-28 15:00:00	AAPL	Stock	67.245	68.6625	66.4175	68.66	42891336.0
2020-02-28 16:00:00	AAPL	Stock	68.6575	68.995	66.7475	68.83	28048844.0
2020-02-28 17:00:00	AAPL	Stock	68.8125	68.875	68.64	68.875	274612.0
2020-02-28 18:00:00	AAPL	Stock	68.875	69.0625	68.8575	68.9375	184632.0
2020-02-28 19:00:00	AAPL	Stock	68.95	68.96	68.6875	68.775	154100.0
2020-02-28 04:00:00	MSFT	Stock	154.8	154.8	151.8	152.62	116869.0
2020-02-28 05:00:00	MSFT	Stock	152.88	155.15	152.8	155.15	62602.0
2020-02-28 06:00:00	MSFT	Stock	155.1	156.65	155.1	155.25	46945.0
2020-02-28 07:00:00	MSFT	Stock	155.56	156.75	154.23	155.25	296525.0
2020-02-28 08:00:00	MSFT	Stock	155.59	156.72	152.3	152.523	635281.0
2020-02-28 09:00:00	MSFT	Stock	152.6	157.6	152.0	154.7	15008783.0
2020-02-28 10:00:00	MSFT	Stock	154.75	158.6	153.65	158.54	12687008.0
2020-02-28 11:00:00	MSFT	Stock	158.53	163.71	156.0	159.34	11365697.0
2020-02-28 12:00:00	MSFT	Stock	159.31	162.1	158.1	161.93	6279923.0
2020-02-28 13:00:00	MSFT	Stock	161.9	162.55	157.12	158.029	6235936.0
2020-02-28 14:00:00	MSFT	Stock	157.98	161.46	156.57	159.01	6978975.0
2020-02-28 15:00:00	MSFT	Stock	159.01	162.33	157.2	162.11	12619204.0
2020-02-28 16:00:00	MSFT	Stock	162.11	164.3	158.467	163.0	10059242.0
2020-02-28 17:00:00	MSFT	Stock	163.0	163.5	162.62	163.33	60916.0
2020-02-28 18:00:00	MSFT	Stock	163.45	163.85	163.33	163.33	25999.0
2020-02-28 19:00:00	MSFT	Stock	163.5	163.85	163.1	163.85	22485.0
2020-02-28 04:00:00	NVDA	Stock	6.0925	6.1398	6.0	6.1	2236800.0
2020-02-28 05:00:00	NVDA	Stock	6.0825	6.1748	6.0825	6.1375	328160.0
2020-02-28 06:00:00	NVDA	Stock	6.1488	6.2	6.1352	6.179	372280.0
2020-02-28 07:00:00	NVDA	Stock	6.195	6.2722	6.1485	6.2055	2197600.0
2020-02-28 08:00:00	NVDA	Stock	6.2	6.264	6.0813	6.093	6134360.0
2020-02-28 09:00:00	NVDA	Stock	6.0928	6.2845	6.0188	6.195	138740960.0
2020-02-28 10:00:00	NVDA	Stock	6.2001	6.4963	6.1585	6.4938	173493200.0
2020-02-28 11:00:00	NVDA	Stock	6.4908	6.8115	6.3945	6.6175	198853040.0
2020-02-28 12:00:00	NVDA	Stock	6.6173	6.6682	6.4453	6.6622	98138200.0
2020-02-28 13:00:00	NVDA	Stock	6.6605	6.7172	6.404	6.474	83396120.0
2020-02-28 14:00:00	NVDA	Stock	6.4722	6.6457	6.4125	6.5249	93513560.0
2020-02-28 15:00:00	NVDA	Stock	6.528	6.754	6.446	6.754	132169200.0
2020-02-28 16:00:00	NVDA	Stock	6.7518	6.8085	6.7165	6.7875	62441960.0
2020-02-28 17:00:00	NVDA	Stock	6.7875	6.795	6.7675	6.7875	1636320.0
2020-02-28 18:00:00	NVDA	Stock	6.7875	6.795	6.7812	6.793	709680.0
2020-02-28 19:00:00	NVDA	Stock	6.794	6.795	6.7838	6.7925	368520.0
2020-02-28 04:00:00	AMZN	Stock	91.865	91.865	90.5175	90.75	387100.0
2020-02-28 05:00:00	AMZN	Stock	91.0	91.7585	90.85	91.7585	76840.0

> showing 50 of 56,526 rows — these rows as CSV

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