PREVIEW / stock_1hour / 2020-04-29

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-04-29.parquet
  size:    1.2 MB
  rows:    56,204
  symbols: 2,408

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-04-29 04:00:00	AAPL	Stock	70.58	70.7	70.5025	70.7	8552.0
2020-04-29 05:00:00	AAPL	Stock	70.63	70.63	70.5	70.5	18544.0
2020-04-29 06:00:00	AAPL	Stock	70.375	70.375	70.275	70.375	20500.0
2020-04-29 07:00:00	AAPL	Stock	70.3275	70.45	70.125	70.25	166348.0
2020-04-29 08:00:00	AAPL	Stock	70.4488	71.4025	70.125	71.4025	968100.0
2020-04-29 09:00:00	AAPL	Stock	71.42	72.01	70.9725	71.725	19333056.0
2020-04-29 10:00:00	AAPL	Stock	71.725	72.4175	71.6175	71.9562	19962076.0
2020-04-29 11:00:00	AAPL	Stock	71.9562	72.04	71.6875	71.7192	11185240.0
2020-04-29 12:00:00	AAPL	Stock	71.72	71.995	71.6825	71.7975	7897400.0
2020-04-29 13:00:00	AAPL	Stock	71.7975	72.005	71.65	71.7755	7985712.0
2020-04-29 14:00:00	AAPL	Stock	71.7825	72.1575	71.5825	72.1225	10645060.0
2020-04-29 15:00:00	AAPL	Stock	72.1125	72.3325	71.8325	71.9575	16581336.0
2020-04-29 16:00:00	AAPL	Stock	71.8675	72.6875	71.75	72.62	9697568.0
2020-04-29 17:00:00	AAPL	Stock	72.625	73.1225	72.625	72.9475	582776.0
2020-04-29 18:00:00	AAPL	Stock	72.9525	73.0	72.755	72.925	234916.0
2020-04-29 19:00:00	AAPL	Stock	72.9	73.095	72.83	73.075	221268.0
2020-04-29 04:00:00	MSFT	Stock	173.3	173.9	172.85	173.88	11779.0
2020-04-29 05:00:00	MSFT	Stock	173.78	173.8	173.11	173.11	8871.0
2020-04-29 06:00:00	MSFT	Stock	173.11	173.4	172.66	173.02	12095.0
2020-04-29 07:00:00	MSFT	Stock	173.22	173.24	171.8	172.35	108102.0
2020-04-29 08:00:00	MSFT	Stock	173.01	173.8	171.8	173.8	257040.0
2020-04-29 09:00:00	MSFT	Stock	173.8	174.52	171.88	173.98	5293915.0
2020-04-29 10:00:00	MSFT	Stock	173.97	175.18	173.5	174.32	4912238.0
2020-04-29 11:00:00	MSFT	Stock	174.32	175.025	174.1	174.86	3365085.0
2020-04-29 12:00:00	MSFT	Stock	174.86	176.17	174.86	175.893	4098448.0
2020-04-29 13:00:00	MSFT	Stock	175.895	176.45	175.59	176.25	3286515.0
2020-04-29 14:00:00	MSFT	Stock	176.28	176.56	175.16	176.415	3770795.0
2020-04-29 15:00:00	MSFT	Stock	176.42	177.68	176.19	177.3	8282954.0
2020-04-29 16:00:00	MSFT	Stock	177.35	186.52	175.473	185.4	8273562.0
2020-04-29 17:00:00	MSFT	Stock	185.4	185.4	181.15	181.5	685974.0
2020-04-29 18:00:00	MSFT	Stock	181.99	183.25	179.8	181.7	511178.0
2020-04-29 19:00:00	MSFT	Stock	181.6	182.0	181.05	181.25	192442.0
2020-04-29 06:00:00	NVDA	Stock	7.3062	7.3062	7.3028	7.3028	12000.0
2020-04-29 07:00:00	NVDA	Stock	7.35	7.3662	7.322	7.3298	464720.0
2020-04-29 08:00:00	NVDA	Stock	7.3359	7.4345	7.3105	7.434	1844360.0
2020-04-29 09:00:00	NVDA	Stock	7.4275	7.4463	7.3438	7.4308	49761200.0
2020-04-29 10:00:00	NVDA	Stock	7.4299	7.4856	7.362	7.4755	70825960.0
2020-04-29 11:00:00	NVDA	Stock	7.478	7.5145	7.447	7.4713	38878200.0
2020-04-29 12:00:00	NVDA	Stock	7.4724	7.4922	7.4528	7.4618	24225920.0
2020-04-29 13:00:00	NVDA	Stock	7.462	7.4743	7.3912	7.4468	34101160.0
2020-04-29 14:00:00	NVDA	Stock	7.4495	7.502	7.4149	7.5006	35004240.0
2020-04-29 15:00:00	NVDA	Stock	7.5018	7.5088	7.4402	7.4605	54900360.0
2020-04-29 16:00:00	NVDA	Stock	7.4615	7.52	7.4615	7.5082	40613200.0
2020-04-29 17:00:00	NVDA	Stock	7.5195	7.5198	7.4615	7.5075	490640.0
2020-04-29 18:00:00	NVDA	Stock	7.5148	7.5188	7.5	7.505	401920.0
2020-04-29 19:00:00	NVDA	Stock	7.5018	7.5215	7.495	7.52	423640.0
2020-04-29 04:00:00	AMZN	Stock	117.95	117.95	117.95	117.95	2840.0
2020-04-29 06:00:00	AMZN	Stock	117.55	117.55	117.55	117.55	3240.0
2020-04-29 07:00:00	AMZN	Stock	117.65	117.713	117.25	117.348	77280.0
2020-04-29 08:00:00	AMZN	Stock	117.5001	117.9315	116.0	116.1605	345800.0

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

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