PREVIEW / stock_1hour / 2020-03-03

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-03-03.parquet
  size:    1.2 MB
  rows:    53,189
  symbols: 2,416

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-03-03 04:00:00	AAPL	Stock	75.075	75.43	74.75	75.25	186168.0
2020-03-03 05:00:00	AAPL	Stock	75.25	75.375	75.15	75.2375	165144.0
2020-03-03 06:00:00	AAPL	Stock	75.23	75.23	74.5675	74.7775	105200.0
2020-03-03 07:00:00	AAPL	Stock	74.87	75.7925	74.75	75.1975	2310748.0
2020-03-03 08:00:00	AAPL	Stock	75.13	75.7525	74.7	75.1025	2595920.0
2020-03-03 09:00:00	AAPL	Stock	75.1	76.0375	73.065	73.585	43737584.0
2020-03-03 10:00:00	AAPL	Stock	73.565	76.0	73.51	74.845	55014532.0
2020-03-03 11:00:00	AAPL	Stock	74.8175	74.9825	72.7725	73.9675	33656616.0
2020-03-03 12:00:00	AAPL	Stock	73.9875	74.3725	73.19	73.4175	16946848.0
2020-03-03 13:00:00	AAPL	Stock	73.425	73.425	72.0	72.04	22281552.0
2020-03-03 14:00:00	AAPL	Stock	72.0575	72.6835	71.45	72.57	31500984.0
2020-03-03 15:00:00	AAPL	Stock	72.5775	73.3575	71.96	72.3275	38924184.0
2020-03-03 16:00:00	AAPL	Stock	72.33	72.875	72.1275	72.165	15271004.0
2020-03-03 17:00:00	AAPL	Stock	72.2475	72.2475	71.6875	71.75	145612.0
2020-03-03 18:00:00	AAPL	Stock	71.75	71.875	71.3825	71.775	457672.0
2020-03-03 19:00:00	AAPL	Stock	71.75	72.75	71.75	72.725	335136.0
2020-03-03 04:00:00	MSFT	Stock	173.83	174.2	172.79	173.83	25587.0
2020-03-03 05:00:00	MSFT	Stock	173.83	174.65	173.79	174.39	27443.0
2020-03-03 06:00:00	MSFT	Stock	174.25	174.25	172.23	173.05	38373.0
2020-03-03 07:00:00	MSFT	Stock	173.05	174.37	172.01	172.8	255474.0
2020-03-03 08:00:00	MSFT	Stock	172.8	174.3	170.98	173.45	256845.0
2020-03-03 09:00:00	MSFT	Stock	173.4	174.44	168.0	168.809	8189119.0
2020-03-03 10:00:00	MSFT	Stock	168.8	175.0	168.67	171.701	11098115.0
2020-03-03 11:00:00	MSFT	Stock	171.65	171.91	167.058	169.92	5738130.0
2020-03-03 12:00:00	MSFT	Stock	169.91	170.48	167.5	168.098	3914661.0
2020-03-03 13:00:00	MSFT	Stock	168.04	168.06	164.0	164.08	5092457.0
2020-03-03 14:00:00	MSFT	Stock	164.08	165.45	162.26	164.818	7577351.0
2020-03-03 15:00:00	MSFT	Stock	164.86	167.34	163.54	164.38	10661646.0
2020-03-03 16:00:00	MSFT	Stock	164.51	165.58	163.75	163.85	8069317.0
2020-03-03 17:00:00	MSFT	Stock	163.76	164.0	163.26	163.3	31247.0
2020-03-03 18:00:00	MSFT	Stock	163.45	163.9	162.78	163.5	29455.0
2020-03-03 19:00:00	MSFT	Stock	163.7	166.2	163.7	165.9	46483.0
2020-03-03 04:00:00	NVDA	Stock	6.93	7.0198	6.9275	6.98	278200.0
2020-03-03 05:00:00	NVDA	Stock	7.0198	7.021	7.0008	7.0008	165000.0
2020-03-03 06:00:00	NVDA	Stock	6.975	6.9882	6.925	6.9362	127880.0
2020-03-03 07:00:00	NVDA	Stock	6.9412	7.001	6.8838	6.9125	2955120.0
2020-03-03 08:00:00	NVDA	Stock	6.9942	6.9998	6.8628	6.9375	2316560.0
2020-03-03 09:00:00	NVDA	Stock	6.9388	6.975	6.7878	6.85	66698920.0
2020-03-03 10:00:00	NVDA	Stock	6.8468	7.0268	6.8134	6.9959	98942920.0
2020-03-03 11:00:00	NVDA	Stock	6.9902	7.0	6.7328	6.8908	77491880.0
2020-03-03 12:00:00	NVDA	Stock	6.89	6.9195	6.8042	6.8085	44782960.0
2020-03-03 13:00:00	NVDA	Stock	6.8045	6.8045	6.6325	6.642	67399160.0
2020-03-03 14:00:00	NVDA	Stock	6.6395	6.6732	6.5615	6.6406	73305640.0
2020-03-03 15:00:00	NVDA	Stock	6.6408	6.725	6.6	6.641	102769360.0
2020-03-03 16:00:00	NVDA	Stock	6.6472	6.6918	6.61	6.61	29141320.0
2020-03-03 17:00:00	NVDA	Stock	6.6115	6.625	6.5562	6.5588	385840.0
2020-03-03 18:00:00	NVDA	Stock	6.565	6.6075	6.5575	6.5775	968520.0
2020-03-03 19:00:00	NVDA	Stock	6.587	6.6855	6.587	6.6712	1035080.0
2020-03-03 04:00:00	AMZN	Stock	98.2525	98.2525	98.2525	98.2525	2060.0
2020-03-03 05:00:00	AMZN	Stock	98.73	98.8895	98.73	98.8	46220.0

> showing 50 of 53,189 rows — these rows as CSV

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