PREVIEW / stock_1hour / 2020-02-27

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-02-27.parquet
  size:    1.2 MB
  rows:    55,785
  symbols: 2,453

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-27 04:00:00	AAPL	Stock	72.275	72.875	72.25	72.25	136664.0
2020-02-27 05:00:00	AAPL	Stock	72.4075	72.5	72.0025	72.0025	77540.0
2020-02-27 06:00:00	AAPL	Stock	71.99	72.1625	71.8075	71.8125	63456.0
2020-02-27 07:00:00	AAPL	Stock	71.95	72.0	70.8625	70.8725	878876.0
2020-02-27 08:00:00	AAPL	Stock	72.0	72.0	70.54	70.8875	1601588.0
2020-02-27 09:00:00	AAPL	Stock	70.88	71.5	70.0	70.7225	38357328.0
2020-02-27 10:00:00	AAPL	Stock	70.7075	71.0325	68.435	70.2975	56231440.0
2020-02-27 11:00:00	AAPL	Stock	70.2875	71.1225	69.505	70.5128	33585884.0
2020-02-27 12:00:00	AAPL	Stock	70.505	71.4125	70.1525	70.57	29260132.0
2020-02-27 13:00:00	AAPL	Stock	70.565	71.055	69.7125	70.1458	22092992.0
2020-02-27 14:00:00	AAPL	Stock	70.1125	70.255	69.5112	69.56	18129788.0
2020-02-27 15:00:00	AAPL	Stock	69.5588	70.19	68.24	68.26	39947096.0
2020-02-27 16:00:00	AAPL	Stock	68.38	68.6625	67.45	67.525	19973256.0
2020-02-27 17:00:00	AAPL	Stock	67.4675	68.38	67.45	67.5375	479768.0
2020-02-27 18:00:00	AAPL	Stock	67.5375	68.11	67.25	68.0	550468.0
2020-02-27 19:00:00	AAPL	Stock	68.0	68.11	67.375	67.725	772712.0
2020-02-27 04:00:00	MSFT	Stock	166.77	168.36	166.1	167.0	23498.0
2020-02-27 05:00:00	MSFT	Stock	167.48	167.48	166.15	166.2	21499.0
2020-02-27 06:00:00	MSFT	Stock	166.2	166.5	165.77	165.77	24169.0
2020-02-27 07:00:00	MSFT	Stock	165.75	166.0	163.32	163.5	307740.0
2020-02-27 08:00:00	MSFT	Stock	165.55	170.17	162.2	163.45	526296.0
2020-02-27 09:00:00	MSFT	Stock	163.64	166.66	162.5	165.97	11802536.0
2020-02-27 10:00:00	MSFT	Stock	165.94	166.45	161.86	164.95	13196887.0
2020-02-27 11:00:00	MSFT	Stock	164.91	166.465	163.409	165.092	8655878.0
2020-02-27 12:00:00	MSFT	Stock	165.08	167.03	164.24	165.58	6950833.0
2020-02-27 13:00:00	MSFT	Stock	165.57	166.49	163.03	163.441	6717079.0
2020-02-27 14:00:00	MSFT	Stock	163.43	163.66	161.71	161.87	6432797.0
2020-02-27 15:00:00	MSFT	Stock	161.88	162.71	157.98	158.0	15349260.0
2020-02-27 16:00:00	MSFT	Stock	158.02	163.04	156.52	156.52	8085241.0
2020-02-27 17:00:00	MSFT	Stock	156.58	158.18	156.25	156.6	103623.0
2020-02-27 18:00:00	MSFT	Stock	156.6	158.0	156.02	157.76	68298.0
2020-02-27 19:00:00	MSFT	Stock	157.97	158.67	157.36	157.45	72969.0
2020-02-27 04:00:00	NVDA	Stock	6.5975	6.6375	6.5898	6.619	275240.0
2020-02-27 05:00:00	NVDA	Stock	6.605	6.614	6.575	6.575	92920.0
2020-02-27 06:00:00	NVDA	Stock	6.563	6.605	6.563	6.5975	232800.0
2020-02-27 07:00:00	NVDA	Stock	6.575	6.5858	6.4498	6.45	2423920.0
2020-02-27 08:00:00	NVDA	Stock	6.575	6.581	6.3525	6.41	5964760.0
2020-02-27 09:00:00	NVDA	Stock	6.3928	6.532	6.325	6.4135	131910160.0
2020-02-27 10:00:00	NVDA	Stock	6.4104	6.4503	6.2222	6.3938	176033960.0
2020-02-27 11:00:00	NVDA	Stock	6.392	6.4972	6.3615	6.4823	104520120.0
2020-02-27 12:00:00	NVDA	Stock	6.483	6.6665	6.4475	6.5831	134327400.0
2020-02-27 13:00:00	NVDA	Stock	6.5808	6.675	6.4533	6.5177	89203280.0
2020-02-27 14:00:00	NVDA	Stock	6.5135	6.5585	6.4662	6.4968	64158280.0
2020-02-27 15:00:00	NVDA	Stock	6.4956	6.5438	6.304	6.3048	146477840.0
2020-02-27 16:00:00	NVDA	Stock	6.315	6.315	6.2	6.2	14728520.0
2020-02-27 17:00:00	NVDA	Stock	6.2	6.315	6.1845	6.196	2064000.0
2020-02-27 18:00:00	NVDA	Stock	6.1895	6.2975	6.1815	6.2975	2538720.0
2020-02-27 19:00:00	NVDA	Stock	6.2985	6.3125	6.2638	6.2875	848240.0
2020-02-27 04:00:00	AMZN	Stock	98.15	98.398	98.15	98.263	12340.0
2020-02-27 05:00:00	AMZN	Stock	98.29	98.3055	98.25	98.3055	35400.0

> showing 50 of 55,785 rows — these rows as CSV

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