PREVIEW / stock_1hour / 2010-10-25

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-10-25.parquet
  size:    923 KB
  rows:    44,139
  symbols: 3,497

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-10-25 04:00:00	AAPL	Stock	10.9286	11.0454	10.9286	11.0411	53760.0
2010-10-25 05:00:00	AAPL	Stock	11.0411	11.0436	11.0357	11.0436	39200.0
2010-10-25 06:00:00	AAPL	Stock	11.0343	11.0343	11.0286	11.03	19600.0
2010-10-25 07:00:00	AAPL	Stock	11.0446	11.0654	11.0196	11.0357	596148.0
2010-10-25 08:00:00	AAPL	Stock	11.0393	11.0454	10.9982	11.0293	3225320.0
2010-10-25 09:00:00	AAPL	Stock	11.03	11.1286	11.0157	11.0982	75213404.0
2010-10-25 10:00:00	AAPL	Stock	11.0982	11.12	11.0571	11.0632	89145784.0
2010-10-25 11:00:00	AAPL	Stock	11.0643	11.0861	11.0368	11.0746	37824332.0
2010-10-25 12:00:00	AAPL	Stock	11.0732	11.0818	11.0555	11.065	19799136.0
2010-10-25 13:00:00	AAPL	Stock	11.0644	11.0967	11.0618	11.0875	23980096.0
2010-10-25 14:00:00	AAPL	Stock	11.0876	11.1	11.0679	11.0796	31533180.0
2010-10-25 15:00:00	AAPL	Stock	11.0789	11.0875	11.0257	11.0296	77131516.0
2010-10-25 16:00:00	AAPL	Stock	11.03	11.0774	11.0204	11.0257	19751032.0
2010-10-25 17:00:00	AAPL	Stock	11.0257	11.03	11.0246	11.0254	165116.0
2010-10-25 18:00:00	AAPL	Stock	11.0268	11.03	10.9821	10.9857	2298576.0
2010-10-25 19:00:00	AAPL	Stock	10.9857	10.9857	10.9518	10.9639	5204808.0
2010-10-25 06:00:00	MSFT	Stock	25.39	25.44	25.37	25.4	10818.0
2010-10-25 07:00:00	MSFT	Stock	25.4	25.4	25.3	25.37	41660.0
2010-10-25 08:00:00	MSFT	Stock	25.38	25.4	25.13	25.18	284141.0
2010-10-25 09:00:00	MSFT	Stock	25.19	25.33	25.17	25.2	6367659.0
2010-10-25 10:00:00	MSFT	Stock	25.2	25.34	25.17	25.229	9063397.0
2010-10-25 11:00:00	MSFT	Stock	25.221	25.3	25.21	25.295	3259582.0
2010-10-25 12:00:00	MSFT	Stock	25.3	25.31	25.21	25.23	3323120.0
2010-10-25 13:00:00	MSFT	Stock	25.235	25.33	25.21	25.32	4956427.0
2010-10-25 14:00:00	MSFT	Stock	25.33	25.349	25.22	25.26	4302965.0
2010-10-25 15:00:00	MSFT	Stock	25.25	25.32	25.19	25.19	9280826.0
2010-10-25 16:00:00	MSFT	Stock	25.2	25.32	25.18	25.19	7306494.0
2010-10-25 17:00:00	MSFT	Stock	25.193	25.21	25.19	25.2	27643.0
2010-10-25 18:00:00	MSFT	Stock	25.2	25.21	25.19	25.21	25705.0
2010-10-25 19:00:00	MSFT	Stock	25.22	25.23	25.21	25.22	10200.0
2010-10-25 08:00:00	NVDA	Stock	0.2965	0.2988	0.2965	0.2978	442880.0
2010-10-25 09:00:00	NVDA	Stock	0.2978	0.2992	0.2945	0.2992	96774160.0
2010-10-25 10:00:00	NVDA	Stock	0.299	0.2998	0.2965	0.2975	122758160.0
2010-10-25 11:00:00	NVDA	Stock	0.2975	0.2988	0.296	0.297	100284120.0
2010-10-25 12:00:00	NVDA	Stock	0.2972	0.2975	0.2952	0.2956	49927440.0
2010-10-25 13:00:00	NVDA	Stock	0.2955	0.2992	0.2955	0.2985	88913920.0
2010-10-25 14:00:00	NVDA	Stock	0.2985	0.2992	0.297	0.2978	50951320.0
2010-10-25 15:00:00	NVDA	Stock	0.2978	0.2999	0.297	0.2978	125549680.0
2010-10-25 16:00:00	NVDA	Stock	0.2978	0.2998	0.2958	0.2998	33454160.0
2010-10-25 17:00:00	NVDA	Stock	0.2978	0.2982	0.2978	0.2978	188960.0
2010-10-25 18:00:00	NVDA	Stock	0.2982	0.2982	0.296	0.2968	242680.0
2010-10-25 04:00:00	AMZN	Stock	8.475	8.475	8.475	8.475	16000.0
2010-10-25 05:00:00	AMZN	Stock	8.4925	8.4925	8.4925	8.4925	24000.0
2010-10-25 07:00:00	AMZN	Stock	8.4945	8.65	8.4945	8.533	196000.0
2010-10-25 08:00:00	AMZN	Stock	8.525	8.565	8.5125	8.565	1101400.0
2010-10-25 09:00:00	AMZN	Stock	8.57	8.5995	8.52	8.5755	23697500.0
2010-10-25 10:00:00	AMZN	Stock	8.57	8.5905	8.416	8.4633	30381900.0
2010-10-25 11:00:00	AMZN	Stock	8.465	8.557	8.4515	8.517	19409600.0
2010-10-25 12:00:00	AMZN	Stock	8.515	8.5295	8.491	8.511	8997200.0
2010-10-25 13:00:00	AMZN	Stock	8.51	8.525	8.482	8.5045	9161680.0

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

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