PREVIEW / stock_30min / 2013-02-01

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-02-01.parquet
  size:    1.5 MB
  rows:    78,503
  symbols: 3,461

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
2013-02-01 04:00:00	AAPL	Stock	16.3886	16.3929	16.3886	16.3929	14000.0
2013-02-01 04:30:00	AAPL	Stock	16.3907	16.3907	16.3907	16.3907	2800.0
2013-02-01 06:00:00	AAPL	Stock	16.3525	16.3564	16.3525	16.3564	11200.0
2013-02-01 06:30:00	AAPL	Stock	16.3429	16.3429	16.3214	16.3214	5600.0
2013-02-01 07:00:00	AAPL	Stock	16.3214	16.3929	16.3214	16.3929	201180.0
2013-02-01 07:30:00	AAPL	Stock	16.3929	16.4018	16.365	16.3679	178192.0
2013-02-01 08:00:00	AAPL	Stock	16.3661	16.3879	16.3571	16.3571	671888.0
2013-02-01 08:30:00	AAPL	Stock	16.3571	16.4107	16.325	16.3929	1865724.0
2013-02-01 09:00:00	AAPL	Stock	16.3889	16.41	16.3714	16.4079	1349432.0
2013-02-01 09:30:00	AAPL	Stock	16.4075	16.41	16.12	16.1332	85413356.0
2013-02-01 10:00:00	AAPL	Stock	16.135	16.2246	16.1289	16.1396	42366632.0
2013-02-01 10:30:00	AAPL	Stock	16.1411	16.1557	16.0125	16.0514	60322388.0
2013-02-01 11:00:00	AAPL	Stock	16.0529	16.1014	16.0268	16.0814	32856992.0
2013-02-01 11:30:00	AAPL	Stock	16.0804	16.1686	16.0779	16.1496	31975524.0
2013-02-01 12:00:00	AAPL	Stock	16.1493	16.2107	16.1379	16.2018	29899744.0
2013-02-01 12:30:00	AAPL	Stock	16.1979	16.2811	16.1975	16.2643	34722296.0
2013-02-01 13:00:00	AAPL	Stock	16.2621	16.2643	16.2193	16.2393	16178540.0
2013-02-01 13:30:00	AAPL	Stock	16.2386	16.3118	16.2386	16.2929	23565416.0
2013-02-01 14:00:00	AAPL	Stock	16.29	16.3014	16.1996	16.22	22700944.0
2013-02-01 14:30:00	AAPL	Stock	16.2196	16.2343	16.1621	16.2161	23298100.0
2013-02-01 15:00:00	AAPL	Stock	16.215	16.2254	16.1393	16.1532	24383660.0
2013-02-01 15:30:00	AAPL	Stock	16.1529	16.2071	16.1121	16.2057	56794080.0
2013-02-01 16:00:00	AAPL	Stock	16.2046	16.2111	16.1943	16.2036	26378968.0
2013-02-01 16:30:00	AAPL	Stock	16.2025	16.2143	16.1151	16.2107	457044.0
2013-02-01 17:00:00	AAPL	Stock	16.2075	16.2096	16.2007	16.2093	238448.0
2013-02-01 17:30:00	AAPL	Stock	16.2061	16.2143	16.2036	16.2143	167776.0
2013-02-01 18:00:00	AAPL	Stock	16.15	16.2143	16.15	16.2025	101584.0
2013-02-01 18:30:00	AAPL	Stock	16.2018	16.2104	16.1811	16.1929	179340.0
2013-02-01 19:00:00	AAPL	Stock	16.1929	16.1996	16.1839	16.1911	48496.0
2013-02-01 19:30:00	AAPL	Stock	16.1964	16.2089	16.1964	16.2075	147868.0
2013-02-01 04:30:00	MSFT	Stock	27.59	27.59	27.59	27.59	100.0
2013-02-01 06:30:00	MSFT	Stock	27.58	27.58	27.58	27.58	600.0
2013-02-01 07:00:00	MSFT	Stock	27.58	27.58	27.58	27.58	200.0
2013-02-01 08:00:00	MSFT	Stock	27.55	27.59	27.55	27.58	7850.0
2013-02-01 08:30:00	MSFT	Stock	27.58	27.67	27.45	27.67	94550.0
2013-02-01 09:00:00	MSFT	Stock	27.67	27.7	27.64	27.67	76939.0
2013-02-01 09:30:00	MSFT	Stock	27.67	27.71	27.55	27.697	4823188.0
2013-02-01 10:00:00	MSFT	Stock	27.695	27.89	27.69	27.815	5877039.0
2013-02-01 10:30:00	MSFT	Stock	27.81	27.83	27.74	27.825	3201852.0
2013-02-01 11:00:00	MSFT	Stock	27.825	27.896	27.81	27.88	4246647.0
2013-02-01 11:30:00	MSFT	Stock	27.875	27.94	27.8	27.905	2942130.0
2013-02-01 12:00:00	MSFT	Stock	27.91	27.95	27.89	27.942	1850313.0
2013-02-01 12:30:00	MSFT	Stock	27.94	28.0	27.92	27.95	2176699.0
2013-02-01 13:00:00	MSFT	Stock	27.945	28.02	27.91	27.995	2647167.0
2013-02-01 13:30:00	MSFT	Stock	27.995	28.05	27.89	27.91	4246197.0
2013-02-01 14:00:00	MSFT	Stock	27.915	27.99	27.89	27.95	2675511.0
2013-02-01 14:30:00	MSFT	Stock	27.96	27.97	27.91	27.91	2431109.0
2013-02-01 15:00:00	MSFT	Stock	27.91	27.965	27.89	27.895	2530936.0
2013-02-01 15:30:00	MSFT	Stock	27.9	27.96	27.81	27.93	10297664.0
2013-02-01 16:00:00	MSFT	Stock	27.92	27.988	27.8	27.93	3518128.0

> showing 50 of 78,503 rows — these rows as CSV

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