PREVIEW / stock_1hour / 2009-04-22

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-04-22.parquet
  size:    820 KB
  rows:    40,242
  symbols: 3,312

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
2009-04-22 05:00:00	AAPL	Stock	4.3171	4.3171	4.3171	4.3171	5600.0
2009-04-22 06:00:00	AAPL	Stock	4.3125	4.3214	4.3125	4.3214	19600.0
2009-04-22 07:00:00	AAPL	Stock	4.3325	4.3571	4.3196	4.3482	146692.0
2009-04-22 08:00:00	AAPL	Stock	4.3429	4.3882	4.3361	4.3821	3092432.0
2009-04-22 09:00:00	AAPL	Stock	4.3789	4.4468	4.3668	4.4431	108249036.0
2009-04-22 10:00:00	AAPL	Stock	4.4429	4.4768	4.4325	4.4485	113483972.0
2009-04-22 11:00:00	AAPL	Stock	4.4489	4.4625	4.4204	4.4557	67106284.0
2009-04-22 12:00:00	AAPL	Stock	4.4557	4.4696	4.3957	4.4118	82590760.0
2009-04-22 13:00:00	AAPL	Stock	4.4114	4.4536	4.3736	4.3834	82043192.0
2009-04-22 14:00:00	AAPL	Stock	4.3834	4.4464	4.3754	4.4268	93172044.0
2009-04-22 15:00:00	AAPL	Stock	4.4268	4.4454	4.3286	4.3411	177938320.0
2009-04-22 16:00:00	AAPL	Stock	4.33	4.5339	4.2857	4.4821	120658188.0
2009-04-22 17:00:00	AAPL	Stock	4.4836	4.5171	4.3779	4.4436	62218324.0
2009-04-22 18:00:00	AAPL	Stock	4.4418	4.4714	4.4321	4.4639	5347524.0
2009-04-22 19:00:00	AAPL	Stock	4.4636	4.475	4.4554	4.4679	2183608.0
2009-04-22 08:00:00	MSFT	Stock	18.88	18.95	18.76	18.76	15622.0
2009-04-22 09:00:00	MSFT	Stock	18.8	19.0	18.7	18.97	5349661.0
2009-04-22 10:00:00	MSFT	Stock	18.97	19.19	18.89	18.908	10087675.0
2009-04-22 11:00:00	MSFT	Stock	18.91	19.1	18.849	18.96	5898831.0
2009-04-22 12:00:00	MSFT	Stock	18.96	18.96	18.76	18.81	5638098.0
2009-04-22 13:00:00	MSFT	Stock	18.8	18.96	18.8	18.84	8647012.0
2009-04-22 14:00:00	MSFT	Stock	18.83	19.08	18.83	19.03	6263241.0
2009-04-22 15:00:00	MSFT	Stock	19.03	19.17	18.72	18.77	13389627.0
2009-04-22 16:00:00	MSFT	Stock	18.77	19.061	18.52	18.8	2377500.0
2009-04-22 17:00:00	MSFT	Stock	18.8	19.0	18.8	19.0	72713.0
2009-04-22 18:00:00	MSFT	Stock	19.0	19.0	18.78	18.97	182540.0
2009-04-22 19:00:00	MSFT	Stock	18.96	18.97	18.95	18.97	20700.0
2009-04-22 08:00:00	NVDA	Stock	0.275	0.2758	0.275	0.2758	56000.0
2009-04-22 09:00:00	NVDA	Stock	0.275	0.281	0.2685	0.2805	89907040.0
2009-04-22 10:00:00	NVDA	Stock	0.2808	0.2898	0.2803	0.2848	156777840.0
2009-04-22 11:00:00	NVDA	Stock	0.2848	0.29	0.2842	0.2895	94155840.0
2009-04-22 12:00:00	NVDA	Stock	0.2895	0.2925	0.2848	0.2888	123185000.0
2009-04-22 13:00:00	NVDA	Stock	0.2885	0.291	0.2875	0.2888	88570760.0
2009-04-22 14:00:00	NVDA	Stock	0.2888	0.2952	0.2885	0.2932	94681760.0
2009-04-22 15:00:00	NVDA	Stock	0.2932	0.2952	0.283	0.2842	224657200.0
2009-04-22 16:00:00	NVDA	Stock	0.2842	0.29	0.2838	0.284	21796560.0
2009-04-22 17:00:00	NVDA	Stock	0.2862	0.2862	0.2815	0.2815	76000.0
2009-04-22 18:00:00	NVDA	Stock	0.2888	0.2888	0.2888	0.2888	8000.0
2009-04-22 19:00:00	NVDA	Stock	0.2888	0.2888	0.2888	0.2888	24000.0
2009-04-22 06:00:00	AMZN	Stock	3.9645	3.9645	3.9645	3.9645	2000.0
2009-04-22 07:00:00	AMZN	Stock	3.938	3.938	3.92	3.938	8000.0
2009-04-22 08:00:00	AMZN	Stock	3.926	3.926	3.9225	3.9225	47600.0
2009-04-22 09:00:00	AMZN	Stock	3.9225	4.0115	3.8905	4.0105	22148040.0
2009-04-22 10:00:00	AMZN	Stock	4.0105	4.0665	4.0055	4.035	31134960.0
2009-04-22 11:00:00	AMZN	Stock	4.0355	4.1075	4.011	4.103	23466880.0
2009-04-22 12:00:00	AMZN	Stock	4.103	4.109	4.0135	4.0375	18890680.0
2009-04-22 13:00:00	AMZN	Stock	4.0365	4.0805	4.025	4.0375	14356400.0
2009-04-22 14:00:00	AMZN	Stock	4.0375	4.0985	4.033	4.067	16880940.0
2009-04-22 15:00:00	AMZN	Stock	4.0666	4.0775	3.949	3.96	39364920.0
2009-04-22 16:00:00	AMZN	Stock	3.953	4.078	3.9455	4.065	4721440.0

> showing 50 of 40,242 rows — these rows as CSV

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