PREVIEW / stock_1hour / 2005-11-17

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-11-17.parquet
  size:    584 KB
  rows:    27,662
  symbols: 2,115

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-11-17 07:00:00	AAPL	Stock	2.3357	2.3357	2.3357	2.3357	180908.0
2005-11-17 08:00:00	AAPL	Stock	2.3357	2.3429	2.3286	2.3393	2907212.0
2005-11-17 09:00:00	AAPL	Stock	2.3396	2.3529	2.3243	2.3243	107692088.0
2005-11-17 10:00:00	AAPL	Stock	2.3246	2.3321	2.3054	2.3161	166495532.0
2005-11-17 11:00:00	AAPL	Stock	2.3164	2.3211	2.3039	2.3139	76566672.0
2005-11-17 12:00:00	AAPL	Stock	2.3139	2.3225	2.3089	2.315	52526096.0
2005-11-17 13:00:00	AAPL	Stock	2.3154	2.3214	2.3136	2.3182	38264996.0
2005-11-17 14:00:00	AAPL	Stock	2.3179	2.3279	2.3096	2.3125	67645368.0
2005-11-17 15:00:00	AAPL	Stock	2.3125	2.3161	2.2946	2.305	136566416.0
2005-11-17 16:00:00	AAPL	Stock	2.305	2.3093	2.3	2.3	2863308.0
2005-11-17 17:00:00	AAPL	Stock	2.3086	2.3086	2.3057	2.3068	43680.0
2005-11-17 18:00:00	AAPL	Stock	2.3068	2.3093	2.3068	2.3089	114800.0
2005-11-17 08:00:00	MSFT	Stock	27.81	27.89	27.8	27.81	3613500.0
2005-11-17 09:00:00	MSFT	Stock	27.8	28.0	27.8	27.91	12699494.0
2005-11-17 10:00:00	MSFT	Stock	27.91	27.959	27.76	27.85	19159081.0
2005-11-17 11:00:00	MSFT	Stock	27.85	27.93	27.83	27.87	6472133.0
2005-11-17 12:00:00	MSFT	Stock	27.86	27.88	27.77	27.85	8121497.0
2005-11-17 13:00:00	MSFT	Stock	27.86	27.92	27.84	27.88	8768963.0
2005-11-17 14:00:00	MSFT	Stock	27.89	27.95	27.82	27.84	7621821.0
2005-11-17 15:00:00	MSFT	Stock	27.84	28.0	27.84	27.97	20964370.0
2005-11-17 16:00:00	MSFT	Stock	27.97	28.029	27.887	27.99	1411394.0
2005-11-17 17:00:00	MSFT	Stock	27.99	28.0	27.97	27.99	11913.0
2005-11-17 18:00:00	MSFT	Stock	27.99	28.0	27.99	28.0	5536.0
2005-11-17 09:00:00	NVDA	Stock	0.2895	0.2921	0.2883	0.289	42740400.0
2005-11-17 10:00:00	NVDA	Stock	0.2892	0.2919	0.2889	0.2905	55534080.0
2005-11-17 11:00:00	NVDA	Stock	0.2905	0.3003	0.2904	0.2975	247561440.0
2005-11-17 12:00:00	NVDA	Stock	0.2977	0.2977	0.2955	0.2967	58201200.0
2005-11-17 13:00:00	NVDA	Stock	0.297	0.2972	0.296	0.2971	37102320.0
2005-11-17 14:00:00	NVDA	Stock	0.2972	0.3001	0.2968	0.2999	82973040.0
2005-11-17 15:00:00	NVDA	Stock	0.2999	0.3024	0.2993	0.3023	160754640.0
2005-11-17 16:00:00	NVDA	Stock	0.3023	0.3045	0.3013	0.3045	2258640.0
2005-11-17 17:00:00	NVDA	Stock	0.3046	0.3046	0.3025	0.3032	615360.0
2005-11-17 18:00:00	NVDA	Stock	0.3033	0.3033	0.3032	0.3032	168000.0
2005-11-17 08:00:00	AMZN	Stock	2.2815	2.2815	2.2715	2.2725	150300.0
2005-11-17 09:00:00	AMZN	Stock	2.2725	2.295	2.266	2.2865	28598620.0
2005-11-17 10:00:00	AMZN	Stock	2.287	2.305	2.2835	2.295	45300760.0
2005-11-17 11:00:00	AMZN	Stock	2.295	2.3005	2.2925	2.293	24602580.0
2005-11-17 12:00:00	AMZN	Stock	2.2935	2.3095	2.289	2.307	17376840.0
2005-11-17 13:00:00	AMZN	Stock	2.307	2.307	2.295	2.302	17000440.0
2005-11-17 14:00:00	AMZN	Stock	2.302	2.329	2.2975	2.3235	34377720.0
2005-11-17 15:00:00	AMZN	Stock	2.3225	2.338	2.319	2.336	57737760.0
2005-11-17 16:00:00	AMZN	Stock	2.3365	2.3525	2.3315	2.345	1162680.0
2005-11-17 17:00:00	AMZN	Stock	2.3485	2.3485	2.339	2.339	156000.0
2005-11-17 09:00:00	CL	Stock	26.78	26.845	26.73	26.8	462200.0
2005-11-17 10:00:00	CL	Stock	26.8	26.965	26.735	26.965	706000.0
2005-11-17 11:00:00	CL	Stock	26.97	27.05	26.95	27.01	790400.0
2005-11-17 12:00:00	CL	Stock	27.01	27.01	26.88	26.915	330000.0
2005-11-17 13:00:00	CL	Stock	26.91	26.92	26.825	26.9	296200.0
2005-11-17 14:00:00	CL	Stock	26.895	27.065	26.885	27.06	343000.0
2005-11-17 15:00:00	CL	Stock	27.065	27.15	27.04	27.075	680200.0

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

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