PREVIEW / stock_1hour / 2005-01-25

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-01-25.parquet
  size:    533 KB
  rows:    24,963
  symbols: 1,909

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-01-25 08:00:00	AAPL	Stock	1.2707	1.2779	1.2696	1.272	1620976.0
2005-01-25 09:00:00	AAPL	Stock	1.2723	1.2768	1.2668	1.2716	128751840.0
2005-01-25 10:00:00	AAPL	Stock	1.2716	1.2979	1.2696	1.2905	284963896.0
2005-01-25 11:00:00	AAPL	Stock	1.2905	1.3007	1.2902	1.2921	127253560.0
2005-01-25 12:00:00	AAPL	Stock	1.2921	1.2936	1.2863	1.2882	76471136.0
2005-01-25 13:00:00	AAPL	Stock	1.2882	1.2964	1.287	1.2904	110575640.0
2005-01-25 14:00:00	AAPL	Stock	1.2905	1.2909	1.2795	1.2891	100673720.0
2005-01-25 15:00:00	AAPL	Stock	1.2891	1.2932	1.2832	1.2868	126593488.0
2005-01-25 16:00:00	AAPL	Stock	1.2866	1.293	1.2825	1.2896	8811936.0
2005-01-25 17:00:00	AAPL	Stock	1.2893	1.2911	1.2886	1.2907	252000.0
2005-01-25 18:00:00	AAPL	Stock	1.29	1.2904	1.2893	1.2904	106400.0
2005-01-25 08:00:00	MSFT	Stock	25.8	25.81	25.79	25.8	16595.0
2005-01-25 09:00:00	MSFT	Stock	25.78	25.94	25.75	25.91	8169707.0
2005-01-25 10:00:00	MSFT	Stock	25.91	26.02	25.88	25.99	11561031.0
2005-01-25 11:00:00	MSFT	Stock	25.99	26.06	25.91	26.039	8513099.0
2005-01-25 12:00:00	MSFT	Stock	26.03	26.1	26.009	26.08	6749750.0
2005-01-25 13:00:00	MSFT	Stock	26.08	26.19	26.01	26.14	7809826.0
2005-01-25 14:00:00	MSFT	Stock	26.14	26.16	26.01	26.05	10222607.0
2005-01-25 15:00:00	MSFT	Stock	26.05	26.1	25.94	26.01	11992085.0
2005-01-25 16:00:00	MSFT	Stock	26.01	26.03	25.95	26.0	575664.0
2005-01-25 17:00:00	MSFT	Stock	26.03	26.03	26.0	26.03	9535.0
2005-01-25 18:00:00	MSFT	Stock	26.03	26.03	26.03	26.03	3285.0
2005-01-25 08:00:00	NVDA	Stock	0.1731	0.1737	0.1731	0.1737	168000.0
2005-01-25 09:00:00	NVDA	Stock	0.1733	0.1769	0.1712	0.1745	98222760.0
2005-01-25 10:00:00	NVDA	Stock	0.1745	0.1768	0.1742	0.1753	69856080.0
2005-01-25 11:00:00	NVDA	Stock	0.1753	0.1756	0.1739	0.1756	47704080.0
2005-01-25 12:00:00	NVDA	Stock	0.1754	0.1757	0.174	0.1742	48291480.0
2005-01-25 13:00:00	NVDA	Stock	0.1742	0.176	0.1742	0.1749	21924000.0
2005-01-25 14:00:00	NVDA	Stock	0.1749	0.1754	0.1742	0.1752	30346680.0
2005-01-25 15:00:00	NVDA	Stock	0.1752	0.1753	0.1726	0.1742	110902080.0
2005-01-25 16:00:00	NVDA	Stock	0.1742	0.1745	0.1734	0.1745	2998680.0
2005-01-25 08:00:00	AMZN	Stock	2.0235	2.0245	2.0235	2.024	82000.0
2005-01-25 09:00:00	AMZN	Stock	2.031	2.0535	2.0195	2.035	30135500.0
2005-01-25 10:00:00	AMZN	Stock	2.0355	2.072	2.0275	2.066	42234020.0
2005-01-25 11:00:00	AMZN	Stock	2.065	2.065	2.044	2.0475	35950280.0
2005-01-25 12:00:00	AMZN	Stock	2.0475	2.0695	2.045	2.0605	14511940.0
2005-01-25 13:00:00	AMZN	Stock	2.0605	2.072	2.06	2.0615	10907340.0
2005-01-25 14:00:00	AMZN	Stock	2.061	2.068	2.055	2.0644	12372580.0
2005-01-25 15:00:00	AMZN	Stock	2.0645	2.0645	2.0355	2.048	30346700.0
2005-01-25 16:00:00	AMZN	Stock	2.048	2.0505	2.0435	2.045	1804780.0
2005-01-25 17:00:00	AMZN	Stock	2.048	2.05	2.043	2.044	130000.0
2005-01-25 18:00:00	AMZN	Stock	2.051	2.051	2.051	2.051	40000.0
2005-01-25 09:00:00	CL	Stock	24.755	24.89	24.61	24.825	331200.0
2005-01-25 10:00:00	CL	Stock	24.825	24.91	24.762	24.765	610000.0
2005-01-25 11:00:00	CL	Stock	24.765	24.97	24.74	24.94	837400.0
2005-01-25 12:00:00	CL	Stock	24.94	24.945	24.83	24.89	1095400.0
2005-01-25 13:00:00	CL	Stock	24.895	24.97	24.85	24.95	712800.0
2005-01-25 14:00:00	CL	Stock	24.945	25.02	24.9	24.99	760000.0
2005-01-25 15:00:00	CL	Stock	24.99	25.0	24.875	24.905	976800.0
2005-01-25 16:00:00	CL	Stock	24.905	24.905	24.9	24.9	89200.0

> showing 50 of 24,963 rows — these rows as CSV

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