PREVIEW / stock_30min / 2011-10-21

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-10-21.parquet
  size:    1.4 MB
  rows:    74,801
  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:30: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.1786	14.1807	5600.0
2011-10-21 06:30:00	AAPL	Stock	14.1664	14.1664	14.1664	14.1664	2800.0
2011-10-21 07:00:00	AAPL	Stock	14.1457	14.2143	14.1457	14.2143	106288.0
2011-10-21 07:30:00	AAPL	Stock	14.2143	14.2143	14.1607	14.1607	228872.0
2011-10-21 08:00:00	AAPL	Stock	14.1639	14.2046	14.1589	14.2014	2512972.0
2011-10-21 08:30:00	AAPL	Stock	14.1954	14.1954	14.1654	14.1861	1020236.0
2011-10-21 09:00:00	AAPL	Stock	14.1846	14.2325	14.1804	14.2214	3539396.0
2011-10-21 09:30:00	AAPL	Stock	14.2214	14.2314	14.1454	14.179	102174828.0
2011-10-21 10:00:00	AAPL	Stock	14.1814	14.255	14.1796	14.2346	59717980.0
2011-10-21 10:30:00	AAPL	Stock	14.2357	14.2482	14.1875	14.2036	36196048.0
2011-10-21 11:00:00	AAPL	Stock	14.2036	14.2286	14.1964	14.2086	20951420.0
2011-10-21 11:30:00	AAPL	Stock	14.2093	14.2143	14.1639	14.1661	22767920.0
2011-10-21 12:00:00	AAPL	Stock	14.1656	14.1711	14.1204	14.1225	29402520.0
2011-10-21 12:30:00	AAPL	Stock	14.1218	14.1246	14.0564	14.0568	46031608.0
2011-10-21 13:00:00	AAPL	Stock	14.0575	14.0575	13.9771	13.9793	62153196.0
2011-10-21 13:30:00	AAPL	Stock	13.9839	14.0107	13.9554	13.9802	40336856.0
2011-10-21 14:00:00	AAPL	Stock	13.9821	14.0286	13.9782	13.9954	34964020.0
2011-10-21 14:30:00	AAPL	Stock	13.9971	14.0286	13.9879	14.005	27757660.0
2011-10-21 15:00:00	AAPL	Stock	14.0038	14.0746	14.0018	14.0271	44819404.0
2011-10-21 15:30:00	AAPL	Stock	14.0289	14.0433	13.9786	14.0371	61683664.0
2011-10-21 16:00:00	AAPL	Stock	14.0307	14.1043	14.005	14.0171	14230524.0
2011-10-21 16:30:00	AAPL	Stock	14.0171	14.0393	14.0118	14.0229	630000.0
2011-10-21 17:00:00	AAPL	Stock	14.0221	14.05	14.0161	14.0389	541688.0
2011-10-21 17:30:00	AAPL	Stock	14.0429	14.0779	14.04	14.0689	461048.0
2011-10-21 18:00:00	AAPL	Stock	14.0696	14.0714	14.0311	14.0639	275072.0
2011-10-21 18:30:00	AAPL	Stock	14.0643	14.0839	14.0643	14.0789	171976.0
2011-10-21 19:00:00	AAPL	Stock	14.0793	14.1071	14.0786	14.1071	354620.0
2011-10-21 19:30:00	AAPL	Stock	14.0911	14.1029	14.0893	14.0893	147896.0
2011-10-21 06:00:00	MSFT	Stock	26.84	26.84	26.84	26.84	500.0
2011-10-21 06:30:00	MSFT	Stock	26.9	26.9	26.9	26.9	100.0
2011-10-21 07:00:00	MSFT	Stock	26.97	27.1	26.97	27.1	9000.0
2011-10-21 07:30:00	MSFT	Stock	27.13	27.2	26.97	26.98	103663.0
2011-10-21 08:00:00	MSFT	Stock	26.98	27.1	26.96	27.04	93631.0
2011-10-21 08:30:00	MSFT	Stock	27.06	27.12	26.98	27.11	353866.0
2011-10-21 09:00:00	MSFT	Stock	27.11	27.21	27.0	27.14	860580.0
2011-10-21 09:30:00	MSFT	Stock	27.14	27.19	26.83	26.86	18531966.0
2011-10-21 10:00:00	MSFT	Stock	26.86	27.16	26.8	27.12	6979656.0
2011-10-21 10:30:00	MSFT	Stock	27.125	27.18	27.1	27.124	4381427.0
2011-10-21 11:00:00	MSFT	Stock	27.12	27.13	27.03	27.09	3569537.0
2011-10-21 11:30:00	MSFT	Stock	27.08	27.13	27.01	27.02	3171509.0
2011-10-21 12:00:00	MSFT	Stock	27.025	27.1	27.0	27.09	1942952.0
2011-10-21 12:30:00	MSFT	Stock	27.09	27.1	27.02	27.04	1593501.0
2011-10-21 13:00:00	MSFT	Stock	27.04	27.04	26.88	26.94	4360850.0
2011-10-21 13:30:00	MSFT	Stock	26.935	27.0	26.85	26.875	4054113.0
2011-10-21 14:00:00	MSFT	Stock	26.875	27.04	26.86	27.0	3781462.0
2011-10-21 14:30:00	MSFT	Stock	27.0	27.03	26.92	27.02	2879047.0
2011-10-21 15:00:00	MSFT	Stock	27.02	27.1	27.0	27.03	3513867.0
2011-10-21 15:30:00	MSFT	Stock	27.035	27.16	26.96	27.15	10814284.0

> showing 50 of 74,801 rows — these rows as CSV

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