PREVIEW / stock_1hour / 2000-04-12

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-04-12.parquet
  size:    282 KB
  rows:    14,634
  symbols: 1,158

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
2000-04-12 09:00:00	AAPL	Stock	1.0625	1.0625	1.0045	1.0167	106657600.0
2000-04-12 10:00:00	AAPL	Stock	1.0156	1.0301	0.9911	0.9944	190702400.0
2000-04-12 11:00:00	AAPL	Stock	0.9944	0.9969	0.9715	0.9855	190747200.0
2000-04-12 12:00:00	AAPL	Stock	0.9872	1.0078	0.9855	1.0	97753600.0
2000-04-12 13:00:00	AAPL	Stock	1.0022	1.0179	0.9939	0.9983	105672000.0
2000-04-12 14:00:00	AAPL	Stock	0.9972	1.0011	0.9821	0.9972	49448000.0
2000-04-12 15:00:00	AAPL	Stock	0.9972	0.9978	0.9364	0.9754	143718400.0
2000-04-12 16:00:00	AAPL	Stock	0.9749	0.9754	0.9743	0.9754	235200.0
2000-04-12 09:00:00	MSFT	Stock	41.0625	41.125	40.1562	40.375	24717000.0
2000-04-12 10:00:00	MSFT	Stock	40.375	40.4375	39.7188	39.7656	31180200.0
2000-04-12 11:00:00	MSFT	Stock	39.7812	39.9375	39.5	39.5938	22739000.0
2000-04-12 12:00:00	MSFT	Stock	39.625	40.25	39.5	39.9062	14773200.0
2000-04-12 13:00:00	MSFT	Stock	39.9375	40.1875	39.7188	39.7656	12840400.0
2000-04-12 14:00:00	MSFT	Stock	39.75	40.0	39.5938	39.6562	11351400.0
2000-04-12 15:00:00	MSFT	Stock	39.6562	39.8438	39.4688	39.6875	22741200.0
2000-04-12 16:00:00	MSFT	Stock	39.6875	39.7188	39.6562	39.6875	92800.0
2000-04-12 09:00:00	NVDA	Stock	0.1835	0.1875	0.182	0.182	9072000.0
2000-04-12 10:00:00	NVDA	Stock	0.182	0.1822	0.1734	0.176	60528000.0
2000-04-12 11:00:00	NVDA	Stock	0.175	0.1798	0.1733	0.175	41184000.0
2000-04-12 12:00:00	NVDA	Stock	0.1747	0.1753	0.1719	0.1745	48432000.0
2000-04-12 13:00:00	NVDA	Stock	0.175	0.1786	0.1729	0.175	28128000.0
2000-04-12 14:00:00	NVDA	Stock	0.1747	0.1747	0.1687	0.1693	32208000.0
2000-04-12 15:00:00	NVDA	Stock	0.1698	0.1708	0.1635	0.1641	78096000.0
2000-04-12 16:00:00	NVDA	Stock	0.1642	0.1642	0.1642	0.1642	288000.0
2000-04-12 09:00:00	AMZN	Stock	3.2	3.2188	3.1094	3.1156	10804000.0
2000-04-12 10:00:00	AMZN	Stock	3.1188	3.1188	2.9969	3.0	24184000.0
2000-04-12 11:00:00	AMZN	Stock	3.0	3.1	2.9531	3.0062	24978000.0
2000-04-12 12:00:00	AMZN	Stock	3.0062	3.1031	2.9719	3.1	19800000.0
2000-04-12 13:00:00	AMZN	Stock	3.1	3.1312	3.0563	3.075	13034000.0
2000-04-12 14:00:00	AMZN	Stock	3.0719	3.0813	2.9594	2.9938	20728000.0
2000-04-12 15:00:00	AMZN	Stock	2.9938	2.9938	2.8125	2.8188	53502000.0
2000-04-12 16:00:00	AMZN	Stock	2.825	2.8406	2.8188	2.8188	242000.0
2000-04-12 09:00:00	CL	Stock	31.3125	31.6875	31.25	31.4688	520200.0
2000-04-12 10:00:00	CL	Stock	31.4688	32.5625	31.25	32.5625	1274200.0
2000-04-12 11:00:00	CL	Stock	32.5625	32.625	32.125	32.4688	867000.0
2000-04-12 12:00:00	CL	Stock	32.4688	32.5	32.0625	32.125	648000.0
2000-04-12 13:00:00	CL	Stock	32.125	32.25	31.4375	31.5312	913000.0
2000-04-12 14:00:00	CL	Stock	31.5312	31.9375	31.4375	31.625	825800.0
2000-04-12 15:00:00	CL	Stock	31.6562	31.6875	30.9375	31.0	921600.0
2000-04-12 16:00:00	CL	Stock	31.0312	31.0312	31.0	31.0	53400.0

> showing 40 of 14,634 rows — these rows as CSV

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