PREVIEW / stock_1hour / 2020-02-11

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-02-11.parquet
  size:    1.2 MB
  rows:    50,695
  symbols: 2,415

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-11 04:00:00	AAPL	Stock	80.5025	80.6075	80.4525	80.575	26324.0
2020-02-11 05:00:00	AAPL	Stock	80.6075	80.6825	80.6075	80.675	29056.0
2020-02-11 06:00:00	AAPL	Stock	80.6875	80.6875	80.575	80.575	16016.0
2020-02-11 07:00:00	AAPL	Stock	80.555	80.6225	80.39	80.62	273312.0
2020-02-11 08:00:00	AAPL	Stock	80.535	80.8	80.3875	80.75	680272.0
2020-02-11 09:00:00	AAPL	Stock	80.75	80.975	80.3875	80.4425	13863048.0
2020-02-11 10:00:00	AAPL	Stock	80.44	80.82	80.4	80.7075	12154824.0
2020-02-11 11:00:00	AAPL	Stock	80.7025	80.765	80.2525	80.49	9076880.0
2020-02-11 12:00:00	AAPL	Stock	80.4925	80.695	80.4025	80.6732	6053164.0
2020-02-11 13:00:00	AAPL	Stock	80.675	80.7525	80.3675	80.4445	5022528.0
2020-02-11 14:00:00	AAPL	Stock	80.45	80.465	80.04	80.17	9301852.0
2020-02-11 15:00:00	AAPL	Stock	80.175	80.25	79.6775	79.9025	15548940.0
2020-02-11 16:00:00	AAPL	Stock	79.9025	80.5812	79.8025	79.875	6024940.0
2020-02-11 17:00:00	AAPL	Stock	79.8875	79.8975	79.825	79.85	22340.0
2020-02-11 18:00:00	AAPL	Stock	79.845	79.9275	79.825	79.9075	85328.0
2020-02-11 19:00:00	AAPL	Stock	79.925	79.925	79.775	79.8375	71148.0
2020-02-11 04:00:00	MSFT	Stock	190.0	190.33	189.9	190.25	10597.0
2020-02-11 05:00:00	MSFT	Stock	190.25	190.44	190.14	190.23	11948.0
2020-02-11 06:00:00	MSFT	Stock	190.3	190.35	190.0	190.03	21818.0
2020-02-11 07:00:00	MSFT	Stock	190.1	191.4	190.03	191.06	150661.0
2020-02-11 08:00:00	MSFT	Stock	191.06	191.4	190.15	191.0	207142.0
2020-02-11 09:00:00	MSFT	Stock	191.04	191.1	187.1	187.27	9505085.0
2020-02-11 10:00:00	MSFT	Stock	187.27	189.25	187.27	188.51	6249217.0
2020-02-11 11:00:00	MSFT	Stock	188.5	188.93	186.858	187.065	4703679.0
2020-02-11 12:00:00	MSFT	Stock	187.07	187.3	186.28	187.0	3966054.0
2020-02-11 13:00:00	MSFT	Stock	187.0	187.56	186.11	186.19	3371707.0
2020-02-11 14:00:00	MSFT	Stock	186.2	186.38	184.65	184.75	5654278.0
2020-02-11 15:00:00	MSFT	Stock	184.75	185.07	183.5	184.44	9951256.0
2020-02-11 16:00:00	MSFT	Stock	184.44	186.665	184.11	184.42	2099243.0
2020-02-11 17:00:00	MSFT	Stock	184.39	184.46	184.12	184.46	17695.0
2020-02-11 18:00:00	MSFT	Stock	184.48	185.1	184.35	184.99	40021.0
2020-02-11 19:00:00	MSFT	Stock	185.0	185.0	184.43	184.7	31443.0
2020-02-11 04:00:00	NVDA	Stock	6.6368	6.6368	6.6232	6.6328	63360.0
2020-02-11 05:00:00	NVDA	Stock	6.65	6.65	6.6375	6.6375	30160.0
2020-02-11 06:00:00	NVDA	Stock	6.6375	6.6625	6.6375	6.6475	92760.0
2020-02-11 07:00:00	NVDA	Stock	6.6463	6.7088	6.6385	6.705	2178080.0
2020-02-11 08:00:00	NVDA	Stock	6.657	6.7075	6.64	6.7015	3484000.0
2020-02-11 09:00:00	NVDA	Stock	6.698	6.7639	6.6208	6.7493	122880960.0
2020-02-11 10:00:00	NVDA	Stock	6.749	6.8115	6.7475	6.7935	124173640.0
2020-02-11 11:00:00	NVDA	Stock	6.793	6.8125	6.741	6.747	110493360.0
2020-02-11 12:00:00	NVDA	Stock	6.7475	6.7575	6.7205	6.7552	54740400.0
2020-02-11 13:00:00	NVDA	Stock	6.755	6.7558	6.6697	6.6872	41501040.0
2020-02-11 14:00:00	NVDA	Stock	6.6872	6.7065	6.6502	6.6845	68914400.0
2020-02-11 15:00:00	NVDA	Stock	6.6862	6.711	6.6422	6.6978	73678960.0
2020-02-11 16:00:00	NVDA	Stock	6.6972	6.7387	6.6882	6.7	5358080.0
2020-02-11 17:00:00	NVDA	Stock	6.7038	6.71	6.7038	6.7085	254320.0
2020-02-11 18:00:00	NVDA	Stock	6.71	6.7138	6.7088	6.7088	422280.0
2020-02-11 19:00:00	NVDA	Stock	6.71	6.71	6.6875	6.688	919360.0
2020-02-11 04:00:00	AMZN	Stock	107.34	107.34	107.185	107.185	4000.0
2020-02-11 05:00:00	AMZN	Stock	107.45	107.8	107.35	107.5675	35660.0

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

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