PREVIEW / stock_1hour / 2002-07-12

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-07-12.parquet
  size:    403 KB
  rows:    19,417
  symbols: 1,440

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
2002-07-12 08:00:00	AAPL	Stock	0.3321	0.3321	0.3304	0.3321	330400.0
2002-07-12 09:00:00	AAPL	Stock	0.3321	0.3345	0.3234	0.3273	48350400.0
2002-07-12 10:00:00	AAPL	Stock	0.3273	0.3355	0.3243	0.3305	76692000.0
2002-07-12 11:00:00	AAPL	Stock	0.3307	0.3316	0.3232	0.3243	39166400.0
2002-07-12 12:00:00	AAPL	Stock	0.3243	0.325	0.3184	0.3188	71097600.0
2002-07-12 13:00:00	AAPL	Stock	0.3187	0.3195	0.3125	0.3179	54068000.0
2002-07-12 14:00:00	AAPL	Stock	0.318	0.318	0.3107	0.3132	53642400.0
2002-07-12 15:00:00	AAPL	Stock	0.3132	0.3134	0.3082	0.3125	68454400.0
2002-07-12 16:00:00	AAPL	Stock	0.3125	0.3208	0.31	0.3125	19471200.0
2002-07-12 17:00:00	AAPL	Stock	0.3155	0.3206	0.3125	0.3132	2884000.0
2002-07-12 18:00:00	AAPL	Stock	0.3132	0.3132	0.3132	0.3132	44800.0
2002-07-12 08:00:00	MSFT	Stock	26.95	27.05	25.84	26.75	159000.0
2002-07-12 09:00:00	MSFT	Stock	26.795	26.875	26.035	26.3185	15989800.0
2002-07-12 10:00:00	MSFT	Stock	26.31	26.675	26.165	26.545	22438600.0
2002-07-12 11:00:00	MSFT	Stock	26.54	26.575	26.085	26.165	10461400.0
2002-07-12 12:00:00	MSFT	Stock	26.17	26.32	26.045	26.27	7586600.0
2002-07-12 13:00:00	MSFT	Stock	26.27	26.395	26.1215	26.195	8073400.0
2002-07-12 14:00:00	MSFT	Stock	26.19	26.25	25.755	25.925	11963200.0
2002-07-12 15:00:00	MSFT	Stock	25.9	26.125	25.75	25.93	14656200.0
2002-07-12 16:00:00	MSFT	Stock	25.925	26.2834	25.8005	25.895	2150600.0
2002-07-12 17:00:00	MSFT	Stock	26.0818	26.1836	25.75	25.93	341400.0
2002-07-12 18:00:00	MSFT	Stock	25.875	25.93	25.86	25.86	26600.0
2002-07-12 08:00:00	NVDA	Stock	0.1725	0.1767	0.1561	0.1708	6732000.0
2002-07-12 09:00:00	NVDA	Stock	0.1708	0.1757	0.1656	0.1683	298872000.0
2002-07-12 10:00:00	NVDA	Stock	0.1683	0.175	0.167	0.1734	359616000.0
2002-07-12 11:00:00	NVDA	Stock	0.1733	0.1738	0.1676	0.1686	161580000.0
2002-07-12 12:00:00	NVDA	Stock	0.1682	0.1712	0.1682	0.1703	77088000.0
2002-07-12 13:00:00	NVDA	Stock	0.1704	0.1704	0.1667	0.1676	83676000.0
2002-07-12 14:00:00	NVDA	Stock	0.1677	0.1679	0.1625	0.1637	167844000.0
2002-07-12 15:00:00	NVDA	Stock	0.1639	0.1677	0.1627	0.1658	120084000.0
2002-07-12 16:00:00	NVDA	Stock	0.1659	0.1695	0.1652	0.1652	20124000.0
2002-07-12 17:00:00	NVDA	Stock	0.1651	0.1693	0.1651	0.1659	1272000.0
2002-07-12 18:00:00	NVDA	Stock	0.1665	0.1665	0.1659	0.1665	204000.0
2002-07-12 08:00:00	AMZN	Stock	0.7955	0.797	0.7176	0.7805	166000.0
2002-07-12 09:00:00	AMZN	Stock	0.78	0.8	0.78	0.7925	17464000.0
2002-07-12 10:00:00	AMZN	Stock	0.7925	0.8015	0.785	0.797	21136000.0
2002-07-12 11:00:00	AMZN	Stock	0.7965	0.801	0.788	0.7915	9568000.0
2002-07-12 12:00:00	AMZN	Stock	0.7935	0.8005	0.792	0.798	5274000.0
2002-07-12 13:00:00	AMZN	Stock	0.799	0.8095	0.7965	0.806	13636000.0
2002-07-12 14:00:00	AMZN	Stock	0.806	0.807	0.793	0.7975	15258000.0
2002-07-12 15:00:00	AMZN	Stock	0.7966	0.7991	0.7625	0.772	46036000.0
2002-07-12 16:00:00	AMZN	Stock	0.7715	0.7725	0.76	0.77	2964000.0
2002-07-12 17:00:00	AMZN	Stock	0.7675	0.771	0.765	0.771	32000.0
2002-07-12 09:00:00	CL	Stock	25.3	25.375	25.175	25.185	1060000.0
2002-07-12 10:00:00	CL	Stock	25.19	25.25	24.925	25.22	1336000.0
2002-07-12 11:00:00	CL	Stock	25.225	25.25	25.055	25.095	733800.0
2002-07-12 12:00:00	CL	Stock	25.1	25.255	25.09	25.235	359400.0
2002-07-12 13:00:00	CL	Stock	25.24	25.295	25.19	25.24	466000.0
2002-07-12 14:00:00	CL	Stock	25.25	25.255	24.655	24.745	886000.0
2002-07-12 15:00:00	CL	Stock	24.725	24.74	24.41	24.71	1342000.0

> showing 50 of 19,417 rows — these rows as CSV

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