PREVIEW / stock_1hour / 2023-06-12

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-06-12.parquet
  size:    1.4 MB
  rows:    61,275
  symbols: 1,656

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
2023-06-12 04:00:00	AAPL	Stock	180.04	181.72	180.04	181.66	22156.0
2023-06-12 05:00:00	AAPL	Stock	181.68	181.75	181.51	181.51	8702.0
2023-06-12 06:00:00	AAPL	Stock	181.6	181.61	181.32	181.6	7896.0
2023-06-12 07:00:00	AAPL	Stock	181.55	181.85	181.54	181.71	52933.0
2023-06-12 08:00:00	AAPL	Stock	181.57	181.99	181.4	181.94	129890.0
2023-06-12 09:00:00	AAPL	Stock	181.94	182.04	181.16	181.44	4501549.0
2023-06-12 10:00:00	AAPL	Stock	181.44	181.97	180.97	181.765	4842352.0
2023-06-12 11:00:00	AAPL	Stock	181.7601	182.53	181.72	182.3266	4602437.0
2023-06-12 12:00:00	AAPL	Stock	182.34	182.5	182.12	182.3978	2615255.0
2023-06-12 13:00:00	AAPL	Stock	182.395	182.78	182.36	182.74	2799648.0
2023-06-12 14:00:00	AAPL	Stock	182.75	183.12	182.621	183.11	3078522.0
2023-06-12 15:00:00	AAPL	Stock	183.11	183.89	183.01	183.84	8364312.0
2023-06-12 16:00:00	AAPL	Stock	183.79	183.99	183.74	183.97	10096808.0
2023-06-12 17:00:00	AAPL	Stock	183.96	184.06	183.79	184.06	84827.0
2023-06-12 18:00:00	AAPL	Stock	184.01	184.28	183.98	184.28	32239.0
2023-06-12 19:00:00	AAPL	Stock	184.29	184.35	181.5	182.5099	372551.0
2023-06-12 04:00:00	MSFT	Stock	328.55	328.93	327.84	328.8	5750.0
2023-06-12 05:00:00	MSFT	Stock	328.99	329.37	328.99	329.0	2358.0
2023-06-12 06:00:00	MSFT	Stock	328.81	328.81	328.61	328.61	4272.0
2023-06-12 07:00:00	MSFT	Stock	328.66	329.0	328.61	328.82	10755.0
2023-06-12 08:00:00	MSFT	Stock	328.61	329.0	327.31	329.0	34315.0
2023-06-12 09:00:00	MSFT	Stock	328.9699	329.13	326.565	326.71	1906873.0
2023-06-12 10:00:00	MSFT	Stock	326.735	327.43	325.16	326.007	2238018.0
2023-06-12 11:00:00	MSFT	Stock	325.98	328.15	325.56	328.06	1640582.0
2023-06-12 12:00:00	MSFT	Stock	328.05	328.06	327.21	327.65	972140.0
2023-06-12 13:00:00	MSFT	Stock	327.63	329.77	327.57	329.74	1255041.0
2023-06-12 14:00:00	MSFT	Stock	329.75	330.77	329.14	330.66	1328929.0
2023-06-12 15:00:00	MSFT	Stock	330.66	332.0999	330.43	331.91	3451213.0
2023-06-12 16:00:00	MSFT	Stock	331.9	333.27	331.85	332.96	5423266.0
2023-06-12 17:00:00	MSFT	Stock	332.9	333.0	332.5327	332.7001	11351.0
2023-06-12 18:00:00	MSFT	Stock	332.7001	333.3	332.55	333.2	14235.0
2023-06-12 19:00:00	MSFT	Stock	333.25	334.1	333.25	333.91	17583.0
2023-06-12 04:00:00	NVDA	Stock	39.04	39.27	39.04	39.24	106990.0
2023-06-12 05:00:00	NVDA	Stock	39.23	39.258	39.15	39.18	40040.0
2023-06-12 06:00:00	NVDA	Stock	39.127	39.17	39.1	39.133	40630.0
2023-06-12 07:00:00	NVDA	Stock	39.119	39.2	39.08	39.16	434270.0
2023-06-12 08:00:00	NVDA	Stock	39.114	39.202	38.9	39.174	1663660.0
2023-06-12 09:00:00	NVDA	Stock	39.18	39.325	38.677	38.79	43367150.0
2023-06-12 10:00:00	NVDA	Stock	38.7915	39.104	38.618	38.688	52428720.0
2023-06-12 11:00:00	NVDA	Stock	38.6875	39.079	38.622	38.902	37790540.0
2023-06-12 12:00:00	NVDA	Stock	38.9028	38.979	38.7075	38.901	25180130.0
2023-06-12 13:00:00	NVDA	Stock	38.9	38.975	38.834	38.9015	19235340.0
2023-06-12 14:00:00	NVDA	Stock	38.904	39.0	38.781	38.966	19807190.0
2023-06-12 15:00:00	NVDA	Stock	38.9673	39.53	38.897	39.497	68545890.0
2023-06-12 16:00:00	NVDA	Stock	39.497	39.577	39.451	39.497	27596550.0
2023-06-12 17:00:00	NVDA	Stock	39.499	39.548	39.484	39.5188	380620.0
2023-06-12 18:00:00	NVDA	Stock	39.5103	39.5454	39.483	39.5454	349010.0
2023-06-12 19:00:00	NVDA	Stock	39.529	39.58	39.519	39.57	380690.0
2023-06-12 04:00:00	AMZN	Stock	123.95	124.25	123.9	124.2	13909.0
2023-06-12 05:00:00	AMZN	Stock	124.2	124.3	124.1	124.1	10268.0

> showing 50 of 61,275 rows — these rows as CSV

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