PREVIEW / stock_1hour / 2020-02-05

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-02-05.parquet
  size:    1.2 MB
  rows:    51,761
  symbols: 2,428

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-05 04:00:00	AAPL	Stock	80.1625	80.9	79.9975	80.5975	250572.0
2020-02-05 05:00:00	AAPL	Stock	80.575	80.6925	80.25	80.375	130652.0
2020-02-05 06:00:00	AAPL	Stock	80.315	80.575	80.2525	80.325	65100.0
2020-02-05 07:00:00	AAPL	Stock	80.36	80.5875	80.2125	80.47	700692.0
2020-02-05 08:00:00	AAPL	Stock	80.2625	80.82	80.215	80.8	1159068.0
2020-02-05 09:00:00	AAPL	Stock	80.8	81.19	80.2278	80.75	20213504.0
2020-02-05 10:00:00	AAPL	Stock	80.75	80.875	79.7375	80.195	20757096.0
2020-02-05 11:00:00	AAPL	Stock	80.185	80.3972	79.93	80.3425	12539512.0
2020-02-05 12:00:00	AAPL	Stock	80.3375	80.5125	80.225	80.3425	7391764.0
2020-02-05 13:00:00	AAPL	Stock	80.345	80.3525	79.9875	80.1525	6438908.0
2020-02-05 14:00:00	AAPL	Stock	80.1525	80.38	80.0175	80.3162	6745944.0
2020-02-05 15:00:00	AAPL	Stock	80.3162	80.625	80.1325	80.395	16333208.0
2020-02-05 16:00:00	AAPL	Stock	80.3625	80.5125	80.265	80.4375	7016008.0
2020-02-05 17:00:00	AAPL	Stock	80.4575	80.475	80.3625	80.475	503940.0
2020-02-05 18:00:00	AAPL	Stock	80.45	80.5	80.425	80.4675	47540.0
2020-02-05 19:00:00	AAPL	Stock	80.4375	80.5	80.4125	80.5	120868.0
2020-02-05 04:00:00	MSFT	Stock	181.2	183.2	181.2	183.2	14158.0
2020-02-05 05:00:00	MSFT	Stock	183.18	183.36	182.68	183.25	12675.0
2020-02-05 06:00:00	MSFT	Stock	183.27	183.39	182.4	182.6	10614.0
2020-02-05 07:00:00	MSFT	Stock	182.78	183.83	182.44	183.5	229920.0
2020-02-05 08:00:00	MSFT	Stock	182.79	184.25	182.75	184.0	224170.0
2020-02-05 09:00:00	MSFT	Stock	184.02	184.24	181.06	181.46	5665143.0
2020-02-05 10:00:00	MSFT	Stock	181.47	182.327	179.92	180.37	5940237.0
2020-02-05 11:00:00	MSFT	Stock	180.37	180.38	178.41	179.16	4838954.0
2020-02-05 12:00:00	MSFT	Stock	179.16	180.09	179.08	179.39	2737766.0
2020-02-05 13:00:00	MSFT	Stock	179.4	179.4	178.815	179.01	1842445.0
2020-02-05 14:00:00	MSFT	Stock	179.016	180.61	178.78	180.321	2938006.0
2020-02-05 15:00:00	MSFT	Stock	180.32	180.99	179.37	179.94	5204764.0
2020-02-05 16:00:00	MSFT	Stock	179.9	180.49	179.9	180.45	4237571.0
2020-02-05 17:00:00	MSFT	Stock	180.45	180.64	179.9	180.6	211742.0
2020-02-05 18:00:00	MSFT	Stock	180.63	180.65	180.2	180.2	20728.0
2020-02-05 19:00:00	MSFT	Stock	180.15	180.8	180.1	180.79	22740.0
2020-02-05 04:00:00	NVDA	Stock	6.2375	6.326	6.2375	6.32	98080.0
2020-02-05 05:00:00	NVDA	Stock	6.3245	6.3245	6.3	6.3	53600.0
2020-02-05 06:00:00	NVDA	Stock	6.2752	6.2902	6.2502	6.2688	216520.0
2020-02-05 07:00:00	NVDA	Stock	6.2742	6.2875	6.252	6.267	589920.0
2020-02-05 08:00:00	NVDA	Stock	6.2742	6.3062	6.255	6.3	1450720.0
2020-02-05 09:00:00	NVDA	Stock	6.2975	6.31	6.2262	6.2611	38369320.0
2020-02-05 10:00:00	NVDA	Stock	6.2618	6.2828	6.1852	6.2348	38483920.0
2020-02-05 11:00:00	NVDA	Stock	6.2333	6.253	6.2155	6.24	17606120.0
2020-02-05 12:00:00	NVDA	Stock	6.2378	6.257	6.2358	6.2478	11071720.0
2020-02-05 13:00:00	NVDA	Stock	6.248	6.248	6.221	6.2214	10285000.0
2020-02-05 14:00:00	NVDA	Stock	6.2213	6.2715	6.2088	6.2673	16153400.0
2020-02-05 15:00:00	NVDA	Stock	6.2685	6.2878	6.2502	6.2699	30274920.0
2020-02-05 16:00:00	NVDA	Stock	6.269	6.2812	6.255	6.275	2083960.0
2020-02-05 17:00:00	NVDA	Stock	6.275	6.275	6.2675	6.2725	706240.0
2020-02-05 18:00:00	NVDA	Stock	6.2748	6.28	6.27	6.27	22280.0
2020-02-05 19:00:00	NVDA	Stock	6.27	6.2848	6.27	6.2848	102960.0
2020-02-05 04:00:00	AMZN	Stock	102.914	103.15	102.914	103.15	14900.0
2020-02-05 05:00:00	AMZN	Stock	103.3035	103.45	103.3035	103.45	20000.0

> showing 50 of 51,761 rows — these rows as CSV

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