PREVIEW / stock_1hour / 2007-10-25

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-25.parquet
  size:    794 KB
  rows:    39,188
  symbols: 3,167

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
2007-10-25 04:00:00	AAPL	Stock	6.6429	6.6607	6.6393	6.6518	47600.0
2007-10-25 05:00:00	AAPL	Stock	6.66	6.675	6.66	6.675	89600.0
2007-10-25 06:00:00	AAPL	Stock	6.6786	6.7321	6.6786	6.7229	150640.0
2007-10-25 07:00:00	AAPL	Stock	6.7229	6.7675	6.7182	6.75	3190796.0
2007-10-25 08:00:00	AAPL	Stock	6.7432	6.7564	6.6693	6.6757	23907100.0
2007-10-25 09:00:00	AAPL	Stock	6.6732	6.6746	6.5271	6.5396	164693900.0
2007-10-25 10:00:00	AAPL	Stock	6.54	6.6393	6.5368	6.5904	195318732.0
2007-10-25 11:00:00	AAPL	Stock	6.5911	6.6229	6.55	6.5521	97616176.0
2007-10-25 12:00:00	AAPL	Stock	6.5521	6.5857	6.54	6.5679	82676020.0
2007-10-25 13:00:00	AAPL	Stock	6.5686	6.5696	6.5271	6.5457	97266148.0
2007-10-25 14:00:00	AAPL	Stock	6.5457	6.5571	6.4879	6.5514	150465364.0
2007-10-25 15:00:00	AAPL	Stock	6.5479	6.5618	6.5071	6.5279	142358804.0
2007-10-25 16:00:00	AAPL	Stock	6.5275	6.5979	6.5214	6.5943	11841732.0
2007-10-25 17:00:00	AAPL	Stock	6.5893	6.5893	6.5279	6.5279	1543528.0
2007-10-25 18:00:00	AAPL	Stock	6.5714	6.5839	6.5536	6.5768	1785420.0
2007-10-25 19:00:00	AAPL	Stock	6.575	6.5782	6.5714	6.5775	669900.0
2007-10-25 04:00:00	MSFT	Stock	31.61	31.61	31.61	31.61	300.0
2007-10-25 07:00:00	MSFT	Stock	31.69	31.69	31.44	31.5	17400.0
2007-10-25 08:00:00	MSFT	Stock	31.5	31.73	31.5	31.65	686082.0
2007-10-25 09:00:00	MSFT	Stock	31.64	31.74	31.25	31.71	19460999.0
2007-10-25 10:00:00	MSFT	Stock	31.7	32.12	31.65	31.89	29260745.0
2007-10-25 11:00:00	MSFT	Stock	31.89	32.0	31.75	31.84	16048039.0
2007-10-25 12:00:00	MSFT	Stock	31.84	31.91	31.75	31.77	9818383.0
2007-10-25 13:00:00	MSFT	Stock	31.76	31.97	31.73	31.97	13001202.0
2007-10-25 14:00:00	MSFT	Stock	31.968	32.19	31.91	32.15	16045516.0
2007-10-25 15:00:00	MSFT	Stock	32.16	32.22	31.99	32.0	28517861.0
2007-10-25 16:00:00	MSFT	Stock	32.0	36.02	31.83	35.6	30350179.0
2007-10-25 17:00:00	MSFT	Stock	35.6	35.85	31.99	35.76	5261297.0
2007-10-25 18:00:00	MSFT	Stock	35.78	35.8	35.32	35.32	1118577.0
2007-10-25 19:00:00	MSFT	Stock	35.4	35.58	31.14	35.56	344034.0
2007-10-25 08:00:00	NVDA	Stock	0.955	0.9588	0.9088	0.9332	3237240.0
2007-10-25 09:00:00	NVDA	Stock	0.9308	0.9308	0.91	0.9185	65642120.0
2007-10-25 10:00:00	NVDA	Stock	0.9185	0.9298	0.9185	0.929	75120960.0
2007-10-25 11:00:00	NVDA	Stock	0.929	0.93	0.8943	0.8943	86682560.0
2007-10-25 12:00:00	NVDA	Stock	0.8943	0.8968	0.8772	0.8812	110663760.0
2007-10-25 13:00:00	NVDA	Stock	0.881	0.8825	0.8398	0.8492	163740080.0
2007-10-25 14:00:00	NVDA	Stock	0.849	0.886	0.849	0.8845	124386200.0
2007-10-25 15:00:00	NVDA	Stock	0.8858	0.8875	0.8648	0.867	151860960.0
2007-10-25 16:00:00	NVDA	Stock	0.867	0.9	0.8645	0.89	16817040.0
2007-10-25 17:00:00	NVDA	Stock	0.89	0.8938	0.8838	0.8875	754840.0
2007-10-25 18:00:00	NVDA	Stock	0.8875	0.8905	0.8845	0.8875	210000.0
2007-10-25 19:00:00	NVDA	Stock	0.8875	0.8888	0.8842	0.8888	85720.0
2007-10-25 06:00:00	AMZN	Stock	4.425	4.425	4.425	4.425	4000.0
2007-10-25 07:00:00	AMZN	Stock	4.4365	4.444	4.4255	4.438	100360.0
2007-10-25 08:00:00	AMZN	Stock	4.4445	4.445	4.3785	4.4065	1032500.0
2007-10-25 09:00:00	AMZN	Stock	4.408	4.4245	4.325	4.3465	42550200.0
2007-10-25 10:00:00	AMZN	Stock	4.3465	4.418	4.316	4.406	42030960.0
2007-10-25 11:00:00	AMZN	Stock	4.4055	4.4135	4.362	4.382	31663080.0
2007-10-25 12:00:00	AMZN	Stock	4.3829	4.41	4.373	4.379	19991280.0
2007-10-25 13:00:00	AMZN	Stock	4.3795	4.4205	4.365	4.4015	25636400.0

> showing 50 of 39,188 rows — these rows as CSV

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