PREVIEW / stock_1hour / 2007-08-31

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-31.parquet
  size:    757 KB
  rows:    37,719
  symbols: 3,117

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-08-31 09:00:00	AAPL	Stock	4.9821	4.9875	4.9432	4.9579	157027276.0
2007-08-31 10:00:00	AAPL	Stock	4.9582	4.9696	4.9161	4.93	195714540.0
2007-08-31 11:00:00	AAPL	Stock	4.9289	4.9461	4.9075	4.9407	126778848.0
2007-08-31 12:00:00	AAPL	Stock	4.9407	4.9429	4.9161	4.9304	75751368.0
2007-08-31 13:00:00	AAPL	Stock	4.9304	4.9343	4.9182	4.9275	49170940.0
2007-08-31 14:00:00	AAPL	Stock	4.9275	4.9343	4.9204	4.9275	44313836.0
2007-08-31 15:00:00	AAPL	Stock	4.9275	4.9554	4.9271	4.9443	126765520.0
2007-08-31 16:00:00	AAPL	Stock	4.945	4.9457	4.9404	4.9457	19468008.0
2007-08-31 09:00:00	MSFT	Stock	28.7	28.73	28.36	28.53	4301876.0
2007-08-31 10:00:00	MSFT	Stock	28.53	28.63	28.38	28.52	5170274.0
2007-08-31 11:00:00	MSFT	Stock	28.53	28.7	28.47	28.66	3269730.0
2007-08-31 12:00:00	MSFT	Stock	28.66	28.88	28.66	28.857	4338540.0
2007-08-31 13:00:00	MSFT	Stock	28.858	28.89	28.8	28.82	2914274.0
2007-08-31 14:00:00	MSFT	Stock	28.82	28.85	28.73	28.752	2774024.0
2007-08-31 15:00:00	MSFT	Stock	28.75	28.92	28.67	28.69	7399817.0
2007-08-31 16:00:00	MSFT	Stock	28.69	28.73	28.69	28.73	4742008.0
2007-08-31 07:00:00	NVDA	Stock	0.817	0.8255	0.817	0.8255	30000.0
2007-08-31 08:00:00	NVDA	Stock	0.819	0.8292	0.819	0.8253	2016000.0
2007-08-31 09:00:00	NVDA	Stock	0.8253	0.8333	0.8238	0.8327	70870740.0
2007-08-31 10:00:00	NVDA	Stock	0.8328	0.8428	0.8293	0.8415	150589080.0
2007-08-31 11:00:00	NVDA	Stock	0.8413	0.8487	0.8393	0.8463	101851260.0
2007-08-31 12:00:00	NVDA	Stock	0.8465	0.8558	0.8463	0.8498	108433140.0
2007-08-31 13:00:00	NVDA	Stock	0.8498	0.851	0.8438	0.8485	59231280.0
2007-08-31 14:00:00	NVDA	Stock	0.8485	0.8538	0.8475	0.8505	57756780.0
2007-08-31 15:00:00	NVDA	Stock	0.8505	0.8557	0.8502	0.8522	114595680.0
2007-08-31 16:00:00	NVDA	Stock	0.8527	0.8558	0.8525	0.8542	26851140.0
2007-08-31 18:00:00	NVDA	Stock	0.852	0.8545	0.852	0.8545	58200.0
2007-08-31 19:00:00	NVDA	Stock	0.8547	0.8558	0.8542	0.8542	189000.0
2007-08-31 08:00:00	AMZN	Stock	4.0015	4.025	3.985	3.995	518260.0
2007-08-31 09:00:00	AMZN	Stock	3.999	4.02	3.9905	4.0	15397980.0
2007-08-31 10:00:00	AMZN	Stock	4.0	4.0245	3.985	4.022	19426560.0
2007-08-31 11:00:00	AMZN	Stock	4.022	4.0225	3.995	3.9965	16796560.0
2007-08-31 12:00:00	AMZN	Stock	3.9965	4.0265	3.996	4.0145	12645800.0
2007-08-31 13:00:00	AMZN	Stock	4.0145	4.022	4.003	4.015	11126560.0
2007-08-31 14:00:00	AMZN	Stock	4.015	4.0165	4.005	4.0065	11425500.0
2007-08-31 15:00:00	AMZN	Stock	4.0065	4.0155	3.985	3.9935	24230520.0
2007-08-31 16:00:00	AMZN	Stock	3.9955	3.9955	3.9875	3.9955	6090760.0
2007-08-31 17:00:00	AMZN	Stock	3.9955	3.9975	3.995	3.9975	10700.0
2007-08-31 18:00:00	AMZN	Stock	3.9975	4.0065	3.9975	4.0065	29000.0
2007-08-31 19:00:00	AMZN	Stock	4.0065	4.01	4.0065	4.01	9000.0
2007-08-31 09:00:00	TLT	Stock	88.59	88.73	88.54	88.63	251700.0
2007-08-31 10:00:00	TLT	Stock	88.62	88.79	88.6	88.74	271700.0
2007-08-31 11:00:00	TLT	Stock	88.74	89.09	88.71	89.06	444300.0
2007-08-31 12:00:00	TLT	Stock	89.04	89.11	88.81	88.89	289000.0
2007-08-31 13:00:00	TLT	Stock	88.93	89.04	88.9	89.01	250000.0
2007-08-31 14:00:00	TLT	Stock	89.01	89.2	89.0	89.09	298500.0
2007-08-31 15:00:00	TLT	Stock	89.09	89.2	88.85	88.9	315000.0
2007-08-31 16:00:00	TLT	Stock	88.87	88.9	88.87	88.88	1900.0
2007-08-31 09:00:00	CL	Stock	33.14	33.22	32.915	33.2055	262800.0
2007-08-31 10:00:00	CL	Stock	33.22	33.32	33.095	33.105	427800.0

> showing 50 of 37,719 rows — these rows as CSV

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