PREVIEW / stock_1hour / 2010-04-13

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-04-13.parquet
  size:    918 KB
  rows:    43,606
  symbols: 3,477

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-04-13 05:00:00	AAPL	Stock	8.6357	8.6357	8.6357	8.6357	3136.0
2010-04-13 06:00:00	AAPL	Stock	8.65	8.65	8.65	8.65	5264.0
2010-04-13 07:00:00	AAPL	Stock	8.6321	8.6464	8.6071	8.6464	79800.0
2010-04-13 08:00:00	AAPL	Stock	8.6504	8.6509	8.6318	8.6432	1108156.0
2010-04-13 09:00:00	AAPL	Stock	8.6414	8.6714	8.6286	8.6586	52251528.0
2010-04-13 10:00:00	AAPL	Stock	8.6586	8.6671	8.6111	8.6279	73668084.0
2010-04-13 11:00:00	AAPL	Stock	8.6282	8.6464	8.6129	8.6371	32234272.0
2010-04-13 12:00:00	AAPL	Stock	8.6379	8.6514	8.6221	8.6496	23182544.0
2010-04-13 13:00:00	AAPL	Stock	8.6496	8.6696	8.6468	8.6679	33932108.0
2010-04-13 14:00:00	AAPL	Stock	8.6672	8.6696	8.6529	8.6536	26195568.0
2010-04-13 15:00:00	AAPL	Stock	8.6536	8.6661	8.6464	8.655	50432452.0
2010-04-13 16:00:00	AAPL	Stock	8.655	8.6875	8.63	8.6732	8539608.0
2010-04-13 17:00:00	AAPL	Stock	8.6732	8.6771	8.6481	8.6771	544208.0
2010-04-13 18:00:00	AAPL	Stock	8.6775	8.6904	8.675	8.6825	918092.0
2010-04-13 19:00:00	AAPL	Stock	8.6857	8.6893	8.6825	8.6875	267484.0
2010-04-13 08:00:00	MSFT	Stock	30.34	30.34	30.21	30.26	4681.0
2010-04-13 09:00:00	MSFT	Stock	30.26	30.34	30.13	30.27	4986830.0
2010-04-13 10:00:00	MSFT	Stock	30.26	30.36	30.17	30.32	6750500.0
2010-04-13 11:00:00	MSFT	Stock	30.32	30.35	30.27	30.295	5630811.0
2010-04-13 12:00:00	MSFT	Stock	30.292	30.36	30.27	30.31	2977830.0
2010-04-13 13:00:00	MSFT	Stock	30.315	30.45	30.3	30.42	3731806.0
2010-04-13 14:00:00	MSFT	Stock	30.422	30.49	30.4	30.485	4398932.0
2010-04-13 15:00:00	MSFT	Stock	30.48	30.5	30.42	30.45	8758982.0
2010-04-13 16:00:00	MSFT	Stock	30.45	30.95	30.28	30.88	3547577.0
2010-04-13 17:00:00	MSFT	Stock	30.88	30.88	30.79	30.82	26048.0
2010-04-13 18:00:00	MSFT	Stock	30.82	30.87	30.45	30.76	17127.0
2010-04-13 19:00:00	MSFT	Stock	30.76	30.78	30.76	30.78	1340.0
2010-04-13 08:00:00	NVDA	Stock	0.4262	0.4325	0.4262	0.4325	94000.0
2010-04-13 09:00:00	NVDA	Stock	0.4345	0.44	0.4325	0.4398	75701800.0
2010-04-13 10:00:00	NVDA	Stock	0.4395	0.4398	0.4352	0.4392	111625400.0
2010-04-13 11:00:00	NVDA	Stock	0.4392	0.4408	0.4385	0.4398	76767160.0
2010-04-13 12:00:00	NVDA	Stock	0.4398	0.4402	0.4375	0.4392	52140720.0
2010-04-13 13:00:00	NVDA	Stock	0.4392	0.4425	0.4391	0.4422	91513120.0
2010-04-13 14:00:00	NVDA	Stock	0.442	0.443	0.44	0.4405	68844720.0
2010-04-13 15:00:00	NVDA	Stock	0.4405	0.443	0.4405	0.4412	132013480.0
2010-04-13 16:00:00	NVDA	Stock	0.4415	0.452	0.4399	0.4508	30731760.0
2010-04-13 17:00:00	NVDA	Stock	0.4518	0.455	0.4399	0.455	2956440.0
2010-04-13 18:00:00	NVDA	Stock	0.455	0.4578	0.4542	0.4562	1196360.0
2010-04-13 19:00:00	NVDA	Stock	0.4562	0.4562	0.4555	0.4555	269800.0
2010-04-13 20:00:00	NVDA	Stock	0.4348	0.4348	0.4348	0.4348	4260000.0
2010-04-13 08:00:00	AMZN	Stock	7.0775	7.0775	7.0285	7.0695	47900.0
2010-04-13 09:00:00	AMZN	Stock	7.0605	7.099	7.005	7.009	17958040.0
2010-04-13 10:00:00	AMZN	Stock	7.0088	7.0275	6.956	7.017	23407860.0
2010-04-13 11:00:00	AMZN	Stock	7.017	7.0195	6.99	7.014	8618360.0
2010-04-13 12:00:00	AMZN	Stock	7.0155	7.0385	7.0015	7.0335	8995820.0
2010-04-13 13:00:00	AMZN	Stock	7.034	7.07	7.0335	7.05	8678800.0
2010-04-13 14:00:00	AMZN	Stock	7.0505	7.056	7.0135	7.0146	9455780.0
2010-04-13 15:00:00	AMZN	Stock	7.0155	7.0435	7.0085	7.0085	15174980.0
2010-04-13 16:00:00	AMZN	Stock	7.0085	7.0548	7.008	7.008	1767640.0
2010-04-13 17:00:00	AMZN	Stock	7.035	7.035	7.035	7.035	6000.0

> showing 50 of 43,606 rows — these rows as CSV

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