PREVIEW / stock_1hour / 2021-06-18

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-06-18.parquet
  size:    1.4 MB
  rows:    66,229
  symbols: 2,966

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-18 04:00:00	AAPL	Stock	131.99	131.99	131.8	131.83	7124.0
2021-06-18 05:00:00	AAPL	Stock	131.84	131.95	131.82	131.95	6770.0
2021-06-18 06:00:00	AAPL	Stock	131.96	131.96	131.8	131.94	18584.0
2021-06-18 07:00:00	AAPL	Stock	131.95	131.99	131.44	131.6	118471.0
2021-06-18 08:00:00	AAPL	Stock	131.9699	131.99	130.79	131.14	690417.0
2021-06-18 09:00:00	AAPL	Stock	131.15	131.51	130.59	131.24	19869628.0
2021-06-18 10:00:00	AAPL	Stock	131.23	131.42	130.61	130.73	12171551.0
2021-06-18 11:00:00	AAPL	Stock	130.725	130.94	130.29	130.69	9347253.0
2021-06-18 12:00:00	AAPL	Stock	130.69	131.137	130.68	130.95	5111049.0
2021-06-18 13:00:00	AAPL	Stock	130.95	131.22	130.76	130.915	4914767.0
2021-06-18 14:00:00	AAPL	Stock	130.91	131.15	130.69	130.8075	5356956.0
2021-06-18 15:00:00	AAPL	Stock	130.8	131.15	130.24	130.4	13434141.0
2021-06-18 16:00:00	AAPL	Stock	130.42	130.8336	130.2	130.25	25352254.0
2021-06-18 17:00:00	AAPL	Stock	130.2	130.26	130.15	130.2099	43053.0
2021-06-18 18:00:00	AAPL	Stock	130.2	130.46	130.19	130.2	90037.0
2021-06-18 19:00:00	AAPL	Stock	130.21	130.25	130.18	130.2	26724.0
2021-06-18 04:00:00	MSFT	Stock	261.0	261.0	260.88	260.88	2859.0
2021-06-18 05:00:00	MSFT	Stock	261.0	261.0	261.0	261.0	2367.0
2021-06-18 06:00:00	MSFT	Stock	260.9	261.0	260.9	261.0	1337.0
2021-06-18 07:00:00	MSFT	Stock	261.0	261.0	260.23	260.44	10493.0
2021-06-18 08:00:00	MSFT	Stock	260.5	260.71	258.75	259.8	75315.0
2021-06-18 09:00:00	MSFT	Stock	259.79	261.17	258.75	260.17	6276634.0
2021-06-18 10:00:00	MSFT	Stock	260.18	262.3	260.015	260.52	3287612.0
2021-06-18 11:00:00	MSFT	Stock	260.52	260.88	259.48	259.98	2429137.0
2021-06-18 12:00:00	MSFT	Stock	259.9861	261.1	259.79	260.87	1515532.0
2021-06-18 13:00:00	MSFT	Stock	260.86	261.12	260.15	260.6499	1225483.0
2021-06-18 14:00:00	MSFT	Stock	260.64	261.055	260.11	260.3	1285151.0
2021-06-18 15:00:00	MSFT	Stock	260.29	261.13	258.85	259.27	4041613.0
2021-06-18 16:00:00	MSFT	Stock	259.43	259.69	258.9	259.0	8377378.0
2021-06-18 17:00:00	MSFT	Stock	258.995	259.2559	258.8	259.02	10270.0
2021-06-18 18:00:00	MSFT	Stock	259.02	259.43	258.8	258.95	31078.0
2021-06-18 19:00:00	MSFT	Stock	258.9	258.97	258.59	258.8999	7815.0
2021-06-18 04:00:00	NVDA	Stock	18.75	18.9185	18.75	18.875	198960.0
2021-06-18 05:00:00	NVDA	Stock	18.8875	18.9163	18.8738	18.9163	121960.0
2021-06-18 06:00:00	NVDA	Stock	18.9163	18.9163	18.8525	18.8525	93920.0
2021-06-18 07:00:00	NVDA	Stock	18.8498	18.9163	18.7472	18.8458	1108120.0
2021-06-18 08:00:00	NVDA	Stock	18.7999	18.9163	18.6875	18.8312	2626360.0
2021-06-18 09:00:00	NVDA	Stock	18.8375	19.25	18.6248	19.1832	132476600.0
2021-06-18 10:00:00	NVDA	Stock	19.1862	19.375	19.1175	19.2155	96245400.0
2021-06-18 11:00:00	NVDA	Stock	19.211	19.2867	19.0188	19.0928	66249520.0
2021-06-18 12:00:00	NVDA	Stock	19.0945	19.325	19.0705	19.1517	62507480.0
2021-06-18 13:00:00	NVDA	Stock	19.1481	19.1709	19.0322	19.054	25979920.0
2021-06-18 14:00:00	NVDA	Stock	19.054	19.1035	18.7308	18.7508	48232920.0
2021-06-18 15:00:00	NVDA	Stock	18.7475	18.899	18.584	18.6162	124441440.0
2021-06-18 16:00:00	NVDA	Stock	18.6055	18.65	18.6	18.6212	76099720.0
2021-06-18 17:00:00	NVDA	Stock	18.62	18.6602	18.62	18.6602	1092400.0
2021-06-18 18:00:00	NVDA	Stock	18.6368	18.6387	18.6178	18.6188	199280.0
2021-06-18 19:00:00	NVDA	Stock	18.625	18.6387	18.5775	18.5775	399880.0
2021-06-18 05:00:00	AMZN	Stock	174.4	174.4	174.4	174.4	2000.0
2021-06-18 07:00:00	AMZN	Stock	174.55	174.55	174.001	174.25	59060.0

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

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