PREVIEW / stock_1hour / 2009-09-04

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-09-04.parquet
  size:    846 KB
  rows:    41,109
  symbols: 3,331

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-09-04 04:00:00	AAPL	Stock	6.0	6.0	6.0	6.0	2800.0
2009-09-04 06:00:00	AAPL	Stock	5.95	5.95	5.95	5.95	2800.0
2009-09-04 07:00:00	AAPL	Stock	5.95	5.9643	5.9464	5.9643	88200.0
2009-09-04 08:00:00	AAPL	Stock	5.9754	5.9821	5.9225	5.9786	2641268.0
2009-09-04 09:00:00	AAPL	Stock	5.9786	6.0214	5.9675	5.9954	47571944.0
2009-09-04 10:00:00	AAPL	Stock	5.9946	6.045	5.9939	6.0407	63034300.0
2009-09-04 11:00:00	AAPL	Stock	6.0407	6.0704	6.025	6.0704	48568856.0
2009-09-04 12:00:00	AAPL	Stock	6.0707	6.0964	6.0664	6.0839	72108344.0
2009-09-04 13:00:00	AAPL	Stock	6.0843	6.09	6.0636	6.0704	40855416.0
2009-09-04 14:00:00	AAPL	Stock	6.0704	6.0775	6.0564	6.0725	31740128.0
2009-09-04 15:00:00	AAPL	Stock	6.0721	6.0854	6.0618	6.0804	53256532.0
2009-09-04 16:00:00	AAPL	Stock	6.0843	6.0871	6.0143	6.0832	9133152.0
2009-09-04 17:00:00	AAPL	Stock	6.0832	6.0882	6.0821	6.085	334404.0
2009-09-04 18:00:00	AAPL	Stock	6.0836	6.0893	6.0825	6.0893	1034124.0
2009-09-04 19:00:00	AAPL	Stock	6.0893	6.0929	6.0893	6.0929	184016.0
2009-09-04 04:00:00	MSFT	Stock	24.07	24.07	24.07	24.07	10500.0
2009-09-04 05:00:00	MSFT	Stock	24.07	24.07	24.07	24.07	500.0
2009-09-04 08:00:00	MSFT	Stock	24.11	24.15	24.06	24.11	51200.0
2009-09-04 09:00:00	MSFT	Stock	24.1	24.32	24.06	24.18	6400832.0
2009-09-04 10:00:00	MSFT	Stock	24.17	24.4	24.17	24.32	5542661.0
2009-09-04 11:00:00	MSFT	Stock	24.32	24.34	24.21	24.34	3778754.0
2009-09-04 12:00:00	MSFT	Stock	24.34	24.59	24.33	24.56	4924671.0
2009-09-04 13:00:00	MSFT	Stock	24.56	24.72	24.549	24.68	7999372.0
2009-09-04 14:00:00	MSFT	Stock	24.68	24.8	24.68	24.75	5369250.0
2009-09-04 15:00:00	MSFT	Stock	24.75	24.77	24.57	24.63	8270813.0
2009-09-04 16:00:00	MSFT	Stock	24.63	24.64	24.11	24.6	1667998.0
2009-09-04 17:00:00	MSFT	Stock	24.6	24.6	24.58	24.58	6292.0
2009-09-04 18:00:00	MSFT	Stock	24.62	24.62	24.58	24.59	11662.0
2009-09-04 19:00:00	MSFT	Stock	24.61	24.61	24.61	24.61	400.0
2009-09-04 08:00:00	NVDA	Stock	0.365	0.365	0.365	0.365	4000.0
2009-09-04 09:00:00	NVDA	Stock	0.3655	0.3698	0.3628	0.3642	92902960.0
2009-09-04 10:00:00	NVDA	Stock	0.3642	0.3713	0.3636	0.371	55792000.0
2009-09-04 11:00:00	NVDA	Stock	0.3713	0.3715	0.368	0.3713	42621000.0
2009-09-04 12:00:00	NVDA	Stock	0.3713	0.3785	0.3713	0.378	119662880.0
2009-09-04 13:00:00	NVDA	Stock	0.3778	0.3803	0.3768	0.3774	75546120.0
2009-09-04 14:00:00	NVDA	Stock	0.3773	0.3783	0.3756	0.377	43734480.0
2009-09-04 15:00:00	NVDA	Stock	0.3773	0.3783	0.377	0.3778	68761440.0
2009-09-04 16:00:00	NVDA	Stock	0.3778	0.3798	0.3734	0.3778	10075360.0
2009-09-04 17:00:00	NVDA	Stock	0.3642	0.3793	0.3642	0.3793	43280.0
2009-09-04 19:00:00	NVDA	Stock	0.3793	0.3793	0.379	0.379	28000.0
2009-09-04 07:00:00	AMZN	Stock	3.9505	3.9505	3.9285	3.9285	9340.0
2009-09-04 08:00:00	AMZN	Stock	3.9285	3.9495	3.9285	3.94	76720.0
2009-09-04 09:00:00	AMZN	Stock	3.9325	3.989	3.884	3.884	17818540.0
2009-09-04 10:00:00	AMZN	Stock	3.8835	3.922	3.8815	3.903	15481760.0
2009-09-04 11:00:00	AMZN	Stock	3.902	3.9035	3.8925	3.9035	9109140.0
2009-09-04 12:00:00	AMZN	Stock	3.9035	3.947	3.9025	3.945	10699640.0
2009-09-04 13:00:00	AMZN	Stock	3.9448	3.9565	3.9255	3.9335	8427740.0
2009-09-04 14:00:00	AMZN	Stock	3.934	3.937	3.922	3.934	9639460.0
2009-09-04 15:00:00	AMZN	Stock	3.9334	3.9445	3.9215	3.944	19619560.0
2009-09-04 16:00:00	AMZN	Stock	3.941	3.9443	3.9242	3.9435	498340.0

> showing 50 of 41,109 rows — these rows as CSV

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