PREVIEW / stock_1hour / 2020-01-23

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-01-23.parquet
  size:    1.2 MB
  rows:    50,910
  symbols: 2,456

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-01-23 04:00:00	AAPL	Stock	79.25	79.38	79.25	79.2775	10060.0
2020-01-23 05:00:00	AAPL	Stock	79.2875	79.5	79.2875	79.455	7304.0
2020-01-23 06:00:00	AAPL	Stock	79.5	79.535	79.425	79.425	24092.0
2020-01-23 07:00:00	AAPL	Stock	79.5	79.5625	79.335	79.3525	185704.0
2020-01-23 08:00:00	AAPL	Stock	79.5748	79.5825	79.275	79.315	446516.0
2020-01-23 09:00:00	AAPL	Stock	79.3175	79.6225	78.9125	79.2825	13282816.0
2020-01-23 10:00:00	AAPL	Stock	79.2675	79.53	79.0725	79.3325	12935892.0
2020-01-23 11:00:00	AAPL	Stock	79.3375	79.4775	79.2275	79.3775	8444364.0
2020-01-23 12:00:00	AAPL	Stock	79.375	79.5488	79.3192	79.4287	4626732.0
2020-01-23 13:00:00	AAPL	Stock	79.425	79.7225	79.35	79.685	6927344.0
2020-01-23 14:00:00	AAPL	Stock	79.6825	79.8125	79.6348	79.81	7054588.0
2020-01-23 15:00:00	AAPL	Stock	79.8052	79.89	79.65	79.8225	13276460.0
2020-01-23 16:00:00	AAPL	Stock	79.8075	79.9	79.8075	79.845	11944232.0
2020-01-23 17:00:00	AAPL	Stock	79.845	79.8975	79.835	79.885	77872.0
2020-01-23 18:00:00	AAPL	Stock	79.875	79.9375	79.8625	79.9125	144352.0
2020-01-23 19:00:00	AAPL	Stock	79.925	79.9375	79.8875	79.895	72364.0
2020-01-23 04:00:00	MSFT	Stock	165.72	165.97	165.72	165.97	1261.0
2020-01-23 05:00:00	MSFT	Stock	165.9	165.97	165.9	165.97	200.0
2020-01-23 06:00:00	MSFT	Stock	166.05	166.15	166.05	166.1	600.0
2020-01-23 07:00:00	MSFT	Stock	166.11	166.14	165.6	165.72	9976.0
2020-01-23 08:00:00	MSFT	Stock	166.0	166.07	165.49	165.7	43970.0
2020-01-23 09:00:00	MSFT	Stock	165.7	166.35	165.27	166.2	2192556.0
2020-01-23 10:00:00	MSFT	Stock	166.19	166.62	166.021	166.22	2038113.0
2020-01-23 11:00:00	MSFT	Stock	166.21	166.34	165.61	165.97	1331931.0
2020-01-23 12:00:00	MSFT	Stock	165.946	166.23	165.875	165.91	916792.0
2020-01-23 13:00:00	MSFT	Stock	165.916	166.22	165.8	166.1	833831.0
2020-01-23 14:00:00	MSFT	Stock	166.095	166.35	166.09	166.335	1107110.0
2020-01-23 15:00:00	MSFT	Stock	166.335	166.8	166.17	166.72	2451743.0
2020-01-23 16:00:00	MSFT	Stock	166.72	167.3	166.31	167.02	5387803.0
2020-01-23 17:00:00	MSFT	Stock	167.1	167.15	167.02	167.1	8041.0
2020-01-23 18:00:00	MSFT	Stock	167.1	167.25	167.1	167.2	30442.0
2020-01-23 19:00:00	MSFT	Stock	167.22	167.42	167.21	167.35	9698.0
2020-01-23 04:00:00	NVDA	Stock	6.2725	6.28	6.2725	6.28	18280.0
2020-01-23 05:00:00	NVDA	Stock	6.2922	6.2922	6.2922	6.2922	16000.0
2020-01-23 06:00:00	NVDA	Stock	6.295	6.295	6.292	6.2938	98280.0
2020-01-23 07:00:00	NVDA	Stock	6.2875	6.295	6.2588	6.275	586600.0
2020-01-23 08:00:00	NVDA	Stock	6.295	6.305	6.2641	6.295	1140160.0
2020-01-23 09:00:00	NVDA	Stock	6.2955	6.298	6.2038	6.2323	38931000.0
2020-01-23 10:00:00	NVDA	Stock	6.2303	6.2825	6.2213	6.2498	36849960.0
2020-01-23 11:00:00	NVDA	Stock	6.248	6.268	6.2378	6.268	17371880.0
2020-01-23 12:00:00	NVDA	Stock	6.268	6.2952	6.2602	6.2727	17547080.0
2020-01-23 13:00:00	NVDA	Stock	6.274	6.3115	6.2703	6.3082	19941760.0
2020-01-23 14:00:00	NVDA	Stock	6.3084	6.3298	6.3072	6.3275	20455400.0
2020-01-23 15:00:00	NVDA	Stock	6.3272	6.33	6.3115	6.3198	25272080.0
2020-01-23 16:00:00	NVDA	Stock	6.3215	6.424	6.3215	6.3968	25243200.0
2020-01-23 17:00:00	NVDA	Stock	6.3925	6.4125	6.3925	6.4088	565440.0
2020-01-23 18:00:00	NVDA	Stock	6.4075	6.417	6.3998	6.3998	354800.0
2020-01-23 19:00:00	NVDA	Stock	6.3998	6.409	6.3938	6.4075	263760.0
2020-01-23 07:00:00	AMZN	Stock	94.376	94.376	94.25	94.25	28000.0
2020-01-23 08:00:00	AMZN	Stock	94.3505	94.3505	94.2	94.35	41920.0

> showing 50 of 50,910 rows — these rows as CSV

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