PREVIEW / stock_1hour / 2010-03-01

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-01.parquet
  size:    926 KB
  rows:    44,143
  symbols: 3,474

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
2010-03-01 04:00:00	AAPL	Stock	7.3586	7.3586	7.3557	7.3557	5600.0
2010-03-01 05:00:00	AAPL	Stock	7.3671	7.3679	7.3671	7.3679	30800.0
2010-03-01 07:00:00	AAPL	Stock	7.3407	7.3568	7.3321	7.3321	371980.0
2010-03-01 08:00:00	AAPL	Stock	7.3286	7.3429	7.3079	7.3421	3565884.0
2010-03-01 09:00:00	AAPL	Stock	7.3421	7.4046	7.3375	7.3957	90758556.0
2010-03-01 10:00:00	AAPL	Stock	7.3929	7.4607	7.3868	7.4507	143415776.0
2010-03-01 11:00:00	AAPL	Stock	7.4514	7.4679	7.4429	7.4489	64464232.0
2010-03-01 12:00:00	AAPL	Stock	7.4493	7.4667	7.4443	7.4468	39326840.0
2010-03-01 13:00:00	AAPL	Stock	7.4468	7.4757	7.4457	7.4671	43777860.0
2010-03-01 14:00:00	AAPL	Stock	7.4675	7.4721	7.4543	7.4593	40051200.0
2010-03-01 15:00:00	AAPL	Stock	7.4589	7.4821	7.4468	7.4646	105467796.0
2010-03-01 16:00:00	AAPL	Stock	7.4643	7.4668	7.3916	7.4579	11785228.0
2010-03-01 17:00:00	AAPL	Stock	7.4596	7.4643	7.4568	7.4593	371672.0
2010-03-01 18:00:00	AAPL	Stock	7.4607	7.4643	7.4607	7.4629	350560.0
2010-03-01 19:00:00	AAPL	Stock	7.46	7.4625	7.4561	7.4561	185192.0
2010-03-01 20:00:00	AAPL	Stock	7.4486	7.4486	7.4486	7.4486	137200.0
2010-03-01 04:00:00	MSFT	Stock	28.76	28.76	28.76	28.76	200.0
2010-03-01 07:00:00	MSFT	Stock	28.72	28.72	28.72	28.72	400.0
2010-03-01 08:00:00	MSFT	Stock	28.7	28.8	28.66	28.76	5900.0
2010-03-01 09:00:00	MSFT	Stock	28.78	28.82	28.57	28.6	4039611.0
2010-03-01 10:00:00	MSFT	Stock	28.59	28.91	28.53	28.88	6905710.0
2010-03-01 11:00:00	MSFT	Stock	28.88	28.97	28.8	28.84	5745087.0
2010-03-01 12:00:00	MSFT	Stock	28.85	28.96	28.83	28.911	4231903.0
2010-03-01 13:00:00	MSFT	Stock	28.91	28.92	28.81	28.83	3448441.0
2010-03-01 14:00:00	MSFT	Stock	28.83	28.95	28.82	28.92	3940318.0
2010-03-01 15:00:00	MSFT	Stock	28.91	29.05	28.84	29.01	12743719.0
2010-03-01 16:00:00	MSFT	Stock	29.02	29.07	28.855	29.05	2070958.0
2010-03-01 17:00:00	MSFT	Stock	28.896	29.05	28.896	29.0	9446.0
2010-03-01 18:00:00	MSFT	Stock	29.03	29.05	29.0	29.05	2703.0
2010-03-01 20:00:00	MSFT	Stock	28.88	28.88	28.88	28.88	29000.0
2010-03-01 08:00:00	NVDA	Stock	0.4058	0.409	0.4058	0.4085	247000.0
2010-03-01 09:00:00	NVDA	Stock	0.4085	0.4148	0.402	0.412	67302560.0
2010-03-01 10:00:00	NVDA	Stock	0.412	0.4178	0.4108	0.417	92579160.0
2010-03-01 11:00:00	NVDA	Stock	0.417	0.4213	0.4168	0.421	87824520.0
2010-03-01 12:00:00	NVDA	Stock	0.421	0.4222	0.4198	0.42	47698080.0
2010-03-01 13:00:00	NVDA	Stock	0.4198	0.4218	0.4198	0.4216	39132320.0
2010-03-01 14:00:00	NVDA	Stock	0.4218	0.4232	0.4205	0.421	69488960.0
2010-03-01 15:00:00	NVDA	Stock	0.421	0.4232	0.4202	0.4215	121961440.0
2010-03-01 16:00:00	NVDA	Stock	0.4215	0.4225	0.4185	0.4225	20547200.0
2010-03-01 17:00:00	NVDA	Stock	0.4232	0.4232	0.42	0.4202	112000.0
2010-03-01 18:00:00	NVDA	Stock	0.4213	0.4213	0.4213	0.4213	3720200.0
2010-03-01 19:00:00	NVDA	Stock	0.42	0.42	0.42	0.42	4000.0
2010-03-01 08:00:00	AMZN	Stock	5.9225	5.9225	5.92	5.92	25800.0
2010-03-01 09:00:00	AMZN	Stock	5.93	5.97	5.8825	5.884	16548580.0
2010-03-01 10:00:00	AMZN	Stock	5.885	5.986	5.8765	5.9815	26440480.0
2010-03-01 11:00:00	AMZN	Stock	5.9807	6.0585	5.975	6.05	45965300.0
2010-03-01 12:00:00	AMZN	Stock	6.05	6.1265	6.049	6.1226	37839740.0
2010-03-01 13:00:00	AMZN	Stock	6.1235	6.158	6.115	6.1535	29355880.0
2010-03-01 14:00:00	AMZN	Stock	6.1545	6.182	6.1005	6.179	33806300.0
2010-03-01 15:00:00	AMZN	Stock	6.1795	6.233	6.175	6.2225	68697180.0

> showing 50 of 44,143 rows — these rows as CSV

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