PREVIEW / stock_1hour / 2005-02-17

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-02-17.parquet
  size:    558 KB
  rows:    26,521
  symbols: 1,934

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
2005-02-17 08:00:00	AAPL	Stock	1.6146	1.6241	1.6143	1.6196	7823368.0
2005-02-17 09:00:00	AAPL	Stock	1.6195	1.6241	1.6014	1.6071	258911912.0
2005-02-17 10:00:00	AAPL	Stock	1.607	1.6075	1.5789	1.592	339698968.0
2005-02-17 11:00:00	AAPL	Stock	1.592	1.6013	1.5875	1.6002	128939608.0
2005-02-17 12:00:00	AAPL	Stock	1.6	1.6054	1.597	1.5996	93269960.0
2005-02-17 13:00:00	AAPL	Stock	1.5995	1.6025	1.5821	1.585	132365296.0
2005-02-17 14:00:00	AAPL	Stock	1.585	1.59	1.5616	1.5698	293534136.0
2005-02-17 15:00:00	AAPL	Stock	1.5702	1.5838	1.5675	1.568	248839696.0
2005-02-17 16:00:00	AAPL	Stock	1.5684	1.5781	1.567	1.5684	7702072.0
2005-02-17 17:00:00	AAPL	Stock	1.5684	1.5695	1.5659	1.5679	2770936.0
2005-02-17 18:00:00	AAPL	Stock	1.5684	1.5689	1.567	1.5689	1565928.0
2005-02-17 08:00:00	MSFT	Stock	25.79	25.79	25.76	25.76	207463.0
2005-02-17 09:00:00	MSFT	Stock	25.77	25.86	25.7	25.84	7243733.0
2005-02-17 10:00:00	MSFT	Stock	25.84	25.841	25.67	25.68	11085746.0
2005-02-17 11:00:00	MSFT	Stock	25.68	25.7	25.65	25.68	8119749.0
2005-02-17 12:00:00	MSFT	Stock	25.68	25.7	25.61	25.67	5416579.0
2005-02-17 13:00:00	MSFT	Stock	25.67	25.72	25.649	25.69	6234345.0
2005-02-17 14:00:00	MSFT	Stock	25.69	25.711	25.61	25.632	10302842.0
2005-02-17 15:00:00	MSFT	Stock	25.64	25.73	25.6	25.6	14487049.0
2005-02-17 16:00:00	MSFT	Stock	25.63	25.67	25.6	25.64	1510510.0
2005-02-17 17:00:00	MSFT	Stock	25.63	25.689	25.63	25.63	24592.0
2005-02-17 18:00:00	MSFT	Stock	25.64	25.643	25.63	25.63	150770.0
2005-02-17 08:00:00	NVDA	Stock	0.2142	0.2177	0.2142	0.2177	36000.0
2005-02-17 09:00:00	NVDA	Stock	0.2145	0.2175	0.2142	0.2155	95966400.0
2005-02-17 10:00:00	NVDA	Stock	0.2153	0.2158	0.2109	0.2127	146599800.0
2005-02-17 11:00:00	NVDA	Stock	0.2127	0.2171	0.2122	0.216	161325960.0
2005-02-17 12:00:00	NVDA	Stock	0.216	0.2165	0.2146	0.2152	86984520.0
2005-02-17 13:00:00	NVDA	Stock	0.2152	0.2162	0.2148	0.2151	95506560.0
2005-02-17 14:00:00	NVDA	Stock	0.2151	0.2164	0.2146	0.2148	114972720.0
2005-02-17 15:00:00	NVDA	Stock	0.2149	0.2159	0.2122	0.2123	241849680.0
2005-02-17 16:00:00	NVDA	Stock	0.2121	0.2204	0.2106	0.2136	60234840.0
2005-02-17 17:00:00	NVDA	Stock	0.2137	0.2345	0.2137	0.2341	189184320.0
2005-02-17 18:00:00	NVDA	Stock	0.2342	0.2392	0.2333	0.236	27137280.0
2005-02-17 08:00:00	AMZN	Stock	1.781	1.781	1.781	1.781	2000.0
2005-02-17 09:00:00	AMZN	Stock	1.783	1.7905	1.775	1.7785	11605860.0
2005-02-17 10:00:00	AMZN	Stock	1.7785	1.784	1.7625	1.7715	22925180.0
2005-02-17 11:00:00	AMZN	Stock	1.7705	1.7775	1.7675	1.7755	10478440.0
2005-02-17 12:00:00	AMZN	Stock	1.775	1.787	1.774	1.786	8585540.0
2005-02-17 13:00:00	AMZN	Stock	1.7855	1.7905	1.763	1.7805	6940940.0
2005-02-17 14:00:00	AMZN	Stock	1.7805	1.787	1.774	1.7795	11955580.0
2005-02-17 15:00:00	AMZN	Stock	1.7795	1.7925	1.7765	1.785	24675760.0
2005-02-17 16:00:00	AMZN	Stock	1.785	1.789	1.7825	1.789	663400.0
2005-02-17 17:00:00	AMZN	Stock	1.7835	1.7861	1.7835	1.7861	13800.0
2005-02-17 18:00:00	AMZN	Stock	1.7888	1.7892	1.7888	1.789	536980.0
2005-02-17 09:00:00	CL	Stock	27.0	27.04	26.88	26.915	525000.0
2005-02-17 10:00:00	CL	Stock	26.915	26.955	26.795	26.89	735200.0
2005-02-17 11:00:00	CL	Stock	26.88	27.12	26.85	27.035	1186800.0
2005-02-17 12:00:00	CL	Stock	27.03	27.07	26.96	26.985	501800.0
2005-02-17 13:00:00	CL	Stock	26.985	27.0	26.94	26.95	214800.0
2005-02-17 14:00:00	CL	Stock	26.95	26.99	26.915	26.945	410000.0

> showing 50 of 26,521 rows — these rows as CSV

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