PREVIEW / stock_1hour / 2005-09-19

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-09-19.parquet
  size:    573 KB
  rows:    27,233
  symbols: 2,062

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-09-19 08:00:00	AAPL	Stock	1.8282	1.8361	1.8225	1.8289	1110872.0
2005-09-19 09:00:00	AAPL	Stock	1.8289	1.86	1.8232	1.8432	114588992.0
2005-09-19 10:00:00	AAPL	Stock	1.8432	1.8832	1.8432	1.8736	183839600.0
2005-09-19 11:00:00	AAPL	Stock	1.8736	1.8807	1.8693	1.8725	80286304.0
2005-09-19 12:00:00	AAPL	Stock	1.8725	1.8836	1.8704	1.8804	47882464.0
2005-09-19 13:00:00	AAPL	Stock	1.88	1.8889	1.8796	1.8843	60480924.0
2005-09-19 14:00:00	AAPL	Stock	1.8843	1.885	1.865	1.8693	83939660.0
2005-09-19 15:00:00	AAPL	Stock	1.8693	1.8854	1.8682	1.8807	105534464.0
2005-09-19 16:00:00	AAPL	Stock	1.88	1.8868	1.8776	1.8807	51674756.0
2005-09-19 17:00:00	AAPL	Stock	1.8821	1.8821	1.8789	1.8811	86352.0
2005-09-19 18:00:00	AAPL	Stock	1.8814	1.8814	1.8814	1.8814	47544.0
2005-09-19 07:00:00	MSFT	Stock	26.13	26.13	26.13	26.13	100.0
2005-09-19 08:00:00	MSFT	Stock	26.14	26.15	26.07	26.12	39665.0
2005-09-19 09:00:00	MSFT	Stock	26.12	26.27	26.06	26.25	12623275.0
2005-09-19 10:00:00	MSFT	Stock	26.24	26.25	26.07	26.1	10106717.0
2005-09-19 11:00:00	MSFT	Stock	26.1	26.17	26.08	26.1	5733212.0
2005-09-19 12:00:00	MSFT	Stock	26.102	26.15	26.05	26.07	4070250.0
2005-09-19 13:00:00	MSFT	Stock	26.06	26.1	25.97	26.03	5885622.0
2005-09-19 14:00:00	MSFT	Stock	26.02	26.03	25.899	25.9	6120074.0
2005-09-19 15:00:00	MSFT	Stock	25.9	26.03	25.86	26.0	14233160.0
2005-09-19 16:00:00	MSFT	Stock	26.01	26.066	25.959	26.01	523160.0
2005-09-19 17:00:00	MSFT	Stock	26.01	26.03	26.01	26.02	20535.0
2005-09-19 18:00:00	MSFT	Stock	26.0	26.02	26.0	26.02	4000.0
2005-09-19 09:00:00	NVDA	Stock	0.2767	0.2777	0.275	0.2757	44647920.0
2005-09-19 10:00:00	NVDA	Stock	0.2757	0.2757	0.2737	0.2749	112579320.0
2005-09-19 11:00:00	NVDA	Stock	0.2748	0.2752	0.2721	0.2724	65768280.0
2005-09-19 12:00:00	NVDA	Stock	0.2725	0.2732	0.2722	0.2725	28001040.0
2005-09-19 13:00:00	NVDA	Stock	0.2725	0.274	0.2722	0.2732	34626840.0
2005-09-19 14:00:00	NVDA	Stock	0.2733	0.2737	0.2717	0.2732	45503160.0
2005-09-19 15:00:00	NVDA	Stock	0.2732	0.2745	0.2721	0.2727	88005240.0
2005-09-19 16:00:00	NVDA	Stock	0.2729	0.2738	0.2728	0.2736	1462440.0
2005-09-19 17:00:00	NVDA	Stock	0.2737	0.2745	0.2737	0.2745	48000.0
2005-09-19 08:00:00	AMZN	Stock	2.1375	2.1375	2.1335	2.1335	8000.0
2005-09-19 09:00:00	AMZN	Stock	2.1355	2.1515	2.127	2.1445	8204560.0
2005-09-19 10:00:00	AMZN	Stock	2.1445	2.1715	2.137	2.1385	16685340.0
2005-09-19 11:00:00	AMZN	Stock	2.1385	2.147	2.114	2.1175	11713540.0
2005-09-19 12:00:00	AMZN	Stock	2.117	2.1245	2.1085	2.1215	7762300.0
2005-09-19 13:00:00	AMZN	Stock	2.1215	2.122	2.116	2.118	3190700.0
2005-09-19 14:00:00	AMZN	Stock	2.118	2.1235	2.1095	2.1215	5350980.0
2005-09-19 15:00:00	AMZN	Stock	2.122	2.1415	2.1215	2.137	14497580.0
2005-09-19 16:00:00	AMZN	Stock	2.1375	2.143	2.137	2.143	131260.0
2005-09-19 17:00:00	AMZN	Stock	2.14	2.14	2.138	2.138	50000.0
2005-09-19 18:00:00	AMZN	Stock	2.139	2.139	2.1325	2.1325	78540.0
2005-09-19 09:00:00	CL	Stock	26.715	26.775	26.51	26.56	242200.0
2005-09-19 10:00:00	CL	Stock	26.575	26.6	26.38	26.38	337800.0
2005-09-19 11:00:00	CL	Stock	26.385	26.4	26.315	26.335	256200.0
2005-09-19 12:00:00	CL	Stock	26.335	26.405	26.31	26.39	298000.0
2005-09-19 13:00:00	CL	Stock	26.395	26.41	26.34	26.365	186600.0
2005-09-19 14:00:00	CL	Stock	26.365	26.395	26.255	26.295	294600.0
2005-09-19 15:00:00	CL	Stock	26.295	26.405	26.275	26.385	589800.0

> showing 50 of 27,233 rows — these rows as CSV

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