PREVIEW / stock_30min / 2011-05-05

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-05-05.parquet
  size:    1.4 MB
  rows:    77,464
  symbols: 3,556

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-05-05 04:30:00	AAPL	Stock	12.5139	12.5139	12.5139	12.5139	2800.0
2011-05-05 06:30:00	AAPL	Stock	12.4464	12.4464	12.4464	12.4464	2800.0
2011-05-05 07:00:00	AAPL	Stock	12.4464	12.4729	12.4464	12.4729	16800.0
2011-05-05 07:30:00	AAPL	Stock	12.4721	12.4721	12.4493	12.4493	5600.0
2011-05-05 08:00:00	AAPL	Stock	12.4643	12.4643	12.4393	12.45	388416.0
2011-05-05 08:30:00	AAPL	Stock	12.4446	12.4446	12.405	12.4393	1140440.0
2011-05-05 09:00:00	AAPL	Stock	12.4321	12.4479	12.4271	12.4429	750680.0
2011-05-05 09:30:00	AAPL	Stock	12.4436	12.5339	12.4386	12.4771	59676064.0
2011-05-05 10:00:00	AAPL	Stock	12.4767	12.5125	12.4554	12.4664	31161844.0
2011-05-05 10:30:00	AAPL	Stock	12.4693	12.4996	12.4536	12.4593	19428808.0
2011-05-05 11:00:00	AAPL	Stock	12.4571	12.4893	12.4196	12.4586	26056520.0
2011-05-05 11:30:00	AAPL	Stock	12.4589	12.4929	12.4443	12.4818	18282684.0
2011-05-05 12:00:00	AAPL	Stock	12.4818	12.5146	12.475	12.49	20669628.0
2011-05-05 12:30:00	AAPL	Stock	12.4889	12.49	12.4518	12.4668	12048540.0
2011-05-05 13:00:00	AAPL	Stock	12.4661	12.4911	12.4621	12.4825	9445884.0
2011-05-05 13:30:00	AAPL	Stock	12.4821	12.4882	12.4575	12.4761	9391900.0
2011-05-05 14:00:00	AAPL	Stock	12.4771	12.4954	12.4536	12.4861	9368408.0
2011-05-05 14:30:00	AAPL	Stock	12.4857	12.5021	12.4454	12.4468	18337004.0
2011-05-05 15:00:00	AAPL	Stock	12.4464	12.46	12.3589	12.3598	46663232.0
2011-05-05 15:30:00	AAPL	Stock	12.3589	12.4	12.3589	12.3896	39997804.0
2011-05-05 16:00:00	AAPL	Stock	12.3825	12.4961	12.3821	12.3929	9630068.0
2011-05-05 16:30:00	AAPL	Stock	12.3929	12.4	12.362	12.3961	339696.0
2011-05-05 17:00:00	AAPL	Stock	12.3961	12.4007	12.3946	12.3996	107380.0
2011-05-05 17:30:00	AAPL	Stock	12.4	12.4011	12.39	12.4007	443240.0
2011-05-05 18:00:00	AAPL	Stock	12.4011	12.4014	12.3839	12.4007	134036.0
2011-05-05 18:30:00	AAPL	Stock	12.3979	12.4011	12.3961	12.4004	59444.0
2011-05-05 19:00:00	AAPL	Stock	12.3964	12.4011	12.3961	12.4011	34384.0
2011-05-05 19:30:00	AAPL	Stock	12.4007	12.4107	12.4	12.4036	189756.0
2011-05-05 06:00:00	MSFT	Stock	26.1	26.1	26.06	26.06	2200.0
2011-05-05 06:30:00	MSFT	Stock	26.05	26.05	26.05	26.05	2000.0
2011-05-05 07:00:00	MSFT	Stock	26.0	26.0	26.0	26.0	2900.0
2011-05-05 07:30:00	MSFT	Stock	26.0	26.05	26.0	26.05	2000.0
2011-05-05 08:00:00	MSFT	Stock	26.04	26.04	26.01	26.02	1433.0
2011-05-05 08:30:00	MSFT	Stock	26.01	26.05	25.95	26.05	26332.0
2011-05-05 09:00:00	MSFT	Stock	26.05	26.08	25.95	26.05	25762.0
2011-05-05 09:30:00	MSFT	Stock	26.03	26.08	25.9	25.99	8265111.0
2011-05-05 10:00:00	MSFT	Stock	25.998	26.03	25.89	25.93	4840931.0
2011-05-05 10:30:00	MSFT	Stock	25.93	26.01	25.865	25.92	3254194.0
2011-05-05 11:00:00	MSFT	Stock	25.91	25.93	25.79	25.905	3256118.0
2011-05-05 11:30:00	MSFT	Stock	25.9	26.01	25.89	26.01	3717316.0
2011-05-05 12:00:00	MSFT	Stock	26.01	26.08	26.0	26.06	2225275.0
2011-05-05 12:30:00	MSFT	Stock	26.065	26.065	25.88	25.933	1771539.0
2011-05-05 13:00:00	MSFT	Stock	25.935	26.03	25.93	26.02	1756570.0
2011-05-05 13:30:00	MSFT	Stock	26.01	26.02	25.91	25.99	2614885.0
2011-05-05 14:00:00	MSFT	Stock	25.985	26.015	25.925	25.98	1411865.0
2011-05-05 14:30:00	MSFT	Stock	25.97	26.02	25.89	25.89	2723191.0
2011-05-05 15:00:00	MSFT	Stock	25.89	25.9	25.68	25.76	8473384.0
2011-05-05 15:30:00	MSFT	Stock	25.77	25.82	25.7	25.79	8477743.0
2011-05-05 16:00:00	MSFT	Stock	25.79	26.04	25.78	25.81	2213481.0
2011-05-05 16:30:00	MSFT	Stock	25.82	25.86	25.755	25.83	21408.0

> showing 50 of 77,464 rows — these rows as CSV

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