PREVIEW / stock_1hour / 2010-05-14

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-05-14.parquet
  size:    910 KB
  rows:    43,552
  symbols: 3,488

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-05-14 04:00:00	AAPL	Stock	9.1857	9.1857	9.1786	9.1786	8400.0
2010-05-14 05:00:00	AAPL	Stock	9.1532	9.1532	9.0957	9.0961	57764.0
2010-05-14 06:00:00	AAPL	Stock	9.0964	9.1246	9.0893	9.1161	83860.0
2010-05-14 07:00:00	AAPL	Stock	9.125	9.1786	9.1161	9.1721	1168524.0
2010-05-14 08:00:00	AAPL	Stock	9.1718	9.1786	9.1268	9.1491	4199944.0
2010-05-14 09:00:00	AAPL	Stock	9.1479	9.16	9.0196	9.0389	120760304.0
2010-05-14 10:00:00	AAPL	Stock	9.04	9.0786	9.0093	9.05	109091976.0
2010-05-14 11:00:00	AAPL	Stock	9.0507	9.0521	8.9554	8.9766	118646304.0
2010-05-14 12:00:00	AAPL	Stock	8.9771	9.0243	8.9107	9.0214	105339612.0
2010-05-14 13:00:00	AAPL	Stock	9.0229	9.041	8.9521	8.9602	75542936.0
2010-05-14 14:00:00	AAPL	Stock	8.9607	9.0307	8.9464	8.9925	70495040.0
2010-05-14 15:00:00	AAPL	Stock	8.9907	9.1004	8.95	9.0714	121625224.0
2010-05-14 16:00:00	AAPL	Stock	9.0664	9.2271	8.9846	9.0896	20698272.0
2010-05-14 17:00:00	AAPL	Stock	9.0982	9.1	9.0804	9.0864	744212.0
2010-05-14 18:00:00	AAPL	Stock	9.0875	9.0961	9.065	9.075	740208.0
2010-05-14 19:00:00	AAPL	Stock	9.075	9.0893	9.075	9.0786	341096.0
2010-05-14 20:00:00	AAPL	Stock	8.9982	8.9982	8.9982	8.9982	602000.0
2010-05-14 08:00:00	MSFT	Stock	29.18	29.18	29.02	29.11	9841.0
2010-05-14 09:00:00	MSFT	Stock	29.11	29.21	28.81	28.86	6568315.0
2010-05-14 10:00:00	MSFT	Stock	28.85	29.08	28.77	28.961	8112042.0
2010-05-14 11:00:00	MSFT	Stock	28.96	28.97	28.74	28.75	8291676.0
2010-05-14 12:00:00	MSFT	Stock	28.76	28.83	28.64	28.77	5915121.0
2010-05-14 13:00:00	MSFT	Stock	28.77	28.83	28.67	28.74	4880321.0
2010-05-14 14:00:00	MSFT	Stock	28.73	28.88	28.67	28.75	5173300.0
2010-05-14 15:00:00	MSFT	Stock	28.748	28.99	28.64	28.94	12104826.0
2010-05-14 16:00:00	MSFT	Stock	28.93	29.24	28.724	28.86	7172773.0
2010-05-14 17:00:00	MSFT	Stock	28.95	28.95	28.86	28.86	300.0
2010-05-14 18:00:00	MSFT	Stock	28.93	28.93	28.86	28.86	12557.0
2010-05-14 19:00:00	MSFT	Stock	28.86	28.86	28.83	28.86	1745.0
2010-05-14 20:00:00	MSFT	Stock	28.85	28.85	28.81	28.81	1600.0
2010-05-14 07:00:00	NVDA	Stock	0.3438	0.35	0.3438	0.35	404000.0
2010-05-14 08:00:00	NVDA	Stock	0.35	0.3513	0.3415	0.3425	19987000.0
2010-05-14 09:00:00	NVDA	Stock	0.3425	0.3448	0.3313	0.3313	411337040.0
2010-05-14 10:00:00	NVDA	Stock	0.3313	0.3335	0.3235	0.3263	446773240.0
2010-05-14 11:00:00	NVDA	Stock	0.3265	0.3265	0.3155	0.3185	345396360.0
2010-05-14 12:00:00	NVDA	Stock	0.3183	0.3208	0.3155	0.3195	234150560.0
2010-05-14 13:00:00	NVDA	Stock	0.3198	0.3203	0.3178	0.319	173826120.0
2010-05-14 14:00:00	NVDA	Stock	0.319	0.32	0.315	0.32	277943240.0
2010-05-14 15:00:00	NVDA	Stock	0.3198	0.3255	0.3198	0.3245	527164280.0
2010-05-14 16:00:00	NVDA	Stock	0.3245	0.3662	0.3214	0.325	10690520.0
2010-05-14 17:00:00	NVDA	Stock	0.3258	0.3263	0.3248	0.3258	186240.0
2010-05-14 18:00:00	NVDA	Stock	0.3258	0.3258	0.3248	0.3248	394800.0
2010-05-14 19:00:00	NVDA	Stock	0.325	0.328	0.325	0.3263	560000.0
2010-05-14 07:00:00	AMZN	Stock	6.525	6.525	6.525	6.525	4000.0
2010-05-14 08:00:00	AMZN	Stock	6.525	6.55	6.475	6.515	315800.0
2010-05-14 09:00:00	AMZN	Stock	6.508	6.55	6.428	6.4515	17434280.0
2010-05-14 10:00:00	AMZN	Stock	6.4505	6.522	6.4275	6.512	12173580.0
2010-05-14 11:00:00	AMZN	Stock	6.509	6.511	6.355	6.3645	21313340.0
2010-05-14 12:00:00	AMZN	Stock	6.3643	6.4	6.338	6.398	13046580.0
2010-05-14 13:00:00	AMZN	Stock	6.3975	6.41	6.3575	6.367	8588440.0

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

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