PREVIEW / stock_1hour / 2004-11-19

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-11-19.parquet
  size:    537 KB
  rows:    25,210
  symbols: 1,877

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
2004-11-19 08:00:00	AAPL	Stock	0.9905	0.9911	0.9893	0.9893	148400.0
2004-11-19 09:00:00	AAPL	Stock	0.9911	0.9936	0.9827	0.9927	72438520.0
2004-11-19 10:00:00	AAPL	Stock	0.9925	1.0163	0.9732	0.9821	328720896.0
2004-11-19 11:00:00	AAPL	Stock	0.9814	0.9959	0.9813	0.9921	86855440.0
2004-11-19 12:00:00	AAPL	Stock	0.9921	0.9923	0.9818	0.9839	41444984.0
2004-11-19 13:00:00	AAPL	Stock	0.9839	0.995	0.9839	0.9905	30759680.0
2004-11-19 14:00:00	AAPL	Stock	0.9905	0.9907	0.9843	0.9873	42466424.0
2004-11-19 15:00:00	AAPL	Stock	0.9875	0.9895	0.9813	0.9857	118746880.0
2004-11-19 16:00:00	AAPL	Stock	0.9854	0.9866	0.9825	0.9827	17897376.0
2004-11-19 17:00:00	AAPL	Stock	0.9848	0.9848	0.9827	0.9835	170240.0
2004-11-19 18:00:00	AAPL	Stock	0.9829	0.9829	0.9816	0.9816	350336.0
2004-11-19 08:00:00	MSFT	Stock	27.04	27.05	27.0	27.0	18815.0
2004-11-19 09:00:00	MSFT	Stock	27.0	27.07	26.97	26.99	10390247.0
2004-11-19 10:00:00	MSFT	Stock	26.99	27.0	26.9	26.95	19289193.0
2004-11-19 11:00:00	MSFT	Stock	26.94	26.99	26.86	26.97	9727593.0
2004-11-19 12:00:00	MSFT	Stock	26.97	26.99	26.91	26.94	8000867.0
2004-11-19 13:00:00	MSFT	Stock	26.94	27.0	26.91	26.92	6194706.0
2004-11-19 14:00:00	MSFT	Stock	26.92	26.97	26.88	26.95	11328248.0
2004-11-19 15:00:00	MSFT	Stock	26.95	26.98	26.84	26.85	16383033.0
2004-11-19 16:00:00	MSFT	Stock	26.85	26.93	26.84	26.89	2436622.0
2004-11-19 17:00:00	MSFT	Stock	26.89	26.9022	26.83	26.85	75241.0
2004-11-19 18:00:00	MSFT	Stock	26.87	26.87	26.86	26.86	2900.0
2004-11-19 08:00:00	NVDA	Stock	0.1607	0.1625	0.1572	0.1587	6178800.0
2004-11-19 09:00:00	NVDA	Stock	0.1587	0.1752	0.1587	0.1702	543009360.0
2004-11-19 10:00:00	NVDA	Stock	0.1702	0.1711	0.1666	0.1667	412772640.0
2004-11-19 11:00:00	NVDA	Stock	0.1667	0.1668	0.1604	0.1621	297931200.0
2004-11-19 12:00:00	NVDA	Stock	0.1619	0.1619	0.1596	0.1599	224209320.0
2004-11-19 13:00:00	NVDA	Stock	0.1599	0.1604	0.1587	0.1602	160933800.0
2004-11-19 14:00:00	NVDA	Stock	0.1601	0.1603	0.1584	0.1587	144023520.0
2004-11-19 15:00:00	NVDA	Stock	0.1588	0.1593	0.1567	0.1581	245053800.0
2004-11-19 16:00:00	NVDA	Stock	0.1579	0.1583	0.1567	0.1577	12589320.0
2004-11-19 17:00:00	NVDA	Stock	0.1577	0.1592	0.1577	0.1592	1767240.0
2004-11-19 18:00:00	NVDA	Stock	0.1583	0.1592	0.1577	0.1583	326640.0
2004-11-19 08:00:00	AMZN	Stock	1.968	2.019	1.9455	1.9745	2119860.0
2004-11-19 09:00:00	AMZN	Stock	1.971	2.0075	1.934	1.9485	40455900.0
2004-11-19 10:00:00	AMZN	Stock	1.948	1.9685	1.945	1.96	26371220.0
2004-11-19 11:00:00	AMZN	Stock	1.961	1.9625	1.9385	1.9415	28187700.0
2004-11-19 12:00:00	AMZN	Stock	1.9415	1.946	1.9344	1.943	26775240.0
2004-11-19 13:00:00	AMZN	Stock	1.9435	1.95	1.94	1.94	16722980.0
2004-11-19 14:00:00	AMZN	Stock	1.94	1.9455	1.9325	1.937	21595560.0
2004-11-19 15:00:00	AMZN	Stock	1.937	1.9405	1.9095	1.926	56358460.0
2004-11-19 16:00:00	AMZN	Stock	1.9265	1.928	1.92	1.9276	2230720.0
2004-11-19 17:00:00	AMZN	Stock	1.9215	1.9275	1.9174	1.9275	262000.0
2004-11-19 18:00:00	AMZN	Stock	1.9255	1.928	1.9255	1.928	85240.0
2004-11-19 09:00:00	CL	Stock	23.45	23.45	23.345	23.38	777200.0
2004-11-19 10:00:00	CL	Stock	23.375	23.375	23.165	23.175	1137000.0
2004-11-19 11:00:00	CL	Stock	23.175	23.38	23.075	23.2	1133400.0
2004-11-19 12:00:00	CL	Stock	23.2	23.2	23.125	23.155	445400.0
2004-11-19 13:00:00	CL	Stock	23.155	23.225	23.155	23.19	470200.0
2004-11-19 14:00:00	CL	Stock	23.19	23.2	23.105	23.155	929800.0

> showing 50 of 25,210 rows — these rows as CSV

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