PREVIEW / stock_30min / 2011-01-21

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-01-21.parquet
  size:    1.5 MB
  rows:    78,161
  symbols: 3,526

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-01-21 04:00:00	AAPL	Stock	11.9118	11.9118	11.9118	11.9118	5600.0
2011-01-21 04:30:00	AAPL	Stock	11.9064	11.9064	11.9064	11.9064	5600.0
2011-01-21 05:00:00	AAPL	Stock	11.9064	11.9536	11.9064	11.9536	14000.0
2011-01-21 05:30:00	AAPL	Stock	11.9425	11.9429	11.9425	11.9429	8400.0
2011-01-21 06:00:00	AAPL	Stock	11.9429	11.9536	11.9429	11.9464	22400.0
2011-01-21 06:30:00	AAPL	Stock	11.9464	11.9536	11.9464	11.9536	12600.0
2011-01-21 07:00:00	AAPL	Stock	11.9507	11.9507	11.9389	11.9407	193900.0
2011-01-21 07:30:00	AAPL	Stock	11.9354	11.9464	11.9286	11.9464	344064.0
2011-01-21 08:00:00	AAPL	Stock	11.9429	11.9993	11.9329	11.9814	2607528.0
2011-01-21 08:30:00	AAPL	Stock	11.9811	11.9964	11.9629	11.9643	1940904.0
2011-01-21 09:00:00	AAPL	Stock	11.9643	11.9711	11.9054	11.9154	3998204.0
2011-01-21 09:30:00	AAPL	Stock	11.915	11.96	11.8954	11.9246	125688836.0
2011-01-21 10:00:00	AAPL	Stock	11.9236	11.94	11.8344	11.8511	66017448.0
2011-01-21 10:30:00	AAPL	Stock	11.8496	11.8571	11.815	11.8282	49670292.0
2011-01-21 11:00:00	AAPL	Stock	11.8282	11.8493	11.7918	11.8139	43121260.0
2011-01-21 11:30:00	AAPL	Stock	11.8126	11.8304	11.7643	11.7982	45769220.0
2011-01-21 12:00:00	AAPL	Stock	11.7986	11.8153	11.7725	11.795	29038716.0
2011-01-21 12:30:00	AAPL	Stock	11.7946	11.7982	11.7093	11.7321	57016064.0
2011-01-21 13:00:00	AAPL	Stock	11.7321	11.7354	11.69	11.7075	45187240.0
2011-01-21 13:30:00	AAPL	Stock	11.7082	11.7368	11.7079	11.7316	33045124.0
2011-01-21 14:00:00	AAPL	Stock	11.7318	11.7675	11.7186	11.7629	42466452.0
2011-01-21 14:30:00	AAPL	Stock	11.7636	11.7982	11.76	11.7786	44208108.0
2011-01-21 15:00:00	AAPL	Stock	11.7796	11.7829	11.7186	11.725	42067760.0
2011-01-21 15:30:00	AAPL	Stock	11.725	11.73	11.6654	11.6686	98787696.0
2011-01-21 16:00:00	AAPL	Stock	11.6664	11.7989	11.6557	11.6618	11116196.0
2011-01-21 16:30:00	AAPL	Stock	11.9646	11.9646	11.6579	11.665	716520.0
2011-01-21 17:00:00	AAPL	Stock	11.6654	11.6671	11.6571	11.6643	1090376.0
2011-01-21 17:30:00	AAPL	Stock	11.6643	11.6693	11.6611	11.6664	249200.0
2011-01-21 18:00:00	AAPL	Stock	11.6668	11.6686	11.6571	11.6632	254576.0
2011-01-21 18:30:00	AAPL	Stock	11.6639	11.6639	11.6525	11.6525	384552.0
2011-01-21 19:00:00	AAPL	Stock	11.6521	11.6589	11.6507	11.6571	82600.0
2011-01-21 19:30:00	AAPL	Stock	11.6571	11.6589	11.65	11.6579	202412.0
2011-01-21 06:30:00	MSFT	Stock	28.35	28.35	28.35	28.35	1800.0
2011-01-21 07:00:00	MSFT	Stock	28.33	28.33	28.33	28.33	100.0
2011-01-21 08:00:00	MSFT	Stock	28.4	28.41	28.33	28.41	9584.0
2011-01-21 09:00:00	MSFT	Stock	28.43	28.54	28.4	28.4	310453.0
2011-01-21 09:30:00	MSFT	Stock	28.4	28.43	28.16	28.25	11578343.0
2011-01-21 10:00:00	MSFT	Stock	28.25	28.26	28.13	28.13	4561759.0
2011-01-21 10:30:00	MSFT	Stock	28.13	28.2	28.11	28.14	3409987.0
2011-01-21 11:00:00	MSFT	Stock	28.14	28.2	28.08	28.192	3874081.0
2011-01-21 11:30:00	MSFT	Stock	28.2	28.25	28.13	28.16	3015647.0
2011-01-21 12:00:00	MSFT	Stock	28.16	28.24	28.15	28.222	1746274.0
2011-01-21 12:30:00	MSFT	Stock	28.225	28.25	28.1	28.1	3804696.0
2011-01-21 13:00:00	MSFT	Stock	28.1	28.11	28.08	28.105	2331727.0
2011-01-21 13:30:00	MSFT	Stock	28.105	28.16	28.09	28.1	2451302.0
2011-01-21 14:00:00	MSFT	Stock	28.1	28.12	28.06	28.09	2431923.0
2011-01-21 14:30:00	MSFT	Stock	28.09	28.135	28.08	28.093	3578276.0
2011-01-21 15:00:00	MSFT	Stock	28.095	28.13	28.08	28.11	3117969.0
2011-01-21 15:30:00	MSFT	Stock	28.11	28.11	28.02	28.03	6858240.0
2011-01-21 16:00:00	MSFT	Stock	28.025	28.243	27.96	28.0	2351291.0

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

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