PREVIEW / stock_30min / 2011-05-06

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-05-06.parquet
  size:    1.4 MB
  rows:    74,757
  symbols: 3,549

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-06 04:00:00	AAPL	Stock	12.3829	12.3829	12.375	12.375	41888.0
2011-05-06 05:00:00	AAPL	Stock	12.4179	12.4179	12.4179	12.4179	2800.0
2011-05-06 05:30:00	AAPL	Stock	12.4357	12.4457	12.4357	12.4457	5600.0
2011-05-06 07:00:00	AAPL	Stock	12.4175	12.4286	12.4125	12.4286	25312.0
2011-05-06 07:30:00	AAPL	Stock	12.4125	12.4357	12.4125	12.4286	57764.0
2011-05-06 08:00:00	AAPL	Stock	12.425	12.4271	12.4125	12.4232	246820.0
2011-05-06 08:30:00	AAPL	Stock	12.4196	12.5	12.4196	12.4911	3868536.0
2011-05-06 09:00:00	AAPL	Stock	12.4914	12.5139	12.4821	12.4904	2001636.0
2011-05-06 09:30:00	AAPL	Stock	12.4889	12.5	12.4336	12.4575	47669972.0
2011-05-06 10:00:00	AAPL	Stock	12.4575	12.4789	12.4468	12.4646	21237412.0
2011-05-06 10:30:00	AAPL	Stock	12.4675	12.4789	12.4554	12.4757	14837620.0
2011-05-06 11:00:00	AAPL	Stock	12.4754	12.4925	12.4732	12.4861	20052508.0
2011-05-06 11:30:00	AAPL	Stock	12.4843	12.4882	12.4579	12.4743	14799764.0
2011-05-06 12:00:00	AAPL	Stock	12.4729	12.4804	12.4418	12.4471	17950072.0
2011-05-06 12:30:00	AAPL	Stock	12.4489	12.4671	12.4261	12.435	17158904.0
2011-05-06 13:00:00	AAPL	Stock	12.4371	12.4446	12.4	12.4143	19740336.0
2011-05-06 13:30:00	AAPL	Stock	12.4142	12.4271	12.3979	12.4007	13532848.0
2011-05-06 14:00:00	AAPL	Stock	12.4032	12.4318	12.3957	12.4073	11366796.0
2011-05-06 14:30:00	AAPL	Stock	12.4082	12.4086	12.3646	12.375	24273088.0
2011-05-06 15:00:00	AAPL	Stock	12.375	12.4104	12.3711	12.3875	16748564.0
2011-05-06 15:30:00	AAPL	Stock	12.3879	12.4046	12.375	12.3768	25213944.0
2011-05-06 16:00:00	AAPL	Stock	12.3807	12.4394	12.3564	12.3729	7169456.0
2011-05-06 16:30:00	AAPL	Stock	12.3743	12.375	12.3696	12.3711	281036.0
2011-05-06 17:00:00	AAPL	Stock	12.3707	12.3807	12.3707	12.3757	217784.0
2011-05-06 17:30:00	AAPL	Stock	12.3786	12.3793	12.3736	12.3782	77084.0
2011-05-06 18:00:00	AAPL	Stock	12.3768	12.3807	12.3757	12.3786	84952.0
2011-05-06 18:30:00	AAPL	Stock	12.3793	12.3857	12.3789	12.3839	100800.0
2011-05-06 19:00:00	AAPL	Stock	12.3839	12.3839	12.3836	12.3839	33376.0
2011-05-06 19:30:00	AAPL	Stock	12.3839	12.3893	12.3804	12.3882	104944.0
2011-05-06 07:30:00	MSFT	Stock	25.83	25.83	25.83	25.83	200.0
2011-05-06 08:00:00	MSFT	Stock	25.85	25.89	25.83	25.85	1575.0
2011-05-06 08:30:00	MSFT	Stock	25.91	26.01	25.91	26.0	91388.0
2011-05-06 09:00:00	MSFT	Stock	26.01	26.13	25.98	26.1	65754.0
2011-05-06 09:30:00	MSFT	Stock	26.08	26.2	26.0	26.12	6755330.0
2011-05-06 10:00:00	MSFT	Stock	26.12	26.13	25.95	26.03	5195893.0
2011-05-06 10:30:00	MSFT	Stock	26.025	26.09	25.98	26.06	2570934.0
2011-05-06 11:00:00	MSFT	Stock	26.05	26.19	26.04	26.175	3212178.0
2011-05-06 11:30:00	MSFT	Stock	26.171	26.22	26.11	26.19	4239865.0
2011-05-06 12:00:00	MSFT	Stock	26.19	26.2	26.11	26.12	5122794.0
2011-05-06 12:30:00	MSFT	Stock	26.12	26.15	25.98	26.07	4029999.0
2011-05-06 13:00:00	MSFT	Stock	26.08	26.085	25.86	25.908	3323796.0
2011-05-06 13:30:00	MSFT	Stock	25.9	25.93	25.841	25.849	2815993.0
2011-05-06 14:00:00	MSFT	Stock	25.846	25.92	25.82	25.851	2561422.0
2011-05-06 14:30:00	MSFT	Stock	25.855	25.86	25.75	25.84	3675158.0
2011-05-06 15:00:00	MSFT	Stock	25.83	25.92	25.82	25.87	3681811.0
2011-05-06 15:30:00	MSFT	Stock	25.88	25.95	25.85	25.87	6502901.0
2011-05-06 16:00:00	MSFT	Stock	25.87	26.018	25.81	25.9	1829686.0
2011-05-06 16:30:00	MSFT	Stock	25.83	25.83	25.83	25.83	2000.0
2011-05-06 17:00:00	MSFT	Stock	25.87	25.87	25.87	25.87	49409.0
2011-05-06 17:30:00	MSFT	Stock	25.87	25.87	25.87	25.87	110.0

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

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