PREVIEW / stock_1hour / 2007-03-22

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-03-22.parquet
  size:    683 KB
  rows:    32,650
  symbols: 2,552

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-03-22 06:00:00	AAPL	Stock	3.3489	3.3489	3.3489	3.3489	14000.0
2007-03-22 07:00:00	AAPL	Stock	3.3511	3.3514	3.3511	3.3514	16800.0
2007-03-22 08:00:00	AAPL	Stock	3.3493	3.3493	3.3368	3.345	1062460.0
2007-03-22 09:00:00	AAPL	Stock	3.3446	3.355	3.3214	3.3371	76386520.0
2007-03-22 10:00:00	AAPL	Stock	3.3364	3.3529	3.3329	3.3407	119839552.0
2007-03-22 11:00:00	AAPL	Stock	3.3407	3.3604	3.3404	3.3539	69205752.0
2007-03-22 12:00:00	AAPL	Stock	3.3543	3.37	3.3479	3.3611	64957032.0
2007-03-22 13:00:00	AAPL	Stock	3.3611	3.3614	3.3379	3.3446	71372532.0
2007-03-22 14:00:00	AAPL	Stock	3.345	3.3582	3.3407	3.3482	62998572.0
2007-03-22 15:00:00	AAPL	Stock	3.3482	3.3571	3.3407	3.3521	68767524.0
2007-03-22 16:00:00	AAPL	Stock	3.3557	3.3557	3.3489	3.35	5687136.0
2007-03-22 17:00:00	AAPL	Stock	3.35	3.35	3.3475	3.3475	203336.0
2007-03-22 18:00:00	AAPL	Stock	3.3475	3.3557	3.3436	3.3464	3568740.0
2007-03-22 19:00:00	AAPL	Stock	3.3496	3.35	3.345	3.345	86576.0
2007-03-22 07:00:00	MSFT	Stock	28.46	28.94	28.46	28.51	11995.0
2007-03-22 08:00:00	MSFT	Stock	28.49	28.52	28.44	28.49	28900.0
2007-03-22 09:00:00	MSFT	Stock	28.49	28.55	28.11	28.14	6004836.0
2007-03-22 10:00:00	MSFT	Stock	28.14	28.33	28.01	28.06	9460576.0
2007-03-22 11:00:00	MSFT	Stock	28.059	28.28	28.04	28.24	5732524.0
2007-03-22 12:00:00	MSFT	Stock	28.24	28.36	28.13	28.25	4225478.0
2007-03-22 13:00:00	MSFT	Stock	28.25	28.3	28.16	28.28	3832240.0
2007-03-22 14:00:00	MSFT	Stock	28.29	28.38	28.24	28.31	5071107.0
2007-03-22 15:00:00	MSFT	Stock	28.32	28.33	28.17	28.27	10901596.0
2007-03-22 16:00:00	MSFT	Stock	28.26	28.32	28.22	28.27	1026654.0
2007-03-22 17:00:00	MSFT	Stock	28.27	28.27	28.27	28.27	175600.0
2007-03-22 18:00:00	MSFT	Stock	28.26	28.27	28.25	28.25	1566435.0
2007-03-22 19:00:00	MSFT	Stock	28.25	28.28	28.25	28.28	800.0
2007-03-22 07:00:00	NVDA	Stock	0.5	0.5	0.5	0.5	6000.0
2007-03-22 08:00:00	NVDA	Stock	0.4995	0.5075	0.4995	0.5017	450000.0
2007-03-22 09:00:00	NVDA	Stock	0.5033	0.5068	0.4977	0.499	105375420.0
2007-03-22 10:00:00	NVDA	Stock	0.499	0.504	0.4982	0.5027	128009700.0
2007-03-22 11:00:00	NVDA	Stock	0.5027	0.5095	0.5015	0.5092	111481620.0
2007-03-22 12:00:00	NVDA	Stock	0.5092	0.512	0.507	0.5115	94986240.0
2007-03-22 13:00:00	NVDA	Stock	0.5117	0.5135	0.508	0.51	126231780.0
2007-03-22 14:00:00	NVDA	Stock	0.5102	0.5122	0.509	0.5118	83902200.0
2007-03-22 15:00:00	NVDA	Stock	0.5118	0.5118	0.5078	0.5105	120329160.0
2007-03-22 16:00:00	NVDA	Stock	0.5108	0.511	0.5087	0.5087	18354420.0
2007-03-22 17:00:00	NVDA	Stock	0.5108	0.5108	0.5087	0.5087	75000.0
2007-03-22 18:00:00	NVDA	Stock	0.5107	0.5107	0.5095	0.5095	4725540.0
2007-03-22 19:00:00	NVDA	Stock	0.51	0.51	0.51	0.51	6000.0
2007-03-22 08:00:00	AMZN	Stock	1.9775	1.978	1.9775	1.9775	446000.0
2007-03-22 09:00:00	AMZN	Stock	1.975	1.986	1.96	1.9655	15316300.0
2007-03-22 10:00:00	AMZN	Stock	1.966	1.982	1.9565	1.959	30754560.0
2007-03-22 11:00:00	AMZN	Stock	1.959	1.9815	1.9455	1.959	21277020.0
2007-03-22 12:00:00	AMZN	Stock	1.9585	1.9665	1.956	1.96	7101840.0
2007-03-22 13:00:00	AMZN	Stock	1.9596	1.9645	1.956	1.964	4358920.0
2007-03-22 14:00:00	AMZN	Stock	1.964	1.975	1.9634	1.97	8464700.0
2007-03-22 15:00:00	AMZN	Stock	1.97	1.976	1.9635	1.9745	14434580.0
2007-03-22 16:00:00	AMZN	Stock	1.975	1.976	1.969	1.975	973320.0
2007-03-22 17:00:00	AMZN	Stock	1.9685	1.973	1.9685	1.973	12000.0

> showing 50 of 32,650 rows — these rows as CSV

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