PREVIEW / stock_1hour / 2020-02-26

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-02-26.parquet
  size:    1.2 MB
  rows:    53,507
  symbols: 2,442

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-26 04:00:00	AAPL	Stock	71.325	71.325	70.36	71.0	250976.0
2020-02-26 05:00:00	AAPL	Stock	71.075	71.8625	71.0225	71.5	110656.0
2020-02-26 06:00:00	AAPL	Stock	71.375	72.445	71.375	71.8775	117792.0
2020-02-26 07:00:00	AAPL	Stock	71.9025	72.175	71.4	71.9	415696.0
2020-02-26 08:00:00	AAPL	Stock	71.8875	72.525	71.4	72.1125	922988.0
2020-02-26 09:00:00	AAPL	Stock	72.15	73.36	71.3375	73.035	30128708.0
2020-02-26 10:00:00	AAPL	Stock	73.0225	74.4275	72.6535	74.09	30043752.0
2020-02-26 11:00:00	AAPL	Stock	74.08	74.47	73.5825	73.6512	19086288.0
2020-02-26 12:00:00	AAPL	Stock	73.6525	73.735	72.5775	73.4257	20538828.0
2020-02-26 13:00:00	AAPL	Stock	73.4325	73.7075	72.305	72.695	18637608.0
2020-02-26 14:00:00	AAPL	Stock	72.675	73.305	72.555	72.8575	14413452.0
2020-02-26 15:00:00	AAPL	Stock	72.8632	73.535	72.8632	73.1725	18465932.0
2020-02-26 16:00:00	AAPL	Stock	73.1625	74.395	72.725	72.73	11288892.0
2020-02-26 17:00:00	AAPL	Stock	72.745	72.8225	72.625	72.65	128856.0
2020-02-26 18:00:00	AAPL	Stock	72.625	73.0	72.3875	72.625	348752.0
2020-02-26 19:00:00	AAPL	Stock	72.565	72.825	72.0175	72.575	261604.0
2020-02-26 04:00:00	MSFT	Stock	166.0	166.7	163.31	166.08	59859.0
2020-02-26 05:00:00	MSFT	Stock	165.87	168.3	165.5	166.53	45283.0
2020-02-26 06:00:00	MSFT	Stock	166.14	169.2	166.14	168.5	54913.0
2020-02-26 07:00:00	MSFT	Stock	168.21	168.64	166.68	168.02	115629.0
2020-02-26 08:00:00	MSFT	Stock	167.751	169.84	167.0	168.7	171816.0
2020-02-26 09:00:00	MSFT	Stock	168.8	172.55	168.7	171.21	8110079.0
2020-02-26 10:00:00	MSFT	Stock	171.19	173.26	170.57	172.714	7392124.0
2020-02-26 11:00:00	MSFT	Stock	172.7	172.98	171.22	171.4	4335699.0
2020-02-26 12:00:00	MSFT	Stock	171.41	171.63	169.16	170.69	4976619.0
2020-02-26 13:00:00	MSFT	Stock	170.7	171.07	168.21	168.85	4541613.0
2020-02-26 14:00:00	MSFT	Stock	168.84	170.52	168.5	169.3	4359652.0
2020-02-26 15:00:00	MSFT	Stock	169.35	171.145	169.34	170.16	5984773.0
2020-02-26 16:00:00	MSFT	Stock	170.17	172.785	165.8	168.03	6026769.0
2020-02-26 17:00:00	MSFT	Stock	168.1	168.4	166.64	167.25	227740.0
2020-02-26 18:00:00	MSFT	Stock	167.36	168.2	167.0	167.2	76601.0
2020-02-26 19:00:00	MSFT	Stock	167.45	167.64	166.1	166.8	102207.0
2020-02-26 04:00:00	NVDA	Stock	6.39	6.475	6.3638	6.454	828200.0
2020-02-26 05:00:00	NVDA	Stock	6.464	6.524	6.449	6.4625	335400.0
2020-02-26 06:00:00	NVDA	Stock	6.4725	6.597	6.4725	6.5275	303600.0
2020-02-26 07:00:00	NVDA	Stock	6.5068	6.5442	6.4362	6.5175	2021560.0
2020-02-26 08:00:00	NVDA	Stock	6.5305	6.5925	6.431	6.5312	4315760.0
2020-02-26 09:00:00	NVDA	Stock	6.5375	6.7725	6.525	6.7249	142748440.0
2020-02-26 10:00:00	NVDA	Stock	6.7225	6.8812	6.6892	6.8609	164726920.0
2020-02-26 11:00:00	NVDA	Stock	6.8595	6.8862	6.7465	6.7662	101269480.0
2020-02-26 12:00:00	NVDA	Stock	6.7683	6.779	6.6442	6.7382	98147480.0
2020-02-26 13:00:00	NVDA	Stock	6.739	6.7625	6.629	6.672	53450240.0
2020-02-26 14:00:00	NVDA	Stock	6.6678	6.7248	6.6558	6.6696	39684960.0
2020-02-26 15:00:00	NVDA	Stock	6.67	6.7512	6.67	6.6898	60273560.0
2020-02-26 16:00:00	NVDA	Stock	6.6912	6.8629	6.6318	6.6375	22927280.0
2020-02-26 17:00:00	NVDA	Stock	6.638	6.6472	6.63	6.6375	264880.0
2020-02-26 18:00:00	NVDA	Stock	6.6252	6.675	6.6155	6.66	1097080.0
2020-02-26 19:00:00	NVDA	Stock	6.66	6.66	6.5832	6.625	491920.0
2020-02-26 04:00:00	AMZN	Stock	97.85	97.85	96.9	97.25	149840.0
2020-02-26 05:00:00	AMZN	Stock	97.75	97.75	97.7055	97.7055	28800.0

> showing 50 of 53,507 rows — these rows as CSV

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