PREVIEW / stock_1hour / 2020-07-22

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-07-22.parquet
  size:    1.2 MB
  rows:    57,088
  symbols: 2,440

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-22 04:00:00	AAPL	Stock	96.7525	96.7525	96.4	96.55	76768.0
2020-07-22 05:00:00	AAPL	Stock	96.5475	97.0	96.425	96.995	42580.0
2020-07-22 06:00:00	AAPL	Stock	96.975	97.415	96.975	97.345	35312.0
2020-07-22 07:00:00	AAPL	Stock	97.4225	97.4425	97.25	97.25	121596.0
2020-07-22 08:00:00	AAPL	Stock	97.3	97.4835	97.083	97.18	364056.0
2020-07-22 09:00:00	AAPL	Stock	97.1725	97.8075	96.66	97.6575	13073432.0
2020-07-22 10:00:00	AAPL	Stock	97.675	97.975	96.8925	97.1075	13839660.0
2020-07-22 11:00:00	AAPL	Stock	97.1	97.345	96.77	97.095	7855488.0
2020-07-22 12:00:00	AAPL	Stock	97.1025	97.2725	96.845	97.0112	4944124.0
2020-07-22 13:00:00	AAPL	Stock	96.9975	97.12	96.6025	96.655	5700724.0
2020-07-22 14:00:00	AAPL	Stock	96.66	97.0	96.6435	96.79	5243156.0
2020-07-22 15:00:00	AAPL	Stock	96.8	97.4625	96.79	97.2725	9609504.0
2020-07-22 16:00:00	AAPL	Stock	97.2725	97.3125	96.875	97.1375	7122532.0
2020-07-22 17:00:00	AAPL	Stock	97.1875	97.2725	97.05	97.065	467480.0
2020-07-22 18:00:00	AAPL	Stock	97.1	97.25	97.1	97.1875	35640.0
2020-07-22 19:00:00	AAPL	Stock	97.145	97.15	97.0	97.075	68848.0
2020-07-22 04:00:00	MSFT	Stock	210.0	210.0	208.6	209.05	9965.0
2020-07-22 05:00:00	MSFT	Stock	209.2	210.3	208.93	210.02	5198.0
2020-07-22 06:00:00	MSFT	Stock	210.02	210.8	210.0	210.66	17131.0
2020-07-22 07:00:00	MSFT	Stock	210.64	211.27	210.45	210.55	64915.0
2020-07-22 08:00:00	MSFT	Stock	211.0	211.3	209.62	209.929	193363.0
2020-07-22 09:00:00	MSFT	Stock	209.97	211.335	208.708	210.41	4749994.0
2020-07-22 10:00:00	MSFT	Stock	210.425	211.63	208.39	209.47	4565949.0
2020-07-22 11:00:00	MSFT	Stock	209.44	210.74	209.04	210.5	3630803.0
2020-07-22 12:00:00	MSFT	Stock	210.5	211.75	210.23	210.95	3937054.0
2020-07-22 13:00:00	MSFT	Stock	210.925	210.97	209.421	209.64	4197016.0
2020-07-22 14:00:00	MSFT	Stock	209.65	211.03	209.619	210.558	4310005.0
2020-07-22 15:00:00	MSFT	Stock	210.575	212.3	210.52	211.753	7520784.0
2020-07-22 16:00:00	MSFT	Stock	211.75	212.65	204.52	206.15	6960189.0
2020-07-22 17:00:00	MSFT	Stock	206.15	211.75	205.75	206.1	1092488.0
2020-07-22 18:00:00	MSFT	Stock	206.12	208.0	205.72	206.88	618270.0
2020-07-22 19:00:00	MSFT	Stock	206.95	207.22	206.35	207.01	206012.0
2020-07-22 04:00:00	NVDA	Stock	10.2905	10.2905	10.2775	10.2775	36000.0
2020-07-22 06:00:00	NVDA	Stock	10.355	10.355	10.355	10.355	12000.0
2020-07-22 07:00:00	NVDA	Stock	10.3625	10.3813	10.3625	10.3688	242960.0
2020-07-22 08:00:00	NVDA	Stock	10.367	10.4178	10.3375	10.375	481200.0
2020-07-22 09:00:00	NVDA	Stock	10.4122	10.581	10.3285	10.5599	55145920.0
2020-07-22 10:00:00	NVDA	Stock	10.5638	10.6025	10.4138	10.4295	91575680.0
2020-07-22 11:00:00	NVDA	Stock	10.4268	10.4898	10.3426	10.4642	60920440.0
2020-07-22 12:00:00	NVDA	Stock	10.4662	10.4865	10.4045	10.4284	27315840.0
2020-07-22 13:00:00	NVDA	Stock	10.425	10.4513	10.364	10.3753	28529680.0
2020-07-22 14:00:00	NVDA	Stock	10.3775	10.436	10.2916	10.3913	50133880.0
2020-07-22 15:00:00	NVDA	Stock	10.394	10.4585	10.39	10.4435	39264440.0
2020-07-22 16:00:00	NVDA	Stock	10.4388	10.4448	10.375	10.4175	2096080.0
2020-07-22 17:00:00	NVDA	Stock	10.4325	10.4388	10.425	10.4388	827560.0
2020-07-22 18:00:00	NVDA	Stock	10.4345	10.4488	10.4275	10.4438	283040.0
2020-07-22 19:00:00	NVDA	Stock	10.4378	10.4408	10.425	10.425	381240.0
2020-07-22 05:00:00	AMZN	Stock	156.7	156.8	156.7	156.8	7500.0
2020-07-22 07:00:00	AMZN	Stock	157.599	158.25	157.405	157.4745	380480.0
2020-07-22 08:00:00	AMZN	Stock	157.5	158.2	156.9038	157.1625	526300.0

> showing 50 of 57,088 rows — these rows as CSV

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