PREVIEW / stock_1hour / 2010-10-18

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-10-18.parquet
  size:    933 KB
  rows:    45,486
  symbols: 3,503

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-18 04:00:00	AAPL	Stock	11.3182	11.3182	11.3182	11.3182	11060.0
2010-10-18 05:00:00	AAPL	Stock	11.2275	11.2789	11.2275	11.2789	7280.0
2010-10-18 06:00:00	AAPL	Stock	11.2718	11.2857	11.2693	11.2857	17080.0
2010-10-18 07:00:00	AAPL	Stock	11.2854	11.3314	11.2714	11.2896	1591828.0
2010-10-18 08:00:00	AAPL	Stock	11.2964	11.4246	11.2864	11.3857	17750376.0
2010-10-18 09:00:00	AAPL	Stock	11.3839	11.3929	11.2246	11.3332	206801644.0
2010-10-18 10:00:00	AAPL	Stock	11.3339	11.3536	11.2893	11.3125	136901268.0
2010-10-18 11:00:00	AAPL	Stock	11.3135	11.3196	11.2836	11.2961	89527228.0
2010-10-18 12:00:00	AAPL	Stock	11.2961	11.3132	11.25	11.2551	82716424.0
2010-10-18 13:00:00	AAPL	Stock	11.2546	11.2821	11.23	11.235	91667492.0
2010-10-18 14:00:00	AAPL	Stock	11.2339	11.2964	11.2275	11.2696	111214964.0
2010-10-18 15:00:00	AAPL	Stock	11.2697	11.3643	11.2696	11.3543	180718440.0
2010-10-18 16:00:00	AAPL	Stock	11.3569	11.3746	10.4554	10.6375	80769556.0
2010-10-18 17:00:00	AAPL	Stock	10.6371	11.3659	10.6071	10.7429	67648952.0
2010-10-18 18:00:00	AAPL	Stock	10.7364	11.3571	10.6929	10.7107	7717416.0
2010-10-18 19:00:00	AAPL	Stock	10.7082	10.7111	10.6429	10.6607	4315052.0
2010-10-18 04:00:00	MSFT	Stock	25.54	25.54	25.54	25.54	200.0
2010-10-18 07:00:00	MSFT	Stock	25.47	25.56	25.47	25.5	14960.0
2010-10-18 08:00:00	MSFT	Stock	25.5	25.52	25.38	25.5	49106.0
2010-10-18 09:00:00	MSFT	Stock	25.5	25.79	25.45	25.79	6153653.0
2010-10-18 10:00:00	MSFT	Stock	25.785	25.95	25.78	25.908	14018522.0
2010-10-18 11:00:00	MSFT	Stock	25.908	25.92	25.7	25.82	5661740.0
2010-10-18 12:00:00	MSFT	Stock	25.82	25.83	25.69	25.7	3157382.0
2010-10-18 13:00:00	MSFT	Stock	25.698	25.73	25.65	25.722	2745237.0
2010-10-18 14:00:00	MSFT	Stock	25.729	25.79	25.7	25.74	3557210.0
2010-10-18 15:00:00	MSFT	Stock	25.739	25.83	25.73	25.81	8208331.0
2010-10-18 16:00:00	MSFT	Stock	25.82	25.89	25.04	25.19	3322595.0
2010-10-18 17:00:00	MSFT	Stock	25.2	25.82	25.2	25.24	236932.0
2010-10-18 18:00:00	MSFT	Stock	25.25	25.82	25.23	25.24	54457.0
2010-10-18 19:00:00	MSFT	Stock	25.23	25.25	25.22	25.22	18569.0
2010-10-18 08:00:00	NVDA	Stock	0.2825	0.2828	0.2825	0.2828	26000.0
2010-10-18 09:00:00	NVDA	Stock	0.2828	0.283	0.2775	0.2785	60522440.0
2010-10-18 10:00:00	NVDA	Stock	0.2785	0.2815	0.2775	0.2812	76563200.0
2010-10-18 11:00:00	NVDA	Stock	0.2812	0.285	0.28	0.2842	106060200.0
2010-10-18 12:00:00	NVDA	Stock	0.2844	0.2852	0.284	0.2846	66939560.0
2010-10-18 13:00:00	NVDA	Stock	0.2848	0.285	0.283	0.2836	38613480.0
2010-10-18 14:00:00	NVDA	Stock	0.2835	0.2845	0.283	0.2845	30660960.0
2010-10-18 15:00:00	NVDA	Stock	0.2845	0.285	0.2838	0.284	59456440.0
2010-10-18 16:00:00	NVDA	Stock	0.284	0.2848	0.282	0.2825	8720120.0
2010-10-18 17:00:00	NVDA	Stock	0.2792	0.281	0.2792	0.2805	79000.0
2010-10-18 18:00:00	NVDA	Stock	0.2803	0.2803	0.28	0.28	184000.0
2010-10-18 19:00:00	NVDA	Stock	0.2795	0.2803	0.2795	0.2803	240000.0
2010-10-18 07:00:00	AMZN	Stock	8.255	8.255	8.2155	8.238	16000.0
2010-10-18 08:00:00	AMZN	Stock	8.238	8.2675	8.215	8.2675	535500.0
2010-10-18 09:00:00	AMZN	Stock	8.2675	8.2795	8.1415	8.1665	28393180.0
2010-10-18 10:00:00	AMZN	Stock	8.165	8.175	8.091	8.128	22204520.0
2010-10-18 11:00:00	AMZN	Stock	8.1315	8.1775	8.1185	8.1665	13464940.0
2010-10-18 12:00:00	AMZN	Stock	8.166	8.171	8.1285	8.1403	8433840.0
2010-10-18 13:00:00	AMZN	Stock	8.1408	8.1635	8.1261	8.15	5826080.0
2010-10-18 14:00:00	AMZN	Stock	8.15	8.186	8.131	8.17	10464400.0

> showing 50 of 45,486 rows — these rows as CSV

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