PREVIEW / stock_30min / 2011-08-10

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-10.parquet
  size:    1.5 MB
  rows:    80,527
  symbols: 3,531

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-08-10 04:00:00	AAPL	Stock	13.4957	13.4986	13.4375	13.4375	30800.0
2011-08-10 04:30:00	AAPL	Stock	13.4464	13.4818	13.4443	13.4643	47600.0
2011-08-10 05:00:00	AAPL	Stock	13.4686	13.5214	13.4639	13.5214	119840.0
2011-08-10 05:30:00	AAPL	Stock	13.5211	13.5357	13.5	13.5143	11200.0
2011-08-10 06:00:00	AAPL	Stock	13.4936	13.5007	13.4818	13.4993	120484.0
2011-08-10 06:30:00	AAPL	Stock	13.4996	13.5	13.4554	13.4954	86212.0
2011-08-10 07:00:00	AAPL	Stock	13.4821	13.4911	13.34	13.3457	759780.0
2011-08-10 07:30:00	AAPL	Stock	13.3446	13.4004	13.3043	13.3493	816228.0
2011-08-10 08:00:00	AAPL	Stock	13.3607	13.3839	13.2768	13.28	3329760.0
2011-08-10 08:30:00	AAPL	Stock	13.2818	13.2857	13.2054	13.2107	4620728.0
2011-08-10 09:00:00	AAPL	Stock	13.2086	13.2811	13.1786	13.2589	5528516.0
2011-08-10 09:30:00	AAPL	Stock	13.2568	13.26	13.1036	13.1264	129839304.0
2011-08-10 10:00:00	AAPL	Stock	13.1239	13.17	13.0382	13.0879	76649328.0
2011-08-10 10:30:00	AAPL	Stock	13.0886	13.1714	13.0357	13.0914	61836880.0
2011-08-10 11:00:00	AAPL	Stock	13.0904	13.096	13.01	13.0246	63991564.0
2011-08-10 11:30:00	AAPL	Stock	13.025	13.1554	13.0136	13.1157	49884688.0
2011-08-10 12:00:00	AAPL	Stock	13.1154	13.2139	13.0954	13.1493	47766880.0
2011-08-10 12:30:00	AAPL	Stock	13.1546	13.1979	13.1079	13.1725	27034280.0
2011-08-10 13:00:00	AAPL	Stock	13.1679	13.2014	13.0971	13.1375	30760688.0
2011-08-10 13:30:00	AAPL	Stock	13.1439	13.2575	13.1071	13.2525	49584920.0
2011-08-10 14:00:00	AAPL	Stock	13.2525	13.3804	13.2264	13.32	80232880.0
2011-08-10 14:30:00	AAPL	Stock	13.3189	13.3693	13.2104	13.2104	58029216.0
2011-08-10 15:00:00	AAPL	Stock	13.2104	13.2511	13.1032	13.1193	59437672.0
2011-08-10 15:30:00	AAPL	Stock	13.1179	13.1632	12.9464	12.9643	90420372.0
2011-08-10 16:00:00	AAPL	Stock	12.9643	13.1701	12.9621	13.0111	29099672.0
2011-08-10 16:30:00	AAPL	Stock	13.0107	13.1517	12.9889	13.06	4277980.0
2011-08-10 17:00:00	AAPL	Stock	13.0536	13.0604	13.0132	13.0175	341348.0
2011-08-10 17:30:00	AAPL	Stock	13.0179	13.0411	13.0179	13.0361	124376.0
2011-08-10 18:00:00	AAPL	Stock	13.0304	13.0304	12.9889	13.0057	232316.0
2011-08-10 18:30:00	AAPL	Stock	13.0064	13.0175	13.0	13.015	107128.0
2011-08-10 19:00:00	AAPL	Stock	13.0136	13.0536	13.0136	13.0143	276528.0
2011-08-10 19:30:00	AAPL	Stock	13.0179	13.0679	13.0179	13.0571	180264.0
2011-08-10 04:00:00	MSFT	Stock	25.72	25.72	25.61	25.61	200.0
2011-08-10 05:00:00	MSFT	Stock	25.58	25.58	25.5	25.5	400.0
2011-08-10 06:30:00	MSFT	Stock	25.62	25.62	25.62	25.62	200.0
2011-08-10 07:00:00	MSFT	Stock	25.44	25.58	25.42	25.44	4030.0
2011-08-10 07:30:00	MSFT	Stock	25.42	25.42	25.4	25.4	1963.0
2011-08-10 08:00:00	MSFT	Stock	25.4	25.58	25.27	25.36	14398.0
2011-08-10 08:30:00	MSFT	Stock	25.3	25.35	25.16	25.22	32176.0
2011-08-10 09:00:00	MSFT	Stock	25.2	25.2	24.88	24.95	145595.0
2011-08-10 09:30:00	MSFT	Stock	24.95	24.96	24.4	24.4	12723112.0
2011-08-10 10:00:00	MSFT	Stock	24.4	24.58	24.17	24.34	12696720.0
2011-08-10 10:30:00	MSFT	Stock	24.35	24.63	24.18	24.31	9690524.0
2011-08-10 11:00:00	MSFT	Stock	24.31	24.35	24.1	24.17	7152400.0
2011-08-10 11:30:00	MSFT	Stock	24.17	24.62	24.13	24.579	9174828.0
2011-08-10 12:00:00	MSFT	Stock	24.57	24.8	24.52	24.55	9237001.0
2011-08-10 12:30:00	MSFT	Stock	24.55	24.86	24.47	24.855	6004527.0
2011-08-10 13:00:00	MSFT	Stock	24.85	24.98	24.65	24.77	6119083.0
2011-08-10 13:30:00	MSFT	Stock	24.77	25.05	24.72	25.05	4794901.0
2011-08-10 14:00:00	MSFT	Stock	25.05	25.09	24.89	24.91	5752949.0

> showing 50 of 80,527 rows — these rows as CSV

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