PREVIEW / stock_30min / 2013-02-19

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-02-19.parquet
  size:    1.5 MB
  rows:    77,863
  symbols: 3,487

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
2013-02-19 04:00:00	AAPL	Stock	16.4589	16.4589	16.4589	16.4589	5600.0
2013-02-19 04:30:00	AAPL	Stock	16.5089	16.5089	16.5089	16.5089	11200.0
2013-02-19 05:00:00	AAPL	Stock	16.5071	16.5179	16.5	16.5	29400.0
2013-02-19 05:30:00	AAPL	Stock	16.5	16.5	16.5	16.5	13020.0
2013-02-19 06:00:00	AAPL	Stock	16.5071	16.5354	16.5071	16.5354	28140.0
2013-02-19 06:30:00	AAPL	Stock	16.5089	16.5111	16.5089	16.5089	11200.0
2013-02-19 07:00:00	AAPL	Stock	16.5089	16.5464	16.5029	16.53	190036.0
2013-02-19 07:30:00	AAPL	Stock	16.5304	16.5625	16.5179	16.5532	407512.0
2013-02-19 08:00:00	AAPL	Stock	16.5493	16.5625	16.4832	16.4968	781788.0
2013-02-19 08:30:00	AAPL	Stock	16.5	16.5354	16.4946	16.5339	1016652.0
2013-02-19 09:00:00	AAPL	Stock	16.5186	16.525	16.4375	16.4675	1110312.0
2013-02-19 09:30:00	AAPL	Stock	16.4679	16.5261	16.3482	16.3707	68870508.0
2013-02-19 10:00:00	AAPL	Stock	16.3696	16.3768	16.2318	16.3046	55807836.0
2013-02-19 10:30:00	AAPL	Stock	16.3	16.306	16.2089	16.239	33261256.0
2013-02-19 11:00:00	AAPL	Stock	16.2364	16.2871	16.2089	16.2657	22363600.0
2013-02-19 11:30:00	AAPL	Stock	16.2661	16.3486	16.2418	16.3366	27375852.0
2013-02-19 12:00:00	AAPL	Stock	16.3412	16.3743	16.2896	16.3411	33717404.0
2013-02-19 12:30:00	AAPL	Stock	16.3411	16.3821	16.2957	16.3768	19972596.0
2013-02-19 13:00:00	AAPL	Stock	16.3789	16.4139	16.3477	16.3707	19450676.0
2013-02-19 13:30:00	AAPL	Stock	16.375	16.4496	16.3151	16.3229	27305320.0
2013-02-19 14:00:00	AAPL	Stock	16.3271	16.3968	16.3179	16.3839	15333500.0
2013-02-19 14:30:00	AAPL	Stock	16.3854	16.4764	16.3854	16.4157	31330236.0
2013-02-19 15:00:00	AAPL	Stock	16.4161	16.4368	16.3757	16.3832	15979544.0
2013-02-19 15:30:00	AAPL	Stock	16.3864	16.4314	16.3482	16.4271	27980288.0
2013-02-19 16:00:00	AAPL	Stock	16.427	16.4407	16.2373	16.4407	24178924.0
2013-02-19 16:30:00	AAPL	Stock	16.4389	16.4536	16.2606	16.4282	454272.0
2013-02-19 17:00:00	AAPL	Stock	16.3117	16.4396	16.3117	16.4389	150808.0
2013-02-19 17:30:00	AAPL	Stock	16.4321	16.4464	16.4286	16.4454	136192.0
2013-02-19 18:00:00	AAPL	Stock	16.4375	16.4375	16.4339	16.4339	21728.0
2013-02-19 18:30:00	AAPL	Stock	16.44	16.4464	16.4339	16.4446	124964.0
2013-02-19 19:00:00	AAPL	Stock	16.4361	16.4518	16.4361	16.4464	126196.0
2013-02-19 19:30:00	AAPL	Stock	16.4464	16.45	16.4375	16.4411	87780.0
2013-02-19 07:00:00	MSFT	Stock	27.92	27.92	27.9	27.9	600.0
2013-02-19 07:30:00	MSFT	Stock	27.9	27.9	27.85	27.85	350.0
2013-02-19 08:00:00	MSFT	Stock	27.92	27.93	27.87	27.89	8300.0
2013-02-19 08:30:00	MSFT	Stock	27.89	27.89	27.86	27.86	15700.0
2013-02-19 09:00:00	MSFT	Stock	27.86	27.95	27.81	27.89	128761.0
2013-02-19 09:30:00	MSFT	Stock	27.93	27.99	27.8	27.95	5483268.0
2013-02-19 10:00:00	MSFT	Stock	27.95	28.05	27.95	28.03	3249260.0
2013-02-19 10:30:00	MSFT	Stock	28.04	28.09	27.975	27.99	3314001.0
2013-02-19 11:00:00	MSFT	Stock	27.99	28.02	27.96	28.005	2055434.0
2013-02-19 11:30:00	MSFT	Stock	28.01	28.01	27.98	28.0	1147712.0
2013-02-19 12:00:00	MSFT	Stock	28.0	28.0	27.97	27.98	1622728.0
2013-02-19 12:30:00	MSFT	Stock	27.98	27.99	27.965	27.98	960447.0
2013-02-19 13:00:00	MSFT	Stock	27.987	28.02	27.98	27.99	1137699.0
2013-02-19 13:30:00	MSFT	Stock	27.987	28.0	27.92	27.95	1673714.0
2013-02-19 14:00:00	MSFT	Stock	27.95	27.97	27.93	27.94	1484188.0
2013-02-19 14:30:00	MSFT	Stock	27.945	27.98	27.94	27.97	1321685.0
2013-02-19 15:00:00	MSFT	Stock	27.965	28.02	27.95	28.001	2254018.0
2013-02-19 15:30:00	MSFT	Stock	28.005	28.055	27.99	28.05	4823864.0

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

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