PREVIEW / stock_1hour / 2007-12-10

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-12-10.parquet
  size:    820 KB
  rows:    40,660
  symbols: 3,241

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-12-10 05:00:00	AAPL	Stock	6.9346	6.9407	6.9104	6.9104	60844.0
2007-12-10 06:00:00	AAPL	Stock	6.9471	6.9604	6.9471	6.9554	39200.0
2007-12-10 07:00:00	AAPL	Stock	6.9482	6.95	6.9189	6.95	578816.0
2007-12-10 08:00:00	AAPL	Stock	6.95	6.9539	6.8929	6.8971	7400652.0
2007-12-10 09:00:00	AAPL	Stock	6.9011	6.9636	6.8818	6.91	137815468.0
2007-12-10 10:00:00	AAPL	Stock	6.9111	6.9414	6.8893	6.9382	136433724.0
2007-12-10 11:00:00	AAPL	Stock	6.9386	6.9879	6.9179	6.9786	105144088.0
2007-12-10 12:00:00	AAPL	Stock	6.9789	6.9857	6.9407	6.95	67177712.0
2007-12-10 13:00:00	AAPL	Stock	6.9496	6.975	6.9293	6.9325	66163384.0
2007-12-10 14:00:00	AAPL	Stock	6.9321	6.955	6.9132	6.9289	81218312.0
2007-12-10 15:00:00	AAPL	Stock	6.9279	6.9629	6.9236	6.9346	100352336.0
2007-12-10 16:00:00	AAPL	Stock	6.9357	6.9721	6.9289	6.9446	18946564.0
2007-12-10 17:00:00	AAPL	Stock	6.9414	6.9718	6.9411	6.95	635880.0
2007-12-10 18:00:00	AAPL	Stock	6.9529	6.9529	6.9439	6.9464	199836.0
2007-12-10 19:00:00	AAPL	Stock	6.9482	6.9554	6.9468	6.95	433272.0
2007-12-10 08:00:00	MSFT	Stock	34.5	34.6	34.47	34.47	3221.0
2007-12-10 09:00:00	MSFT	Stock	34.46	34.83	34.45	34.579	5189946.0
2007-12-10 10:00:00	MSFT	Stock	34.57	34.95	34.57	34.9	6997986.0
2007-12-10 11:00:00	MSFT	Stock	34.9	34.94	34.79	34.89	3397455.0
2007-12-10 12:00:00	MSFT	Stock	34.89	34.92	34.85	34.87	2860756.0
2007-12-10 13:00:00	MSFT	Stock	34.87	34.93	34.83	34.85	4038384.0
2007-12-10 14:00:00	MSFT	Stock	34.85	34.95	34.83	34.835	4550421.0
2007-12-10 15:00:00	MSFT	Stock	34.84	34.9	34.76	34.77	7278103.0
2007-12-10 16:00:00	MSFT	Stock	34.77	34.88	34.73	34.84	1742513.0
2007-12-10 17:00:00	MSFT	Stock	34.84	34.909	34.81	34.86	20601.0
2007-12-10 18:00:00	MSFT	Stock	34.86	34.86	34.85	34.85	6787.0
2007-12-10 19:00:00	MSFT	Stock	34.87	34.87	34.86	34.86	750.0
2007-12-10 08:00:00	NVDA	Stock	0.85	0.8588	0.85	0.8523	133400.0
2007-12-10 09:00:00	NVDA	Stock	0.852	0.8662	0.8465	0.8608	58673200.0
2007-12-10 10:00:00	NVDA	Stock	0.8612	0.8625	0.8485	0.8595	56408120.0
2007-12-10 11:00:00	NVDA	Stock	0.8595	0.8612	0.851	0.851	37419440.0
2007-12-10 12:00:00	NVDA	Stock	0.8512	0.8568	0.8495	0.8532	27387520.0
2007-12-10 13:00:00	NVDA	Stock	0.8532	0.8588	0.8498	0.853	43597240.0
2007-12-10 14:00:00	NVDA	Stock	0.853	0.8542	0.8505	0.853	27814160.0
2007-12-10 15:00:00	NVDA	Stock	0.8532	0.8568	0.8523	0.8568	81855240.0
2007-12-10 16:00:00	NVDA	Stock	0.8565	0.875	0.8528	0.8725	3571680.0
2007-12-10 17:00:00	NVDA	Stock	0.8725	0.875	0.8662	0.8675	381480.0
2007-12-10 18:00:00	NVDA	Stock	0.8675	0.8675	0.866	0.8662	66360.0
2007-12-10 19:00:00	NVDA	Stock	0.8662	0.8668	0.866	0.8668	52000.0
2007-12-10 08:00:00	AMZN	Stock	4.7175	4.7175	4.717	4.7175	34760.0
2007-12-10 09:00:00	AMZN	Stock	4.7125	4.7175	4.6445	4.646	15086180.0
2007-12-10 10:00:00	AMZN	Stock	4.6465	4.672	4.631	4.6545	17934800.0
2007-12-10 11:00:00	AMZN	Stock	4.654	4.655	4.6155	4.6165	11300540.0
2007-12-10 12:00:00	AMZN	Stock	4.6165	4.6376	4.615	4.631	6485240.0
2007-12-10 13:00:00	AMZN	Stock	4.6315	4.654	4.6255	4.6425	10932300.0
2007-12-10 14:00:00	AMZN	Stock	4.6435	4.675	4.635	4.661	10598240.0
2007-12-10 15:00:00	AMZN	Stock	4.661	4.665	4.6465	4.653	16052320.0
2007-12-10 16:00:00	AMZN	Stock	4.651	4.668	4.6453	4.6453	15170520.0
2007-12-10 17:00:00	AMZN	Stock	4.6625	4.664	4.661	4.661	24300.0
2007-12-10 19:00:00	AMZN	Stock	4.664	4.665	4.664	4.665	12120.0

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

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