PREVIEW / stock_1hour / 2005-12-13

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-12-13.parquet
  size:    582 KB
  rows:    27,441
  symbols: 2,137

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-13 07:00:00	AAPL	Stock	2.6714	2.6714	2.6714	2.6714	11200.0
2005-12-13 08:00:00	AAPL	Stock	2.675	2.675	2.6468	2.6607	2359644.0
2005-12-13 09:00:00	AAPL	Stock	2.6614	2.6771	2.6504	2.66	68470164.0
2005-12-13 10:00:00	AAPL	Stock	2.6596	2.6804	2.6589	2.6657	79677920.0
2005-12-13 11:00:00	AAPL	Stock	2.6657	2.6739	2.6607	2.67	32911480.0
2005-12-13 12:00:00	AAPL	Stock	2.67	2.6768	2.6689	2.6707	27169128.0
2005-12-13 13:00:00	AAPL	Stock	2.6704	2.6807	2.67	2.6728	34604416.0
2005-12-13 14:00:00	AAPL	Stock	2.6725	2.695	2.6679	2.6811	143835664.0
2005-12-13 15:00:00	AAPL	Stock	2.6811	2.6814	2.6707	2.6779	93696764.0
2005-12-13 16:00:00	AAPL	Stock	2.6779	2.6804	2.6734	2.6754	5520284.0
2005-12-13 17:00:00	AAPL	Stock	2.6771	2.6786	2.675	2.6757	326368.0
2005-12-13 18:00:00	AAPL	Stock	2.675	2.6764	2.6729	2.6764	256872.0
2005-12-13 08:00:00	MSFT	Stock	27.43	27.43	27.35	27.35	7900.0
2005-12-13 09:00:00	MSFT	Stock	27.35	27.43	27.26	27.33	6547654.0
2005-12-13 10:00:00	MSFT	Stock	27.33	27.38	27.25	27.29	11724670.0
2005-12-13 11:00:00	MSFT	Stock	27.28	27.29	27.16	27.19	11334093.0
2005-12-13 12:00:00	MSFT	Stock	27.19	27.2	27.0	27.03	14638457.0
2005-12-13 13:00:00	MSFT	Stock	27.03	27.28	27.0	27.05	8899873.0
2005-12-13 14:00:00	MSFT	Stock	27.04	27.21	27.0	27.16	20360501.0
2005-12-13 15:00:00	MSFT	Stock	27.16	27.18	27.05	27.15	18082502.0
2005-12-13 16:00:00	MSFT	Stock	27.15	27.17	27.12	27.12	10642015.0
2005-12-13 17:00:00	MSFT	Stock	27.15	27.15	27.12	27.13	103436.0
2005-12-13 18:00:00	MSFT	Stock	27.13	27.13	27.11	27.11	1965.0
2005-12-13 09:00:00	NVDA	Stock	0.3066	0.3081	0.3056	0.3062	20358600.0
2005-12-13 10:00:00	NVDA	Stock	0.3061	0.3082	0.3061	0.3073	40296720.0
2005-12-13 11:00:00	NVDA	Stock	0.3073	0.3077	0.3065	0.3073	50226360.0
2005-12-13 12:00:00	NVDA	Stock	0.3073	0.3087	0.3072	0.3086	60265320.0
2005-12-13 13:00:00	NVDA	Stock	0.3086	0.3096	0.3083	0.3086	58201680.0
2005-12-13 14:00:00	NVDA	Stock	0.3087	0.3139	0.3087	0.3132	108218160.0
2005-12-13 15:00:00	NVDA	Stock	0.3133	0.3133	0.3102	0.3116	88351800.0
2005-12-13 16:00:00	NVDA	Stock	0.3112	0.3114	0.3096	0.3102	3216000.0
2005-12-13 17:00:00	NVDA	Stock	0.3112	0.3112	0.3112	0.3112	612000.0
2005-12-13 08:00:00	AMZN	Stock	2.428	2.4535	2.4255	2.434	439000.0
2005-12-13 09:00:00	AMZN	Stock	2.432	2.4575	2.424	2.4445	15210880.0
2005-12-13 10:00:00	AMZN	Stock	2.4445	2.4635	2.4405	2.4475	15273880.0
2005-12-13 11:00:00	AMZN	Stock	2.4475	2.449	2.44	2.4485	6608280.0
2005-12-13 12:00:00	AMZN	Stock	2.448	2.4565	2.446	2.4475	7717080.0
2005-12-13 13:00:00	AMZN	Stock	2.4475	2.4655	2.4475	2.459	9650680.0
2005-12-13 14:00:00	AMZN	Stock	2.459	2.4825	2.4515	2.4745	26726620.0
2005-12-13 15:00:00	AMZN	Stock	2.475	2.4835	2.461	2.474	28976160.0
2005-12-13 16:00:00	AMZN	Stock	2.4735	2.483	2.4735	2.475	3129720.0
2005-12-13 17:00:00	AMZN	Stock	2.479	2.479	2.475	2.4775	30200.0
2005-12-13 09:00:00	CL	Stock	27.375	27.5	27.365	27.46	342200.0
2005-12-13 10:00:00	CL	Stock	27.455	27.7	27.45	27.67	439400.0
2005-12-13 11:00:00	CL	Stock	27.67	27.73	27.615	27.7	600200.0
2005-12-13 12:00:00	CL	Stock	27.7	27.725	27.67	27.69	324400.0
2005-12-13 13:00:00	CL	Stock	27.69	27.71	27.63	27.64	564000.0
2005-12-13 14:00:00	CL	Stock	27.64	27.8	27.63	27.77	529400.0
2005-12-13 15:00:00	CL	Stock	27.77	27.825	27.725	27.82	817000.0
2005-12-13 16:00:00	CL	Stock	27.825	27.825	27.825	27.825	29200.0

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

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