PREVIEW / stock_1hour / 2005-10-26

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-10-26.parquet
  size:    565 KB
  rows:    26,613
  symbols: 2,096

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-10-26 07:00:00	AAPL	Stock	2.0071	2.0089	2.0071	2.0089	65800.0
2005-10-26 08:00:00	AAPL	Stock	2.0107	2.0161	2.0018	2.0036	631344.0
2005-10-26 09:00:00	AAPL	Stock	2.0036	2.0264	1.9971	2.0211	71177848.0
2005-10-26 10:00:00	AAPL	Stock	2.0211	2.0536	2.0189	2.0522	165663316.0
2005-10-26 11:00:00	AAPL	Stock	2.0525	2.0546	2.0407	2.0414	94299856.0
2005-10-26 12:00:00	AAPL	Stock	2.0414	2.0518	2.0386	2.0479	52763088.0
2005-10-26 13:00:00	AAPL	Stock	2.0479	2.0493	2.0279	2.0396	70320432.0
2005-10-26 14:00:00	AAPL	Stock	2.0393	2.0486	2.0382	2.0471	60869872.0
2005-10-26 15:00:00	AAPL	Stock	2.0471	2.0557	2.0296	2.0371	106220884.0
2005-10-26 16:00:00	AAPL	Stock	2.0364	2.0407	2.0286	2.0343	2521344.0
2005-10-26 17:00:00	AAPL	Stock	2.0346	2.0368	2.0346	2.0361	339920.0
2005-10-26 18:00:00	AAPL	Stock	2.0407	2.0407	2.0346	2.0346	244440.0
2005-10-26 08:00:00	MSFT	Stock	25.03	25.03	24.96	24.96	20875.0
2005-10-26 09:00:00	MSFT	Stock	24.96	25.17	24.9	25.15	7336066.0
2005-10-26 10:00:00	MSFT	Stock	25.16	25.23	25.1	25.19	10493834.0
2005-10-26 11:00:00	MSFT	Stock	25.19	25.32	25.16	25.25	10234968.0
2005-10-26 12:00:00	MSFT	Stock	25.26	25.3	25.16	25.26	6178503.0
2005-10-26 13:00:00	MSFT	Stock	25.27	25.33	25.13	25.19	6658026.0
2005-10-26 14:00:00	MSFT	Stock	25.19	25.27	25.17	25.23	5942907.0
2005-10-26 15:00:00	MSFT	Stock	25.23	25.24	25.02	25.12	9492288.0
2005-10-26 16:00:00	MSFT	Stock	25.12	25.15	25.1	25.13	286944.0
2005-10-26 17:00:00	MSFT	Stock	25.13	25.15	25.11	25.13	21510.0
2005-10-26 18:00:00	MSFT	Stock	25.15	25.17	25.13	25.17	7437.0
2005-10-26 09:00:00	NVDA	Stock	0.2754	0.2758	0.2729	0.2744	45366720.0
2005-10-26 10:00:00	NVDA	Stock	0.2745	0.2755	0.273	0.2741	89993880.0
2005-10-26 11:00:00	NVDA	Stock	0.2742	0.2749	0.2733	0.2742	39271800.0
2005-10-26 12:00:00	NVDA	Stock	0.2742	0.2744	0.2733	0.2741	29938200.0
2005-10-26 13:00:00	NVDA	Stock	0.274	0.2743	0.2711	0.272	50981040.0
2005-10-26 14:00:00	NVDA	Stock	0.2719	0.2735	0.2709	0.2712	35866440.0
2005-10-26 15:00:00	NVDA	Stock	0.271	0.2716	0.2672	0.2677	105636360.0
2005-10-26 16:00:00	NVDA	Stock	0.2673	0.2685	0.2673	0.2682	1345800.0
2005-10-26 17:00:00	NVDA	Stock	0.2677	0.2677	0.2677	0.2677	12000.0
2005-10-26 07:00:00	AMZN	Stock	2.08	2.08	2.026	2.055	2424200.0
2005-10-26 08:00:00	AMZN	Stock	2.06	2.087	2.044	2.0695	19290440.0
2005-10-26 09:00:00	AMZN	Stock	2.0695	2.0725	2.003	2.041	167895700.0
2005-10-26 10:00:00	AMZN	Stock	2.041	2.055	2.0215	2.04	97245840.0
2005-10-26 11:00:00	AMZN	Stock	2.0395	2.0395	2.0125	2.0145	46957300.0
2005-10-26 12:00:00	AMZN	Stock	2.0145	2.019	2.005	2.0085	40083740.0
2005-10-26 13:00:00	AMZN	Stock	2.0085	2.0145	2.0005	2.0055	51790620.0
2005-10-26 14:00:00	AMZN	Stock	2.0055	2.01	1.993	1.998	60113880.0
2005-10-26 15:00:00	AMZN	Stock	1.998	2.001	1.974	1.987	107289960.0
2005-10-26 16:00:00	AMZN	Stock	1.992	2.0054	1.9775	1.983	1685280.0
2005-10-26 17:00:00	AMZN	Stock	1.983	1.9915	1.9815	1.9915	542760.0
2005-10-26 18:00:00	AMZN	Stock	1.9875	1.9915	1.9875	1.9915	18160.0
2005-10-26 09:00:00	CL	Stock	26.05	26.255	26.045	26.255	312200.0
2005-10-26 10:00:00	CL	Stock	26.285	26.395	26.19	26.275	482000.0
2005-10-26 11:00:00	CL	Stock	26.275	26.355	26.19	26.23	445800.0
2005-10-26 12:00:00	CL	Stock	26.235	26.2695	26.185	26.24	241000.0
2005-10-26 13:00:00	CL	Stock	26.24	26.26	26.135	26.185	298800.0
2005-10-26 14:00:00	CL	Stock	26.185	26.295	26.175	26.205	380000.0

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

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