PREVIEW / stock_1hour / 2007-01-12

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-01-12.parquet
  size:    644 KB
  rows:    30,543
  symbols: 2,495

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-01-12 04:00:00	AAPL	Stock	3.4171	3.4171	3.4161	3.4171	61600.0
2007-01-12 05:00:00	AAPL	Stock	3.4214	3.4214	3.4071	3.4111	341628.0
2007-01-12 06:00:00	AAPL	Stock	3.4111	3.4193	3.4018	3.4025	254800.0
2007-01-12 07:00:00	AAPL	Stock	3.4021	3.4036	3.38	3.3989	2854684.0
2007-01-12 08:00:00	AAPL	Stock	3.3946	3.3946	3.3679	3.3857	14145320.0
2007-01-12 09:00:00	AAPL	Stock	3.3861	3.3914	3.3468	3.3693	298248132.0
2007-01-12 10:00:00	AAPL	Stock	3.37	3.3714	3.3296	3.3693	344298612.0
2007-01-12 11:00:00	AAPL	Stock	3.3689	3.3929	3.3621	3.3861	209262816.0
2007-01-12 12:00:00	AAPL	Stock	3.3857	3.3921	3.3671	3.3711	114602068.0
2007-01-12 13:00:00	AAPL	Stock	3.3707	3.3761	3.3589	3.3668	91535724.0
2007-01-12 14:00:00	AAPL	Stock	3.3668	3.3832	3.3664	3.3754	72180528.0
2007-01-12 15:00:00	AAPL	Stock	3.3754	3.395	3.3746	3.3818	149059456.0
2007-01-12 16:00:00	AAPL	Stock	3.3811	3.3821	3.3786	3.3793	2057244.0
2007-01-12 17:00:00	AAPL	Stock	3.3793	3.3804	3.3779	3.38	352156.0
2007-01-12 18:00:00	AAPL	Stock	3.3782	3.3821	3.3782	3.3821	370972.0
2007-01-12 19:00:00	AAPL	Stock	3.3818	3.3821	3.3793	3.3804	172732.0
2007-01-12 04:00:00	MSFT	Stock	30.82	30.82	30.82	30.82	200.0
2007-01-12 07:00:00	MSFT	Stock	30.65	30.65	30.4	30.55	88264.0
2007-01-12 08:00:00	MSFT	Stock	30.58	30.6	30.52	30.6	111479.0
2007-01-12 09:00:00	MSFT	Stock	30.6	30.99	30.57	30.98	14109547.0
2007-01-12 10:00:00	MSFT	Stock	30.97	30.99	30.81	30.92	17030662.0
2007-01-12 11:00:00	MSFT	Stock	30.92	31.1	30.85	31.02	18949880.0
2007-01-12 12:00:00	MSFT	Stock	31.02	31.21	31.0	31.19	9641344.0
2007-01-12 13:00:00	MSFT	Stock	31.19	31.25	31.17	31.17	8949951.0
2007-01-12 14:00:00	MSFT	Stock	31.18	31.28	31.17	31.19	9638921.0
2007-01-12 15:00:00	MSFT	Stock	31.2	31.39	31.18	31.2	19831804.0
2007-01-12 16:00:00	MSFT	Stock	31.21	31.24	31.16	31.21	377345.0
2007-01-12 17:00:00	MSFT	Stock	31.21	31.29	31.21	31.21	14928.0
2007-01-12 18:00:00	MSFT	Stock	31.21	31.23	31.21	31.21	3494.0
2007-01-12 19:00:00	MSFT	Stock	31.2	31.21	31.2	31.2	10035.0
2007-01-12 07:00:00	NVDA	Stock	0.5643	0.5643	0.5643	0.5643	6000.0
2007-01-12 08:00:00	NVDA	Stock	0.5775	0.5775	0.5708	0.5715	585000.0
2007-01-12 09:00:00	NVDA	Stock	0.5715	0.5813	0.569	0.5808	65617800.0
2007-01-12 10:00:00	NVDA	Stock	0.5808	0.5808	0.568	0.5737	138529320.0
2007-01-12 11:00:00	NVDA	Stock	0.5735	0.5795	0.573	0.5792	84755820.0
2007-01-12 12:00:00	NVDA	Stock	0.5792	0.585	0.5783	0.5843	94160820.0
2007-01-12 13:00:00	NVDA	Stock	0.5843	0.585	0.5828	0.5837	84651960.0
2007-01-12 14:00:00	NVDA	Stock	0.5838	0.5878	0.5828	0.5865	76517340.0
2007-01-12 15:00:00	NVDA	Stock	0.5867	0.5895	0.5853	0.587	124456380.0
2007-01-12 16:00:00	NVDA	Stock	0.5877	0.5878	0.5858	0.5868	639420.0
2007-01-12 17:00:00	NVDA	Stock	0.5867	0.5867	0.5867	0.5867	30000.0
2007-01-12 18:00:00	NVDA	Stock	0.5872	0.5872	0.585	0.585	144000.0
2007-01-12 19:00:00	NVDA	Stock	0.5872	0.5872	0.585	0.585	89400.0
2007-01-12 09:00:00	AMZN	Stock	1.869	1.897	1.8635	1.894	13578180.0
2007-01-12 10:00:00	AMZN	Stock	1.894	1.8945	1.8825	1.893	14014220.0
2007-01-12 11:00:00	AMZN	Stock	1.893	1.897	1.889	1.894	10361540.0
2007-01-12 12:00:00	AMZN	Stock	1.894	1.8975	1.89	1.8965	6513660.0
2007-01-12 13:00:00	AMZN	Stock	1.8965	1.899	1.894	1.8975	6645360.0
2007-01-12 14:00:00	AMZN	Stock	1.8975	1.8995	1.8935	1.8985	8667920.0
2007-01-12 15:00:00	AMZN	Stock	1.8985	1.9105	1.8985	1.9105	25385740.0

> showing 50 of 30,543 rows — these rows as CSV

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