PREVIEW / stock_1hour / 2020-10-06

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-10-06.parquet
  size:    1.3 MB
  rows:    58,302
  symbols: 2,524

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-10-06 04:00:00	AAPL	Stock	115.76	115.8	115.23	115.67	23304.0
2020-10-06 05:00:00	AAPL	Stock	115.65	115.66	115.42	115.5	9887.0
2020-10-06 06:00:00	AAPL	Stock	115.55	115.79	115.29	115.55	34260.0
2020-10-06 07:00:00	AAPL	Stock	115.63	116.13	115.6	115.84	266110.0
2020-10-06 08:00:00	AAPL	Stock	115.84	116.79	115.56	115.91	675616.0
2020-10-06 09:00:00	AAPL	Stock	115.91	116.12	114.532	114.908	15729952.0
2020-10-06 10:00:00	AAPL	Stock	114.9	115.6	114.56	114.978	17626086.0
2020-10-06 11:00:00	AAPL	Stock	114.975	115.12	113.48	113.84	18234265.0
2020-10-06 12:00:00	AAPL	Stock	113.831	115.44	113.8	115.277	19478155.0
2020-10-06 13:00:00	AAPL	Stock	115.28	115.63	114.78	114.974	10547975.0
2020-10-06 14:00:00	AAPL	Stock	114.971	116.02	113.13	114.05	19980352.0
2020-10-06 15:00:00	AAPL	Stock	114.04	114.05	112.25	113.16	31558170.0
2020-10-06 16:00:00	AAPL	Stock	113.16	114.755	112.33	112.44	8884535.0
2020-10-06 17:00:00	AAPL	Stock	112.45	112.99	112.42	112.9	375337.0
2020-10-06 18:00:00	AAPL	Stock	112.9	113.1	112.65	112.8	304627.0
2020-10-06 19:00:00	AAPL	Stock	112.83	113.25	112.79	113.2	293810.0
2020-10-06 04:00:00	MSFT	Stock	209.6	209.73	209.03	209.05	4249.0
2020-10-06 05:00:00	MSFT	Stock	209.4	209.51	209.4	209.4	2835.0
2020-10-06 06:00:00	MSFT	Stock	209.15	209.4	208.6	208.7	8264.0
2020-10-06 07:00:00	MSFT	Stock	208.86	209.3	208.6	208.82	47925.0
2020-10-06 08:00:00	MSFT	Stock	208.856	209.33	208.5	208.9	71498.0
2020-10-06 09:00:00	MSFT	Stock	209.022	209.5	208.44	208.73	2496197.0
2020-10-06 10:00:00	MSFT	Stock	208.75	210.18	208.74	208.88	2606047.0
2020-10-06 11:00:00	MSFT	Stock	208.87	209.095	207.19	207.678	2521214.0
2020-10-06 12:00:00	MSFT	Stock	207.676	208.43	207.58	208.213	1360171.0
2020-10-06 13:00:00	MSFT	Stock	208.22	208.78	207.975	208.637	1503200.0
2020-10-06 14:00:00	MSFT	Stock	208.64	209.77	205.32	206.645	3201310.0
2020-10-06 15:00:00	MSFT	Stock	206.635	206.94	204.82	205.91	6473827.0
2020-10-06 16:00:00	MSFT	Stock	205.91	207.88	204.8	205.1	3273600.0
2020-10-06 17:00:00	MSFT	Stock	205.15	205.68	205.15	205.47	24957.0
2020-10-06 18:00:00	MSFT	Stock	205.47	206.0	204.8	204.8	32884.0
2020-10-06 19:00:00	MSFT	Stock	205.01	206.41	205.01	206.1	22035.0
2020-10-06 04:00:00	NVDA	Stock	13.6425	13.6425	13.5975	13.625	94440.0
2020-10-06 05:00:00	NVDA	Stock	13.617	13.617	13.5875	13.5875	177000.0
2020-10-06 06:00:00	NVDA	Stock	13.5662	13.675	13.5662	13.6725	76240.0
2020-10-06 07:00:00	NVDA	Stock	13.6558	13.8995	13.653	13.8722	3397560.0
2020-10-06 08:00:00	NVDA	Stock	13.688	13.889	13.6605	13.8458	2637760.0
2020-10-06 09:00:00	NVDA	Stock	13.8484	14.093	13.817	14.09	131199160.0
2020-10-06 10:00:00	NVDA	Stock	14.0848	14.142	13.9875	14.0375	91680440.0
2020-10-06 11:00:00	NVDA	Stock	14.0352	14.0608	13.8182	13.8855	87314440.0
2020-10-06 12:00:00	NVDA	Stock	13.885	14.053	13.8788	14.0398	62037480.0
2020-10-06 13:00:00	NVDA	Stock	14.041	14.0808	13.9955	14.0765	43879360.0
2020-10-06 14:00:00	NVDA	Stock	14.0786	14.1185	13.7795	13.8975	75583400.0
2020-10-06 15:00:00	NVDA	Stock	13.882	13.9158	13.665	13.725	150892760.0
2020-10-06 16:00:00	NVDA	Stock	13.7365	13.9994	13.6388	13.668	4648440.0
2020-10-06 17:00:00	NVDA	Stock	13.6715	13.72	13.65	13.7143	487400.0
2020-10-06 18:00:00	NVDA	Stock	13.7	13.7478	13.7	13.7125	853880.0
2020-10-06 19:00:00	NVDA	Stock	13.725	13.8	13.7238	13.8	560120.0
2020-10-06 04:00:00	AMZN	Stock	159.94	159.94	159.1	159.1	38100.0
2020-10-06 05:00:00	AMZN	Stock	159.15	159.15	159.15	159.15	3840.0

> showing 50 of 58,302 rows — these rows as CSV

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