PREVIEW / stock_30min / 2012-01-06

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-01-06.parquet
  size:    1.4 MB
  rows:    74,886
  symbols: 3,529

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-01-06 04:00:00	AAPL	Stock	14.9304	14.9304	14.9304	14.9304	8400.0
2012-01-06 07:00:00	AAPL	Stock	14.9532	14.9607	14.9425	14.9507	58520.0
2012-01-06 07:30:00	AAPL	Stock	14.9529	14.9596	14.9432	14.9561	62636.0
2012-01-06 08:00:00	AAPL	Stock	14.9568	14.9596	14.9379	14.9436	628740.0
2012-01-06 08:30:00	AAPL	Stock	14.9554	14.9911	14.9432	14.9718	2942072.0
2012-01-06 09:00:00	AAPL	Stock	14.9661	14.9975	14.9589	14.9918	3138016.0
2012-01-06 09:30:00	AAPL	Stock	14.9918	15.0525	14.9721	15.0021	78984500.0
2012-01-06 10:00:00	AAPL	Stock	15.0029	15.0236	14.9879	15.0057	25339020.0
2012-01-06 10:30:00	AAPL	Stock	15.0057	15.0457	15.0054	15.0157	22440376.0
2012-01-06 11:00:00	AAPL	Stock	15.0159	15.0407	15.0146	15.0291	13624688.0
2012-01-06 11:30:00	AAPL	Stock	15.0311	15.0439	15.0221	15.0239	14416920.0
2012-01-06 12:00:00	AAPL	Stock	15.0232	15.0286	15.0107	15.0279	10938536.0
2012-01-06 12:30:00	AAPL	Stock	15.0261	15.0387	15.02	15.0271	9404220.0
2012-01-06 13:00:00	AAPL	Stock	15.0271	15.0332	15.0193	15.0261	6696788.0
2012-01-06 13:30:00	AAPL	Stock	15.0271	15.0639	15.0214	15.0607	14995512.0
2012-01-06 14:00:00	AAPL	Stock	15.0618	15.0893	15.0457	15.0829	25293604.0
2012-01-06 14:30:00	AAPL	Stock	15.0829	15.0882	15.0629	15.0667	15462076.0
2012-01-06 15:00:00	AAPL	Stock	15.0664	15.0764	15.0464	15.06	15984892.0
2012-01-06 15:30:00	AAPL	Stock	15.06	15.0982	15.0536	15.0875	46907840.0
2012-01-06 16:00:00	AAPL	Stock	15.0871	15.0893	15.0237	15.0854	7644532.0
2012-01-06 16:30:00	AAPL	Stock	15.0829	15.0932	15.0545	15.0857	379624.0
2012-01-06 17:00:00	AAPL	Stock	15.085	15.0861	15.0836	15.0839	64960.0
2012-01-06 17:30:00	AAPL	Stock	15.0814	15.085	15.0814	15.0839	58100.0
2012-01-06 18:00:00	AAPL	Stock	15.0818	15.0857	15.0811	15.0821	62440.0
2012-01-06 18:30:00	AAPL	Stock	15.0832	15.0832	15.0832	15.0832	25844.0
2012-01-06 19:00:00	AAPL	Stock	15.0821	15.0836	15.0814	15.0814	20776.0
2012-01-06 19:30:00	AAPL	Stock	15.0836	15.0839	15.0793	15.0814	59948.0
2012-01-06 06:30:00	MSFT	Stock	27.7	27.7	27.7	27.7	100.0
2012-01-06 07:30:00	MSFT	Stock	27.68	27.68	27.68	27.68	100.0
2012-01-06 08:00:00	MSFT	Stock	27.65	27.67	27.65	27.67	1072.0
2012-01-06 08:30:00	MSFT	Stock	27.68	27.78	27.68	27.68	27305.0
2012-01-06 09:00:00	MSFT	Stock	27.68	27.68	27.54	27.54	53182.0
2012-01-06 09:30:00	MSFT	Stock	27.53	27.68	27.525	27.68	7831820.0
2012-01-06 10:00:00	MSFT	Stock	27.67	27.765	27.64	27.73	3850536.0
2012-01-06 10:30:00	MSFT	Stock	27.74	27.775	27.73	27.758	3186496.0
2012-01-06 11:00:00	MSFT	Stock	27.76	27.86	27.745	27.83	5079137.0
2012-01-06 11:30:00	MSFT	Stock	27.825	28.0	27.82	27.97	10164973.0
2012-01-06 12:00:00	MSFT	Stock	27.975	27.99	27.94	27.985	4047047.0
2012-01-06 12:30:00	MSFT	Stock	27.985	28.02	27.97	28.0	10162457.0
2012-01-06 13:00:00	MSFT	Stock	28.0	28.01	27.92	27.98	5760913.0
2012-01-06 13:30:00	MSFT	Stock	27.99	28.0	27.88	27.976	5423262.0
2012-01-06 14:00:00	MSFT	Stock	27.97	28.01	27.95	28.0	5327411.0
2012-01-06 14:30:00	MSFT	Stock	27.995	28.1	27.99	28.1	7778898.0
2012-01-06 15:00:00	MSFT	Stock	28.1	28.15	28.02	28.142	7192737.0
2012-01-06 15:30:00	MSFT	Stock	28.142	28.19	28.06	28.12	15732678.0
2012-01-06 16:00:00	MSFT	Stock	28.12	28.16	27.68	28.14	5686797.0
2012-01-06 16:30:00	MSFT	Stock	28.14	28.188	27.58	28.11	99633.0
2012-01-06 17:00:00	MSFT	Stock	28.11	28.11	28.11	28.11	74733.0
2012-01-06 17:30:00	MSFT	Stock	28.11	28.12	28.1	28.1	79049.0
2012-01-06 18:00:00	MSFT	Stock	28.11	28.11	28.1	28.1	36202.0

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

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