PREVIEW / stock_1hour / 2020-07-10

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-07-10.parquet
  size:    1.2 MB
  rows:    56,683
  symbols: 2,448

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-07-10 04:00:00	AAPL	Stock	95.22	95.5	95.18	95.195	26928.0
2020-07-10 05:00:00	AAPL	Stock	95.2425	95.4675	95.075	95.4	51552.0
2020-07-10 06:00:00	AAPL	Stock	95.4525	95.4525	95.3	95.3	7104.0
2020-07-10 07:00:00	AAPL	Stock	95.485	95.5425	95.25	95.2975	195320.0
2020-07-10 08:00:00	AAPL	Stock	95.4625	95.92	95.0625	95.475	364020.0
2020-07-10 09:00:00	AAPL	Stock	95.4968	95.8125	94.8625	94.9775	13592424.0
2020-07-10 10:00:00	AAPL	Stock	94.9875	95.5125	94.7053	95.3175	12927956.0
2020-07-10 11:00:00	AAPL	Stock	95.3125	95.6325	95.12	95.505	6930304.0
2020-07-10 12:00:00	AAPL	Stock	95.5225	95.5562	95.1075	95.2175	6340672.0
2020-07-10 13:00:00	AAPL	Stock	95.2225	95.495	95.175	95.3525	5846560.0
2020-07-10 14:00:00	AAPL	Stock	95.3575	95.8445	95.2775	95.84	6506180.0
2020-07-10 15:00:00	AAPL	Stock	95.835	95.98	95.6875	95.88	11109044.0
2020-07-10 16:00:00	AAPL	Stock	95.92	96.0475	95.6825	95.96	6803208.0
2020-07-10 17:00:00	AAPL	Stock	95.9875	95.9875	95.915	95.945	31168.0
2020-07-10 18:00:00	AAPL	Stock	95.9875	95.9975	95.8925	95.895	35984.0
2020-07-10 19:00:00	AAPL	Stock	95.895	95.98	95.88	95.925	57548.0
2020-07-10 04:00:00	MSFT	Stock	213.8	213.8	213.04	213.04	6467.0
2020-07-10 05:00:00	MSFT	Stock	213.2	213.6	213.2	213.6	2644.0
2020-07-10 06:00:00	MSFT	Stock	213.6	213.85	213.51	213.6	8387.0
2020-07-10 07:00:00	MSFT	Stock	213.7	213.9	212.5	212.8	43847.0
2020-07-10 08:00:00	MSFT	Stock	213.989	213.989	212.5	213.75	60398.0
2020-07-10 09:00:00	MSFT	Stock	213.89	214.32	211.19	212.17	3964884.0
2020-07-10 10:00:00	MSFT	Stock	212.15	212.95	211.08	212.59	3522798.0
2020-07-10 11:00:00	MSFT	Stock	212.59	213.49	211.99	212.92	2455966.0
2020-07-10 12:00:00	MSFT	Stock	212.91	213.34	212.34	213.01	1885000.0
2020-07-10 13:00:00	MSFT	Stock	213.02	213.57	212.905	213.09	1759138.0
2020-07-10 14:00:00	MSFT	Stock	213.1	213.675	212.873	213.675	1796591.0
2020-07-10 15:00:00	MSFT	Stock	213.67	213.9	212.92	213.65	4157699.0
2020-07-10 16:00:00	MSFT	Stock	213.7	214.1	213.6	213.84	2061524.0
2020-07-10 17:00:00	MSFT	Stock	213.84	213.92	213.8	213.84	8838.0
2020-07-10 18:00:00	MSFT	Stock	213.94	214.1	213.9	214.05	8142.0
2020-07-10 19:00:00	MSFT	Stock	214.05	214.24	214.0	214.24	13010.0
2020-07-10 04:00:00	NVDA	Stock	10.4505	10.4505	10.4282	10.4375	42560.0
2020-07-10 05:00:00	NVDA	Stock	10.4525	10.4525	10.4525	10.4525	4000.0
2020-07-10 06:00:00	NVDA	Stock	10.4993	10.5078	10.4993	10.5078	24000.0
2020-07-10 07:00:00	NVDA	Stock	10.5138	10.617	10.5	10.5075	976560.0
2020-07-10 08:00:00	NVDA	Stock	10.5732	10.6188	10.463	10.5628	2515760.0
2020-07-10 09:00:00	NVDA	Stock	10.584	10.6552	10.3788	10.459	80209440.0
2020-07-10 10:00:00	NVDA	Stock	10.4575	10.5867	10.3895	10.4975	68267800.0
2020-07-10 11:00:00	NVDA	Stock	10.4955	10.6168	10.475	10.5594	48797560.0
2020-07-10 12:00:00	NVDA	Stock	10.5575	10.5645	10.4775	10.4988	42359280.0
2020-07-10 13:00:00	NVDA	Stock	10.5	10.5344	10.4728	10.4888	30824360.0
2020-07-10 14:00:00	NVDA	Stock	10.4892	10.5025	10.4092	10.4501	39632880.0
2020-07-10 15:00:00	NVDA	Stock	10.448	10.4975	10.4315	10.4795	45622520.0
2020-07-10 16:00:00	NVDA	Stock	10.4792	10.4925	10.4688	10.4838	21351760.0
2020-07-10 17:00:00	NVDA	Stock	10.4825	10.4938	10.4825	10.4938	166240.0
2020-07-10 18:00:00	NVDA	Stock	10.4938	10.4938	10.4888	10.4938	102520.0
2020-07-10 19:00:00	NVDA	Stock	10.4938	10.4938	10.49	10.4903	110400.0
2020-07-10 04:00:00	AMZN	Stock	159.0325	159.0325	158.565	158.565	17780.0
2020-07-10 05:00:00	AMZN	Stock	158.6	158.816	158.6	158.75	24000.0

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

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