PREVIEW / stock_30min / 2012-04-13

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-04-13.parquet
  size:    1.4 MB
  rows:    73,736
  symbols: 3,510

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
2012-04-13 04:00:00	AAPL	Stock	22.2143	22.2143	22.2054	22.2054	25200.0
2012-04-13 04:30:00	AAPL	Stock	22.2054	22.2054	22.1893	22.1893	180600.0
2012-04-13 05:00:00	AAPL	Stock	22.2036	22.2043	22.1893	22.1893	44940.0
2012-04-13 05:30:00	AAPL	Stock	22.2014	22.2014	22.2014	22.2014	2800.0
2012-04-13 06:00:00	AAPL	Stock	22.2018	22.2018	22.1964	22.1964	21980.0
2012-04-13 06:30:00	AAPL	Stock	22.2321	22.2321	22.2107	22.2214	22708.0
2012-04-13 07:00:00	AAPL	Stock	22.2464	22.2536	22.2321	22.25	291872.0
2012-04-13 07:30:00	AAPL	Stock	22.2432	22.2529	22.2004	22.2054	595672.0
2012-04-13 08:00:00	AAPL	Stock	22.2054	22.2464	22.1118	22.1964	1773072.0
2012-04-13 08:30:00	AAPL	Stock	22.1957	22.2329	22.1811	22.2207	862988.0
2012-04-13 09:00:00	AAPL	Stock	22.2275	22.3179	22.2207	22.2936	3436580.0
2012-04-13 09:30:00	AAPL	Stock	22.2939	22.3107	22.0496	22.0561	112282016.0
2012-04-13 10:00:00	AAPL	Stock	22.0589	22.0804	21.7346	21.8021	126942200.0
2012-04-13 10:30:00	AAPL	Stock	21.8032	21.8518	21.5539	21.7264	128643004.0
2012-04-13 11:00:00	AAPL	Stock	21.7189	21.7382	21.5829	21.7368	69357512.0
2012-04-13 11:30:00	AAPL	Stock	21.735	21.8107	21.6604	21.7353	54361860.0
2012-04-13 12:00:00	AAPL	Stock	21.7361	21.7996	21.7304	21.7779	30884980.0
2012-04-13 12:30:00	AAPL	Stock	21.7775	21.7814	21.6857	21.7425	30046184.0
2012-04-13 13:00:00	AAPL	Stock	21.7414	21.7839	21.705	21.7329	23276512.0
2012-04-13 13:30:00	AAPL	Stock	21.7339	21.8025	21.7107	21.7143	30703288.0
2012-04-13 14:00:00	AAPL	Stock	21.7143	21.7625	21.6918	21.7039	28496244.0
2012-04-13 14:30:00	AAPL	Stock	21.7054	21.7517	21.6918	21.7407	17964576.0
2012-04-13 15:00:00	AAPL	Stock	21.74	21.8143	21.7318	21.7636	35019992.0
2012-04-13 15:30:00	AAPL	Stock	21.7671	21.7846	21.5982	21.6139	89713344.0
2012-04-13 16:00:00	AAPL	Stock	21.6154	21.8143	21.5982	21.6086	61662300.0
2012-04-13 16:30:00	AAPL	Stock	21.6064	21.7527	21.6039	21.6054	1539832.0
2012-04-13 17:00:00	AAPL	Stock	21.6057	21.6154	21.6046	21.6054	405832.0
2012-04-13 17:30:00	AAPL	Stock	21.6071	21.6071	21.5714	21.5829	432152.0
2012-04-13 18:00:00	AAPL	Stock	21.5775	21.6071	21.5718	21.6029	177520.0
2012-04-13 18:30:00	AAPL	Stock	21.6036	21.6036	21.5889	21.5889	112700.0
2012-04-13 19:00:00	AAPL	Stock	21.5886	21.6071	21.585	21.585	146188.0
2012-04-13 19:30:00	AAPL	Stock	21.5871	21.6018	21.5871	21.5893	154896.0
2012-04-13 07:00:00	MSFT	Stock	30.9	30.95	30.9	30.95	300.0
2012-04-13 07:30:00	MSFT	Stock	30.9	30.9	30.9	30.9	300.0
2012-04-13 08:00:00	MSFT	Stock	30.91	30.95	30.8	30.86	8100.0
2012-04-13 08:30:00	MSFT	Stock	30.86	30.9	30.86	30.9	2600.0
2012-04-13 09:00:00	MSFT	Stock	30.92	31.005	30.81	30.89	59525.0
2012-04-13 09:30:00	MSFT	Stock	30.89	31.1	30.72	30.92	4483544.0
2012-04-13 10:00:00	MSFT	Stock	30.92	31.16	30.85	30.87	4669040.0
2012-04-13 10:30:00	MSFT	Stock	30.87	30.93	30.77	30.91	2589369.0
2012-04-13 11:00:00	MSFT	Stock	30.91	31.01	30.88	30.97	1950491.0
2012-04-13 11:30:00	MSFT	Stock	30.97	31.1	30.94	31.02	1956942.0
2012-04-13 12:00:00	MSFT	Stock	31.03	31.045	30.93	31.01	1375367.0
2012-04-13 12:30:00	MSFT	Stock	31.0	31.08	31.0	31.07	1272634.0
2012-04-13 13:00:00	MSFT	Stock	31.08	31.08	31.02	31.04	1252582.0
2012-04-13 13:30:00	MSFT	Stock	31.04	31.11	31.02	31.025	1216242.0
2012-04-13 14:00:00	MSFT	Stock	31.022	31.08	30.96	31.03	2252985.0
2012-04-13 14:30:00	MSFT	Stock	31.03	31.06	30.95	30.98	1471403.0
2012-04-13 15:00:00	MSFT	Stock	30.97	31.075	30.95	30.971	2265914.0
2012-04-13 15:30:00	MSFT	Stock	30.975	31.015	30.8	30.81	5890398.0

> showing 50 of 73,736 rows — these rows as CSV

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