PREVIEW / stock_1hour / 2000-07-11

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-07-11.parquet
  size:    296 KB
  rows:    15,394
  symbols: 1,197

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
2000-07-11 08:00:00	AAPL	Stock	1.0179	1.0179	1.0179	1.0179	5600.0
2000-07-11 09:00:00	AAPL	Stock	1.0167	1.0536	0.99	1.0424	62300000.0
2000-07-11 10:00:00	AAPL	Stock	1.0368	1.0446	1.0335	1.0368	44553600.0
2000-07-11 11:00:00	AAPL	Stock	1.0379	1.0513	1.0379	1.0508	45180800.0
2000-07-11 12:00:00	AAPL	Stock	1.0502	1.058	1.0435	1.0491	54006400.0
2000-07-11 13:00:00	AAPL	Stock	1.0491	1.0513	1.0357	1.0368	39390400.0
2000-07-11 14:00:00	AAPL	Stock	1.0368	1.0391	1.0201	1.0201	57842400.0
2000-07-11 15:00:00	AAPL	Stock	1.0201	1.0279	1.01	1.0167	38948000.0
2000-07-11 16:00:00	AAPL	Stock	1.0179	1.0352	1.0167	1.0167	4373600.0
2000-07-11 17:00:00	AAPL	Stock	1.0167	1.0167	1.0167	1.0167	22400.0
2000-07-11 18:00:00	AAPL	Stock	1.0262	1.0352	1.0167	1.0223	212800.0
2000-07-11 08:00:00	MSFT	Stock	39.7188	39.7188	39.4375	39.4688	1262600.0
2000-07-11 09:00:00	MSFT	Stock	39.4688	39.875	39.25	39.5312	5337800.0
2000-07-11 10:00:00	MSFT	Stock	39.5625	40.0312	39.3125	39.8438	7817800.0
2000-07-11 11:00:00	MSFT	Stock	39.8438	40.0625	39.8125	39.9375	2890200.0
2000-07-11 12:00:00	MSFT	Stock	39.9062	40.25	39.8594	39.9375	3875600.0
2000-07-11 13:00:00	MSFT	Stock	39.9688	40.0	39.5	39.7188	4575000.0
2000-07-11 14:00:00	MSFT	Stock	39.7188	39.75	39.375	39.4688	4237200.0
2000-07-11 15:00:00	MSFT	Stock	39.4375	39.6875	39.2812	39.5	5212200.0
2000-07-11 16:00:00	MSFT	Stock	39.5625	39.875	39.375	39.875	1089600.0
2000-07-11 17:00:00	MSFT	Stock	39.5625	39.9375	39.5625	39.875	58200.0
2000-07-11 18:00:00	MSFT	Stock	39.875	39.9375	39.5625	39.9062	41400.0
2000-07-11 08:00:00	NVDA	Stock	0.2533	0.2533	0.2533	0.2533	10728000.0
2000-07-11 09:00:00	NVDA	Stock	0.2521	0.2682	0.2487	0.2646	54360000.0
2000-07-11 10:00:00	NVDA	Stock	0.2646	0.2672	0.2615	0.2638	82152000.0
2000-07-11 11:00:00	NVDA	Stock	0.2638	0.2703	0.263	0.2654	61968000.0
2000-07-11 12:00:00	NVDA	Stock	0.2651	0.2698	0.2651	0.2667	54888000.0
2000-07-11 13:00:00	NVDA	Stock	0.2667	0.2685	0.2625	0.268	84912000.0
2000-07-11 14:00:00	NVDA	Stock	0.268	0.2792	0.2672	0.277	114552000.0
2000-07-11 15:00:00	NVDA	Stock	0.2768	0.2885	0.2677	0.275	277392000.0
2000-07-11 16:00:00	NVDA	Stock	0.2753	0.2839	0.275	0.2755	5088000.0
2000-07-11 17:00:00	NVDA	Stock	0.2771	0.2813	0.2771	0.2813	144000.0
2000-07-11 18:00:00	NVDA	Stock	0.2799	0.2799	0.2799	0.2799	72000.0
2000-07-11 08:00:00	AMZN	Stock	1.75	1.8	1.75	1.775	1130000.0
2000-07-11 09:00:00	AMZN	Stock	1.775	1.7875	1.6594	1.6625	29648000.0
2000-07-11 10:00:00	AMZN	Stock	1.6656	1.6812	1.65	1.6688	41508000.0
2000-07-11 11:00:00	AMZN	Stock	1.6656	1.6812	1.6594	1.6656	14456000.0
2000-07-11 12:00:00	AMZN	Stock	1.6625	1.6656	1.65	1.65	27666000.0
2000-07-11 13:00:00	AMZN	Stock	1.6531	1.6625	1.6312	1.6469	23084000.0
2000-07-11 14:00:00	AMZN	Stock	1.65	1.6625	1.6344	1.6469	16014000.0
2000-07-11 15:00:00	AMZN	Stock	1.6469	1.6625	1.6375	1.65	38406000.0
2000-07-11 16:00:00	AMZN	Stock	1.6531	1.75	1.6531	1.725	2724000.0
2000-07-11 17:00:00	AMZN	Stock	1.6562	1.775	1.6562	1.7734	1640000.0
2000-07-11 18:00:00	AMZN	Stock	1.7719	1.7875	1.7562	1.7719	172000.0
2000-07-11 09:00:00	CL	Stock	27.875	27.9688	27.625	27.625	510800.0
2000-07-11 10:00:00	CL	Stock	27.625	27.75	27.1875	27.3125	1655200.0
2000-07-11 11:00:00	CL	Stock	27.2812	27.3125	26.7812	27.0	849800.0
2000-07-11 12:00:00	CL	Stock	26.9688	27.1875	26.9688	27.1875	236200.0
2000-07-11 13:00:00	CL	Stock	27.1875	27.25	26.9688	27.0	430200.0
2000-07-11 14:00:00	CL	Stock	27.0312	27.1562	26.8438	26.875	764000.0

> showing 50 of 15,394 rows — these rows as CSV

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