PREVIEW / stock_1hour / 2020-12-16

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-12-16.parquet
  size:    1.4 MB
  rows:    63,268
  symbols: 2,682

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-12-16 04:00:00	AAPL	Stock	128.08	128.7	128.08	128.59	42749.0
2020-12-16 05:00:00	AAPL	Stock	128.58	128.6	128.5	128.6	20122.0
2020-12-16 06:00:00	AAPL	Stock	128.6	128.6	126.88	127.64	101760.0
2020-12-16 07:00:00	AAPL	Stock	127.53	127.88	127.26	127.84	318849.0
2020-12-16 08:00:00	AAPL	Stock	127.28	127.99	127.26	127.74	529071.0
2020-12-16 09:00:00	AAPL	Stock	127.76	127.8	126.56	127.16	14582194.0
2020-12-16 10:00:00	AAPL	Stock	127.185	127.87	126.81	126.99	12799697.0
2020-12-16 11:00:00	AAPL	Stock	126.995	127.83	126.69	127.8	9369713.0
2020-12-16 12:00:00	AAPL	Stock	127.8	128.02	127.34	127.775	7313780.0
2020-12-16 13:00:00	AAPL	Stock	127.77	127.94	127.26	127.66	6337088.0
2020-12-16 14:00:00	AAPL	Stock	127.67	128.235	127.285	128.11	9546185.0
2020-12-16 15:00:00	AAPL	Stock	128.12	128.37	127.69	127.75	13595367.0
2020-12-16 16:00:00	AAPL	Stock	127.81	127.89	127.475	127.81	10224404.0
2020-12-16 17:00:00	AAPL	Stock	127.81	127.91	127.7	127.78	42001.0
2020-12-16 18:00:00	AAPL	Stock	127.83	127.93	127.82	127.9	34538.0
2020-12-16 19:00:00	AAPL	Stock	127.88	127.9	127.65	127.8	82855.0
2020-12-16 04:00:00	MSFT	Stock	214.4	214.5	214.4	214.5	2961.0
2020-12-16 05:00:00	MSFT	Stock	214.32	214.32	214.18	214.22	1726.0
2020-12-16 06:00:00	MSFT	Stock	214.31	215.1	214.3	215.01	17539.0
2020-12-16 07:00:00	MSFT	Stock	215.0	215.0	214.64	214.8	14352.0
2020-12-16 08:00:00	MSFT	Stock	214.83	214.969	213.6	214.5	27043.0
2020-12-16 09:00:00	MSFT	Stock	214.5	216.643	214.45	215.98	3238782.0
2020-12-16 10:00:00	MSFT	Stock	215.909	217.66	215.72	217.13	3704736.0
2020-12-16 11:00:00	MSFT	Stock	217.13	219.19	217.13	219.18	3393029.0
2020-12-16 12:00:00	MSFT	Stock	219.19	219.35	218.42	218.9	2906080.0
2020-12-16 13:00:00	MSFT	Stock	218.884	219.96	218.79	219.77	2201879.0
2020-12-16 14:00:00	MSFT	Stock	219.78	219.96	218.61	219.75	2720127.0
2020-12-16 15:00:00	MSFT	Stock	219.76	220.11	219.0	219.19	4427711.0
2020-12-16 16:00:00	MSFT	Stock	219.28	219.44	218.9	219.03	6117457.0
2020-12-16 17:00:00	MSFT	Stock	219.14	219.72	219.05	219.2	14956.0
2020-12-16 18:00:00	MSFT	Stock	219.3	219.5	219.29	219.38	8546.0
2020-12-16 19:00:00	MSFT	Stock	219.35	219.46	219.16	219.22	9328.0
2020-12-16 04:00:00	NVDA	Stock	13.4023	13.4125	13.4023	13.4125	28320.0
2020-12-16 05:00:00	NVDA	Stock	13.4125	13.4125	13.3948	13.4	40880.0
2020-12-16 07:00:00	NVDA	Stock	13.3875	13.3875	13.36	13.36	42560.0
2020-12-16 08:00:00	NVDA	Stock	13.3875	13.3938	13.35	13.385	603680.0
2020-12-16 09:00:00	NVDA	Stock	13.3833	13.4472	13.221	13.2383	29320800.0
2020-12-16 10:00:00	NVDA	Stock	13.2412	13.335	13.2125	13.3185	28939760.0
2020-12-16 11:00:00	NVDA	Stock	13.3188	13.324	13.2463	13.2618	16108960.0
2020-12-16 12:00:00	NVDA	Stock	13.2638	13.2785	13.2128	13.2281	20709640.0
2020-12-16 13:00:00	NVDA	Stock	13.23	13.275	13.2125	13.248	13830400.0
2020-12-16 14:00:00	NVDA	Stock	13.2471	13.3104	13.217	13.2925	17231880.0
2020-12-16 15:00:00	NVDA	Stock	13.2938	13.3065	13.2355	13.2372	30276920.0
2020-12-16 16:00:00	NVDA	Stock	13.2425	13.255	13.2425	13.2438	23332080.0
2020-12-16 17:00:00	NVDA	Stock	13.25	13.25	13.2425	13.245	181440.0
2020-12-16 18:00:00	NVDA	Stock	13.24	13.28	13.24	13.2795	307120.0
2020-12-16 19:00:00	NVDA	Stock	13.27	13.2725	13.2613	13.2613	123320.0
2020-12-16 05:00:00	AMZN	Stock	158.8725	159.099	158.8725	159.099	9440.0
2020-12-16 06:00:00	AMZN	Stock	159.125	159.125	159.125	159.125	2000.0
2020-12-16 07:00:00	AMZN	Stock	159.05	159.05	158.5765	158.625	49720.0

> showing 50 of 63,268 rows — these rows as CSV

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