PREVIEW / stock_1hour / 2014-12-24

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-12-24.parquet
  size:    705 KB
  rows:    29,779
  symbols: 3,454

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
2014-12-24 06:00:00	AAPL	Stock	28.135	28.135	28.135	28.135	400.0
2014-12-24 07:00:00	AAPL	Stock	28.125	28.2175	28.125	28.19	32532.0
2014-12-24 08:00:00	AAPL	Stock	28.1875	28.21	28.125	28.1875	257144.0
2014-12-24 09:00:00	AAPL	Stock	28.1775	28.1775	28.03	28.075	10197148.0
2014-12-24 10:00:00	AAPL	Stock	28.075	28.0875	28.0025	28.0625	11042936.0
2014-12-24 11:00:00	AAPL	Stock	28.06	28.075	28.0325	28.0425	6280276.0
2014-12-24 12:00:00	AAPL	Stock	28.0438	28.055	28.0025	28.0025	10379576.0
2014-12-24 13:00:00	AAPL	Stock	28.0025	28.0602	27.9975	28.0025	16213368.0
2014-12-24 14:00:00	AAPL	Stock	28.0025	28.0398	28.0025	28.0025	67260.0
2014-12-24 15:00:00	AAPL	Stock	28.005	28.0125	28.005	28.005	22516.0
2014-12-24 16:00:00	AAPL	Stock	28.0075	28.0075	28.005	28.005	6980.0
2014-12-24 08:00:00	MSFT	Stock	48.72	48.72	48.61	48.61	2002.0
2014-12-24 09:00:00	MSFT	Stock	48.61	48.64	48.08	48.24	2020691.0
2014-12-24 10:00:00	MSFT	Stock	48.24	48.31	48.1	48.28	1705663.0
2014-12-24 11:00:00	MSFT	Stock	48.285	48.31	48.15	48.294	1428161.0
2014-12-24 12:00:00	MSFT	Stock	48.3	48.35	48.13	48.15	2429829.0
2014-12-24 13:00:00	MSFT	Stock	48.14	48.24	48.14	48.16	2980400.0
2014-12-24 14:00:00	MSFT	Stock	48.11	48.244	48.1	48.244	16989.0
2014-12-24 15:00:00	MSFT	Stock	48.15	48.2	48.15	48.2	2895.0
2014-12-24 16:00:00	MSFT	Stock	48.3	48.3	48.3	48.3	1000.0
2014-12-24 09:00:00	NVDA	Stock	0.5175	0.5181	0.515	0.5168	5601800.0
2014-12-24 10:00:00	NVDA	Stock	0.5168	0.5175	0.5145	0.5145	11623400.0
2014-12-24 11:00:00	NVDA	Stock	0.5145	0.5162	0.5142	0.5162	8676520.0
2014-12-24 12:00:00	NVDA	Stock	0.5162	0.5162	0.5138	0.5142	13481560.0
2014-12-24 13:00:00	NVDA	Stock	0.5142	0.5162	0.5142	0.5142	4219960.0
2014-12-24 14:00:00	NVDA	Stock	0.5159	0.5159	0.5159	0.5159	599920.0
2014-12-24 08:00:00	AMZN	Stock	15.3445	15.3445	15.322	15.322	8000.0
2014-12-24 09:00:00	AMZN	Stock	15.3245	15.35	15.2285	15.283	3730260.0
2014-12-24 10:00:00	AMZN	Stock	15.283	15.298	15.2065	15.2498	7947160.0
2014-12-24 11:00:00	AMZN	Stock	15.2555	15.261	15.1756	15.1855	6978500.0
2014-12-24 12:00:00	AMZN	Stock	15.181	15.2265	15.1438	15.1455	7424820.0
2014-12-24 13:00:00	AMZN	Stock	15.1515	15.2232	15.1515	15.1665	1816980.0
2014-12-24 14:00:00	AMZN	Stock	15.1484	15.1484	15.1484	15.1484	4300.0
2014-12-24 15:00:00	AMZN	Stock	15.175	15.175	15.15	15.15	80000.0
2014-12-24 09:00:00	GOOGL	Stock	26.95	26.984	26.755	26.8665	1794120.0
2014-12-24 10:00:00	GOOGL	Stock	26.8795	26.898	26.772	26.858	2567980.0
2014-12-24 11:00:00	GOOGL	Stock	26.847	27.0145	26.8445	26.9395	3047580.0
2014-12-24 12:00:00	GOOGL	Stock	26.927	26.956	26.829	26.857	2347000.0
2014-12-24 13:00:00	GOOGL	Stock	26.853	26.8783	26.8	26.8	922980.0
2014-12-24 16:00:00	GOOGL	Stock	26.85	26.85	26.85	26.85	2000.0
2014-12-24 07:00:00	META	Stock	80.61	80.88	80.61	80.88	3844.0
2014-12-24 08:00:00	META	Stock	80.805	81.18	80.35	81.1	145189.0
2014-12-24 09:00:00	META	Stock	81.08	81.43	80.75	81.24	2166938.0
2014-12-24 10:00:00	META	Stock	81.235	81.28	80.84	81.114	1933329.0
2014-12-24 11:00:00	META	Stock	81.119	81.22	80.97	80.985	1065787.0
2014-12-24 12:00:00	META	Stock	81.0	81.06	80.76	80.77	1578638.0
2014-12-24 13:00:00	META	Stock	80.77	81.045	80.65	80.68	347987.0
2014-12-24 14:00:00	META	Stock	80.65	81.056	80.65	80.7	15209.0
2014-12-24 15:00:00	META	Stock	80.72	80.72	80.7	80.72	5533.0
2014-12-24 16:00:00	META	Stock	80.72	80.77	80.68	80.77	5418.0

> showing 50 of 29,779 rows — these rows as CSV

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