PREVIEW / stock_1hour / 2021-06-09

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-06-09.parquet
  size:    1.4 MB
  rows:    66,746
  symbols: 2,974

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
2021-06-09 04:00:00	AAPL	Stock	126.5	127.25	126.5	126.97	12680.0
2021-06-09 05:00:00	AAPL	Stock	127.01	127.04	126.88	126.96	3951.0
2021-06-09 06:00:00	AAPL	Stock	127.0	127.11	126.82	127.11	5230.0
2021-06-09 07:00:00	AAPL	Stock	127.1	127.26	126.95	127.09	80778.0
2021-06-09 08:00:00	AAPL	Stock	127.19	127.26	126.424	127.16	317606.0
2021-06-09 09:00:00	AAPL	Stock	127.16	127.75	126.64	126.9	8438573.0
2021-06-09 10:00:00	AAPL	Stock	126.9	127.295	126.52	127.2	8403118.0
2021-06-09 11:00:00	AAPL	Stock	127.1978	127.34	126.8203	126.95	5351265.0
2021-06-09 12:00:00	AAPL	Stock	126.94	127.2368	126.8999	127.1488	3768699.0
2021-06-09 13:00:00	AAPL	Stock	127.15	127.28	127.06	127.12	3048992.0
2021-06-09 14:00:00	AAPL	Stock	127.13	127.3	127.07	127.16	3870422.0
2021-06-09 15:00:00	AAPL	Stock	127.155	127.24	126.74	127.16	8544586.0
2021-06-09 16:00:00	AAPL	Stock	127.13	127.13	126.95	126.97	7754923.0
2021-06-09 17:00:00	AAPL	Stock	126.97	127.13	126.88	126.95	52801.0
2021-06-09 18:00:00	AAPL	Stock	126.9401	127.13	126.94	127.05	62398.0
2021-06-09 19:00:00	AAPL	Stock	127.04	127.08	126.96	126.98	25848.0
2021-06-09 04:00:00	MSFT	Stock	253.24	253.28	252.8	253.28	1158.0
2021-06-09 05:00:00	MSFT	Stock	253.0	253.03	253.0	253.0	1622.0
2021-06-09 06:00:00	MSFT	Stock	253.09	253.33	253.09	253.33	678.0
2021-06-09 07:00:00	MSFT	Stock	253.31	253.45	253.0	253.28	9392.0
2021-06-09 08:00:00	MSFT	Stock	253.11	253.75	253.08	253.46	17501.0
2021-06-09 09:00:00	MSFT	Stock	253.55	255.53	253.4	254.74	2149771.0
2021-06-09 10:00:00	MSFT	Stock	254.75	254.88	253.21	253.9	2029357.0
2021-06-09 11:00:00	MSFT	Stock	253.885	254.92	253.82	254.21	1470970.0
2021-06-09 12:00:00	MSFT	Stock	254.205	255.13	254.1614	255.11	1277566.0
2021-06-09 13:00:00	MSFT	Stock	255.11	255.335	254.74	254.84	1063839.0
2021-06-09 14:00:00	MSFT	Stock	254.85	255.05	253.99	254.1	1333664.0
2021-06-09 15:00:00	MSFT	Stock	254.085	254.2	253.38	253.62	2404811.0
2021-06-09 16:00:00	MSFT	Stock	253.59	253.79	253.36	253.36	2118837.0
2021-06-09 17:00:00	MSFT	Stock	253.56	253.72	253.56	253.59	8000.0
2021-06-09 18:00:00	MSFT	Stock	253.67	253.67	253.56	253.56	2473.0
2021-06-09 19:00:00	MSFT	Stock	253.6	253.67	253.41	253.41	4106.0
2021-06-09 04:00:00	NVDA	Stock	17.4498	17.4498	17.3748	17.3748	40000.0
2021-06-09 05:00:00	NVDA	Stock	17.375	17.4	17.375	17.4	31160.0
2021-06-09 06:00:00	NVDA	Stock	17.4313	17.4375	17.4313	17.4375	19600.0
2021-06-09 07:00:00	NVDA	Stock	17.475	17.6	17.475	17.5625	403920.0
2021-06-09 08:00:00	NVDA	Stock	17.425	17.5812	17.4053	17.55	751720.0
2021-06-09 09:00:00	NVDA	Stock	17.54	17.571	17.2932	17.3208	35256880.0
2021-06-09 10:00:00	NVDA	Stock	17.319	17.3695	17.2558	17.3171	35848640.0
2021-06-09 11:00:00	NVDA	Stock	17.3125	17.4405	17.301	17.4241	25031640.0
2021-06-09 12:00:00	NVDA	Stock	17.4229	17.5124	17.408	17.4998	40638320.0
2021-06-09 13:00:00	NVDA	Stock	17.5002	17.575	17.4788	17.5178	37584240.0
2021-06-09 14:00:00	NVDA	Stock	17.5206	17.5512	17.3648	17.3668	38917560.0
2021-06-09 15:00:00	NVDA	Stock	17.3632	17.4009	17.3166	17.3569	48696680.0
2021-06-09 16:00:00	NVDA	Stock	17.3583	17.3989	17.3312	17.3312	9631400.0
2021-06-09 17:00:00	NVDA	Stock	17.3288	17.3583	17.3288	17.3498	422800.0
2021-06-09 18:00:00	NVDA	Stock	17.3455	17.3583	17.3455	17.3583	1247920.0
2021-06-09 19:00:00	NVDA	Stock	17.3415	17.3482	17.3338	17.3418	43200.0
2021-06-09 07:00:00	AMZN	Stock	163.8885	163.9105	163.65	163.75	29860.0
2021-06-09 08:00:00	AMZN	Stock	163.8885	164.0	163.6	163.705	52640.0

> showing 50 of 66,746 rows — these rows as CSV

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