PREVIEW / stock_30min / 2014-10-02

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-10-02.parquet
  size:    1.6 MB
  rows:    83,144
  symbols: 3,578

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-10-02 04:00:00	AAPL	Stock	24.825	24.825	24.7	24.7225	3504.0
2014-10-02 04:30:00	AAPL	Stock	24.7275	24.7275	24.7275	24.7275	3800.0
2014-10-02 05:00:00	AAPL	Stock	24.7375	24.7625	24.7375	24.7625	1608.0
2014-10-02 05:30:00	AAPL	Stock	24.795	24.795	24.795	24.795	10480.0
2014-10-02 06:00:00	AAPL	Stock	24.7925	24.8175	24.7925	24.8125	9400.0
2014-10-02 06:30:00	AAPL	Stock	24.85	24.8775	24.85	24.8625	10612.0
2014-10-02 07:00:00	AAPL	Stock	24.85	24.925	24.84	24.9025	93828.0
2014-10-02 07:30:00	AAPL	Stock	24.915	24.925	24.8925	24.9	90428.0
2014-10-02 08:00:00	AAPL	Stock	24.8975	24.9425	24.8425	24.93	505960.0
2014-10-02 08:30:00	AAPL	Stock	24.925	24.9375	24.875	24.8975	344436.0
2014-10-02 09:00:00	AAPL	Stock	24.89	24.905	24.82	24.82	338352.0
2014-10-02 09:30:00	AAPL	Stock	24.8175	24.94	24.7725	24.8225	21831348.0
2014-10-02 10:00:00	AAPL	Stock	24.82	24.84	24.695	24.7987	16793436.0
2014-10-02 10:30:00	AAPL	Stock	24.7975	24.7975	24.6525	24.6625	12962320.0
2014-10-02 11:00:00	AAPL	Stock	24.6632	24.695	24.59	24.6512	14791620.0
2014-10-02 11:30:00	AAPL	Stock	24.65	24.665	24.51	24.6275	16518860.0
2014-10-02 12:00:00	AAPL	Stock	24.6275	24.7218	24.62	24.7218	7301612.0
2014-10-02 12:30:00	AAPL	Stock	24.7225	24.8625	24.685	24.8475	11281380.0
2014-10-02 13:00:00	AAPL	Stock	24.8475	24.89	24.79	24.865	11664568.0
2014-10-02 13:30:00	AAPL	Stock	24.8638	24.9075	24.8175	24.8925	8701256.0
2014-10-02 14:00:00	AAPL	Stock	24.8925	24.9875	24.8875	24.9628	12624708.0
2014-10-02 14:30:00	AAPL	Stock	24.9625	24.9975	24.9175	24.98	8520776.0
2014-10-02 15:00:00	AAPL	Stock	24.9803	24.9875	24.92	24.9628	10226836.0
2014-10-02 15:30:00	AAPL	Stock	24.96	25.055	24.9525	24.9725	21259716.0
2014-10-02 16:00:00	AAPL	Stock	24.975	25.0042	24.6375	24.765	4527552.0
2014-10-02 16:30:00	AAPL	Stock	24.765	24.975	24.7575	24.775	747472.0
2014-10-02 17:00:00	AAPL	Stock	24.78	24.9975	24.775	24.7875	372468.0
2014-10-02 17:30:00	AAPL	Stock	24.775	24.975	24.75	24.78	255328.0
2014-10-02 18:00:00	AAPL	Stock	24.785	24.975	24.78	24.79	192100.0
2014-10-02 18:30:00	AAPL	Stock	24.7875	24.975	24.78	24.785	87420.0
2014-10-02 19:00:00	AAPL	Stock	24.7925	24.8375	24.7875	24.8125	125492.0
2014-10-02 19:30:00	AAPL	Stock	24.825	24.825	24.8	24.81	56752.0
2014-10-02 04:00:00	MSFT	Stock	45.81	45.81	45.78	45.78	245.0
2014-10-02 06:30:00	MSFT	Stock	45.9	45.9	45.9	45.9	600.0
2014-10-02 07:00:00	MSFT	Stock	45.9	45.9	45.9	45.9	1000.0
2014-10-02 07:30:00	MSFT	Stock	46.08	46.18	46.06	46.06	1900.0
2014-10-02 08:00:00	MSFT	Stock	46.08	46.08	46.05	46.05	700.0
2014-10-02 08:30:00	MSFT	Stock	46.07	46.16	45.9	45.99	4354.0
2014-10-02 09:00:00	MSFT	Stock	45.9	45.91	45.83	45.85	17032.0
2014-10-02 09:30:00	MSFT	Stock	45.83	46.1	45.82	45.98	2886728.0
2014-10-02 10:00:00	MSFT	Stock	45.985	46.0	45.84	45.876	1771184.0
2014-10-02 10:30:00	MSFT	Stock	45.87	45.87	45.713	45.76	2012796.0
2014-10-02 11:00:00	MSFT	Stock	45.76	45.9	45.76	45.857	1282457.0
2014-10-02 11:30:00	MSFT	Stock	45.852	45.874	45.64	45.815	1886172.0
2014-10-02 12:00:00	MSFT	Stock	45.82	45.905	45.77	45.79	1156529.0
2014-10-02 12:30:00	MSFT	Stock	45.79	45.89	45.73	45.875	1499179.0
2014-10-02 13:00:00	MSFT	Stock	45.88	45.95	45.83	45.925	1524712.0
2014-10-02 13:30:00	MSFT	Stock	45.915	45.96	45.8	45.823	1358851.0
2014-10-02 14:00:00	MSFT	Stock	45.825	45.94	45.81	45.92	1206841.0
2014-10-02 14:30:00	MSFT	Stock	45.92	45.98	45.83	45.97	1350520.0

> showing 50 of 83,144 rows — these rows as CSV

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