PREVIEW / stock_1hour / 2005-12-20

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-12-20.parquet
  size:    579 KB
  rows:    27,585
  symbols: 2,152

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-12-20 07:00:00	AAPL	Stock	2.5621	2.5625	2.5621	2.5625	36400.0
2005-12-20 08:00:00	AAPL	Stock	2.5625	2.5643	2.5557	2.5579	1413440.0
2005-12-20 09:00:00	AAPL	Stock	2.5589	2.5707	2.5421	2.5461	67849544.0
2005-12-20 10:00:00	AAPL	Stock	2.5464	2.5754	2.54	2.57	91320684.0
2005-12-20 11:00:00	AAPL	Stock	2.57	2.5775	2.5614	2.5639	51995048.0
2005-12-20 12:00:00	AAPL	Stock	2.5643	2.585	2.5636	2.5768	59558520.0
2005-12-20 13:00:00	AAPL	Stock	2.5775	2.5839	2.5696	2.5696	45385844.0
2005-12-20 14:00:00	AAPL	Stock	2.5696	2.5732	2.5543	2.5614	69052116.0
2005-12-20 15:00:00	AAPL	Stock	2.5611	2.5779	2.5546	2.5764	74925592.0
2005-12-20 16:00:00	AAPL	Stock	2.5754	2.58	2.575	2.5786	1595832.0
2005-12-20 17:00:00	AAPL	Stock	2.5789	2.5789	2.5689	2.5757	181664.0
2005-12-20 18:00:00	AAPL	Stock	2.5693	2.5739	2.565	2.5679	124544.0
2005-12-20 07:00:00	MSFT	Stock	26.86	26.86	26.86	26.86	2000.0
2005-12-20 08:00:00	MSFT	Stock	26.85	26.85	26.82	26.83	11047.0
2005-12-20 09:00:00	MSFT	Stock	26.84	26.84	26.67	26.76	5684882.0
2005-12-20 10:00:00	MSFT	Stock	26.76	26.85	26.71	26.82	9833768.0
2005-12-20 11:00:00	MSFT	Stock	26.83	26.84	26.735	26.75	6839103.0
2005-12-20 12:00:00	MSFT	Stock	26.76	26.79	26.715	26.79	6594209.0
2005-12-20 13:00:00	MSFT	Stock	26.79	26.82	26.75	26.8	7574003.0
2005-12-20 14:00:00	MSFT	Stock	26.8	26.84	26.76	26.83	8235517.0
2005-12-20 15:00:00	MSFT	Stock	26.82	26.88	26.8	26.87	15491122.0
2005-12-20 16:00:00	MSFT	Stock	26.86	26.89	26.782	26.86	694717.0
2005-12-20 17:00:00	MSFT	Stock	26.86	26.86	26.85	26.85	230980.0
2005-12-20 18:00:00	MSFT	Stock	26.86	26.86	26.85	26.85	380.0
2005-12-20 08:00:00	NVDA	Stock	0.3017	0.3017	0.3017	0.3017	180000.0
2005-12-20 09:00:00	NVDA	Stock	0.3017	0.3037	0.3001	0.3036	25659240.0
2005-12-20 10:00:00	NVDA	Stock	0.3035	0.3035	0.2978	0.3012	60843360.0
2005-12-20 11:00:00	NVDA	Stock	0.3012	0.3057	0.3012	0.304	36652200.0
2005-12-20 12:00:00	NVDA	Stock	0.3039	0.3062	0.3032	0.3049	36632760.0
2005-12-20 13:00:00	NVDA	Stock	0.3047	0.3057	0.3034	0.3046	37014240.0
2005-12-20 14:00:00	NVDA	Stock	0.3046	0.3046	0.302	0.302	16636680.0
2005-12-20 15:00:00	NVDA	Stock	0.302	0.3022	0.3002	0.3018	45143040.0
2005-12-20 16:00:00	NVDA	Stock	0.3013	0.3018	0.2993	0.3018	7834320.0
2005-12-20 17:00:00	NVDA	Stock	0.3005	0.3005	0.3005	0.3005	108000.0
2005-12-20 08:00:00	AMZN	Stock	2.43	2.4475	2.4225	2.4225	58000.0
2005-12-20 09:00:00	AMZN	Stock	2.4225	2.43	2.3935	2.403	17170780.0
2005-12-20 10:00:00	AMZN	Stock	2.403	2.407	2.384	2.4046	28676620.0
2005-12-20 11:00:00	AMZN	Stock	2.4045	2.4155	2.399	2.3995	11218360.0
2005-12-20 12:00:00	AMZN	Stock	2.399	2.4145	2.399	2.414	8643800.0
2005-12-20 13:00:00	AMZN	Stock	2.4135	2.4205	2.404	2.408	7979100.0
2005-12-20 14:00:00	AMZN	Stock	2.4085	2.4125	2.398	2.399	10140080.0
2005-12-20 15:00:00	AMZN	Stock	2.3985	2.4115	2.3935	2.4065	24008840.0
2005-12-20 16:00:00	AMZN	Stock	2.407	2.4115	2.405	2.405	546660.0
2005-12-20 17:00:00	AMZN	Stock	2.405	2.405	2.405	2.405	4560.0
2005-12-20 09:00:00	CL	Stock	27.975	28.03	27.89	27.935	177400.0
2005-12-20 10:00:00	CL	Stock	27.935	27.945	27.685	27.69	557200.0
2005-12-20 11:00:00	CL	Stock	27.69	27.835	27.69	27.78	799800.0
2005-12-20 12:00:00	CL	Stock	27.78	27.84	27.75	27.84	591800.0
2005-12-20 13:00:00	CL	Stock	27.84	27.9	27.835	27.855	353400.0
2005-12-20 14:00:00	CL	Stock	27.855	27.86	27.775	27.8	346200.0

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

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