PREVIEW / stock_1hour / 2011-10-21

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-10-21.parquet
  size:    928 KB
  rows:    45,097
  symbols: 3,492

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
2011-10-21 04:00:00	AAPL	Stock	14.1429	14.1429	14.1429	14.1429	2800.0
2011-10-21 05:00:00	AAPL	Stock	14.1786	14.1786	14.1786	14.1786	2800.0
2011-10-21 06:00:00	AAPL	Stock	14.1786	14.1807	14.1664	14.1664	8400.0
2011-10-21 07:00:00	AAPL	Stock	14.1457	14.2143	14.1457	14.1607	335160.0
2011-10-21 08:00:00	AAPL	Stock	14.1639	14.2046	14.1589	14.1861	3533208.0
2011-10-21 09:00:00	AAPL	Stock	14.1846	14.2325	14.1454	14.179	105714224.0
2011-10-21 10:00:00	AAPL	Stock	14.1814	14.255	14.1796	14.2036	95914028.0
2011-10-21 11:00:00	AAPL	Stock	14.2036	14.2286	14.1639	14.1661	43719340.0
2011-10-21 12:00:00	AAPL	Stock	14.1656	14.1711	14.0564	14.0568	75434128.0
2011-10-21 13:00:00	AAPL	Stock	14.0575	14.0575	13.9554	13.9802	102490052.0
2011-10-21 14:00:00	AAPL	Stock	13.9821	14.0286	13.9782	14.005	62721680.0
2011-10-21 15:00:00	AAPL	Stock	14.0038	14.0746	13.9786	14.0371	106503068.0
2011-10-21 16:00:00	AAPL	Stock	14.0307	14.1043	14.005	14.0229	14860524.0
2011-10-21 17:00:00	AAPL	Stock	14.0221	14.0779	14.0161	14.0689	1002736.0
2011-10-21 18:00:00	AAPL	Stock	14.0696	14.0839	14.0311	14.0789	447048.0
2011-10-21 19:00:00	AAPL	Stock	14.0793	14.1071	14.0786	14.0893	502516.0
2011-10-21 06:00:00	MSFT	Stock	26.84	26.9	26.84	26.9	600.0
2011-10-21 07:00:00	MSFT	Stock	26.97	27.2	26.97	26.98	112663.0
2011-10-21 08:00:00	MSFT	Stock	26.98	27.12	26.96	27.11	447497.0
2011-10-21 09:00:00	MSFT	Stock	27.11	27.21	26.83	26.86	19392546.0
2011-10-21 10:00:00	MSFT	Stock	26.86	27.18	26.8	27.124	11361083.0
2011-10-21 11:00:00	MSFT	Stock	27.12	27.13	27.01	27.02	6741046.0
2011-10-21 12:00:00	MSFT	Stock	27.025	27.1	27.0	27.04	3536453.0
2011-10-21 13:00:00	MSFT	Stock	27.04	27.04	26.85	26.875	8414963.0
2011-10-21 14:00:00	MSFT	Stock	26.875	27.04	26.86	27.02	6660509.0
2011-10-21 15:00:00	MSFT	Stock	27.02	27.16	26.96	27.15	14328151.0
2011-10-21 16:00:00	MSFT	Stock	27.15	27.18	27.032	27.15	4199615.0
2011-10-21 17:00:00	MSFT	Stock	27.16	27.16	27.09	27.14	60551.0
2011-10-21 18:00:00	MSFT	Stock	27.16	27.16	27.14	27.16	26950.0
2011-10-21 19:00:00	MSFT	Stock	27.14	27.17	27.09	27.17	12619.0
2011-10-21 07:00:00	NVDA	Stock	0.365	0.365	0.365	0.365	4000.0
2011-10-21 08:00:00	NVDA	Stock	0.3652	0.3692	0.3652	0.3682	199160.0
2011-10-21 09:00:00	NVDA	Stock	0.3682	0.3715	0.3592	0.3622	112712440.0
2011-10-21 10:00:00	NVDA	Stock	0.3622	0.3708	0.3622	0.3652	93916560.0
2011-10-21 11:00:00	NVDA	Stock	0.3655	0.3658	0.3602	0.3632	63232120.0
2011-10-21 12:00:00	NVDA	Stock	0.3632	0.3635	0.3578	0.3582	58736680.0
2011-10-21 13:00:00	NVDA	Stock	0.3582	0.3605	0.356	0.3595	63567640.0
2011-10-21 14:00:00	NVDA	Stock	0.3595	0.3625	0.359	0.3621	60722040.0
2011-10-21 15:00:00	NVDA	Stock	0.3622	0.363	0.3578	0.3622	149431120.0
2011-10-21 16:00:00	NVDA	Stock	0.362	0.3625	0.3608	0.361	12931920.0
2011-10-21 17:00:00	NVDA	Stock	0.3608	0.3625	0.3608	0.3625	49800.0
2011-10-21 18:00:00	NVDA	Stock	0.362	0.362	0.362	0.362	556800.0
2011-10-21 19:00:00	NVDA	Stock	0.3615	0.362	0.3612	0.362	132000.0
2011-10-21 05:00:00	AMZN	Stock	11.699	11.7175	11.699	11.7175	4000.0
2011-10-21 07:00:00	AMZN	Stock	11.76	11.8175	11.76	11.8175	18000.0
2011-10-21 08:00:00	AMZN	Stock	11.769	11.807	11.7615	11.798	100360.0
2011-10-21 09:00:00	AMZN	Stock	11.808	11.85	11.6895	11.7068	21462780.0
2011-10-21 10:00:00	AMZN	Stock	11.7065	11.824	11.7005	11.7685	13601980.0
2011-10-21 11:00:00	AMZN	Stock	11.767	11.8025	11.7195	11.7225	6366540.0
2011-10-21 12:00:00	AMZN	Stock	11.725	11.7454	11.64	11.641	8722960.0

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

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