PREVIEW / stock_1hour / 2012-10-19

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-10-19.parquet
  size:    940 KB
  rows:    44,013
  symbols: 3,465

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
2012-10-19 04:00:00	AAPL	Stock	22.575	22.575	22.5571	22.5571	16800.0
2012-10-19 05:00:00	AAPL	Stock	22.5179	22.5179	22.5179	22.5179	15120.0
2012-10-19 06:00:00	AAPL	Stock	22.5271	22.5271	22.5268	22.5268	18760.0
2012-10-19 07:00:00	AAPL	Stock	22.5268	22.5804	22.4875	22.5429	566048.0
2012-10-19 08:00:00	AAPL	Stock	22.5179	22.5757	22.5071	22.5436	937636.0
2012-10-19 09:00:00	AAPL	Stock	22.5436	22.5693	22.3493	22.4379	112333228.0
2012-10-19 10:00:00	AAPL	Stock	22.4336	22.4582	22.3307	22.3354	65383808.0
2012-10-19 11:00:00	AAPL	Stock	22.3379	22.3454	21.9871	22.0907	156695280.0
2012-10-19 12:00:00	AAPL	Stock	22.0881	22.1579	22.0207	22.0932	68219228.0
2012-10-19 13:00:00	AAPL	Stock	22.0889	22.1546	21.9882	22.0367	55911884.0
2012-10-19 14:00:00	AAPL	Stock	22.0355	22.0482	21.9143	21.9532	77307552.0
2012-10-19 15:00:00	AAPL	Stock	21.9525	21.9671	21.7721	21.778	152307092.0
2012-10-19 16:00:00	AAPL	Stock	21.7789	22.2896	21.7774	21.7839	30353344.0
2012-10-19 17:00:00	AAPL	Stock	21.7846	22.3325	21.7679	21.7843	3009552.0
2012-10-19 18:00:00	AAPL	Stock	21.7821	21.7821	21.7536	21.7639	276528.0
2012-10-19 19:00:00	AAPL	Stock	21.7679	21.78	21.7536	21.7611	272972.0
2012-10-19 04:00:00	MSFT	Stock	29.0	29.0	28.99	28.99	1300.0
2012-10-19 05:00:00	MSFT	Stock	28.98	28.98	28.86	28.86	1300.0
2012-10-19 06:00:00	MSFT	Stock	28.96	28.96	28.91	28.91	331.0
2012-10-19 07:00:00	MSFT	Stock	28.91	28.96	28.88	28.93	14838.0
2012-10-19 08:00:00	MSFT	Stock	28.95	29.08	28.75	28.94	431626.0
2012-10-19 09:00:00	MSFT	Stock	28.94	29.54	28.56	29.02	24674761.0
2012-10-19 10:00:00	MSFT	Stock	29.0	29.011	28.75	28.848	12424630.0
2012-10-19 11:00:00	MSFT	Stock	28.85	28.87	28.66	28.7	8611437.0
2012-10-19 12:00:00	MSFT	Stock	28.71	28.77	28.61	28.687	5661922.0
2012-10-19 13:00:00	MSFT	Stock	28.68	28.79	28.6	28.63	4842593.0
2012-10-19 14:00:00	MSFT	Stock	28.63	28.68	28.51	28.59	6443471.0
2012-10-19 15:00:00	MSFT	Stock	28.595	28.66	28.5	28.64	17008017.0
2012-10-19 16:00:00	MSFT	Stock	28.63	28.8	28.57	28.66	8590763.0
2012-10-19 17:00:00	MSFT	Stock	28.64	28.72	28.63	28.68	17744.0
2012-10-19 18:00:00	MSFT	Stock	28.68	28.68	28.64	28.65	1500.0
2012-10-19 19:00:00	MSFT	Stock	28.64	28.66	28.63	28.66	5563.0
2012-10-19 07:00:00	NVDA	Stock	0.3175	0.3175	0.3155	0.3155	120000.0
2012-10-19 08:00:00	NVDA	Stock	0.3155	0.3168	0.3155	0.3168	34000.0
2012-10-19 09:00:00	NVDA	Stock	0.3185	0.319	0.315	0.3155	85968040.0
2012-10-19 10:00:00	NVDA	Stock	0.3153	0.3158	0.3103	0.3105	105363440.0
2012-10-19 11:00:00	NVDA	Stock	0.3103	0.3105	0.3058	0.308	108429880.0
2012-10-19 12:00:00	NVDA	Stock	0.308	0.3081	0.3055	0.307	49266040.0
2012-10-19 13:00:00	NVDA	Stock	0.307	0.308	0.3042	0.3042	69255960.0
2012-10-19 14:00:00	NVDA	Stock	0.3042	0.305	0.3009	0.3029	124446480.0
2012-10-19 15:00:00	NVDA	Stock	0.303	0.3042	0.3022	0.3026	148592640.0
2012-10-19 16:00:00	NVDA	Stock	0.3028	0.3074	0.3022	0.303	13509320.0
2012-10-19 17:00:00	NVDA	Stock	0.303	0.303	0.303	0.303	244000.0
2012-10-19 18:00:00	NVDA	Stock	0.3045	0.3045	0.3045	0.3045	30400.0
2012-10-19 19:00:00	NVDA	Stock	0.3045	0.3045	0.3028	0.3028	329320.0
2012-10-19 08:00:00	AMZN	Stock	12.153	12.238	12.153	12.225	34000.0
2012-10-19 09:00:00	AMZN	Stock	12.225	12.341	12.2065	12.3175	19106820.0
2012-10-19 10:00:00	AMZN	Stock	12.317	12.325	12.1486	12.175	10271020.0
2012-10-19 11:00:00	AMZN	Stock	12.185	12.1855	12.0555	12.076	11012360.0
2012-10-19 12:00:00	AMZN	Stock	12.076	12.0795	11.9825	12.025	9926860.0

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

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