PREVIEW / stock_30min / 2013-03-11

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-03-11.parquet
  size:    1.5 MB
  rows:    76,958
  symbols: 3,469

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-03-11 05:30:00	AAPL	Stock	15.3589	15.3589	15.3589	15.3589	2800.0
2013-03-11 06:00:00	AAPL	Stock	15.3589	15.3589	15.3393	15.3393	11200.0
2013-03-11 07:00:00	AAPL	Stock	15.3839	15.3839	15.3839	15.3839	5600.0
2013-03-11 07:30:00	AAPL	Stock	15.3618	15.3618	15.25	15.3214	258608.0
2013-03-11 08:00:00	AAPL	Stock	15.2786	15.3879	15.2786	15.3314	628264.0
2013-03-11 08:30:00	AAPL	Stock	15.3232	15.3361	15.3214	15.3361	831796.0
2013-03-11 09:00:00	AAPL	Stock	15.3361	15.3482	15.3036	15.3407	1390228.0
2013-03-11 09:30:00	AAPL	Stock	15.3414	15.3482	15.2264	15.2732	51820916.0
2013-03-11 10:00:00	AAPL	Stock	15.2689	15.2836	15.2151	15.2161	27691104.0
2013-03-11 10:30:00	AAPL	Stock	15.2182	15.2304	15.1836	15.205	27827744.0
2013-03-11 11:00:00	AAPL	Stock	15.2055	15.2618	15.1946	15.2336	22725052.0
2013-03-11 11:30:00	AAPL	Stock	15.235	15.2536	15.2086	15.2379	10972780.0
2013-03-11 12:00:00	AAPL	Stock	15.2418	15.3029	15.2396	15.2617	16407916.0
2013-03-11 12:30:00	AAPL	Stock	15.2593	15.2827	15.2579	15.275	6391392.0
2013-03-11 13:00:00	AAPL	Stock	15.275	15.2839	15.2375	15.2732	9842868.0
2013-03-11 13:30:00	AAPL	Stock	15.2736	15.3207	15.273	15.2986	14768208.0
2013-03-11 14:00:00	AAPL	Stock	15.2989	15.3107	15.275	15.2982	10736040.0
2013-03-11 14:30:00	AAPL	Stock	15.2979	15.6571	15.2868	15.5826	109146632.0
2013-03-11 15:00:00	AAPL	Stock	15.5804	15.6675	15.5486	15.5796	57429652.0
2013-03-11 15:30:00	AAPL	Stock	15.5821	15.6789	15.5625	15.6341	62652296.0
2013-03-11 16:00:00	AAPL	Stock	15.6334	15.6414	15.2537	15.6114	25287920.0
2013-03-11 16:30:00	AAPL	Stock	15.6093	15.6382	15.2314	15.6075	10436188.0
2013-03-11 17:00:00	AAPL	Stock	15.6171	15.6382	15.6107	15.6179	572180.0
2013-03-11 17:30:00	AAPL	Stock	15.6179	15.6179	15.6111	15.6161	168952.0
2013-03-11 18:00:00	AAPL	Stock	15.6164	15.6179	15.6129	15.6164	207032.0
2013-03-11 18:30:00	AAPL	Stock	15.6132	15.6182	15.6111	15.6182	141008.0
2013-03-11 19:00:00	AAPL	Stock	15.6182	15.6182	15.6018	15.6018	480928.0
2013-03-11 19:30:00	AAPL	Stock	15.6004	15.6175	15.5982	15.6175	315952.0
2013-03-11 08:00:00	MSFT	Stock	28.0	28.0	27.94	27.95	3565.0
2013-03-11 08:30:00	MSFT	Stock	27.93	27.94	27.9	27.9	7265.0
2013-03-11 09:00:00	MSFT	Stock	27.9	27.95	27.9	27.91	33499.0
2013-03-11 09:30:00	MSFT	Stock	27.94	27.97	27.77	27.848	4636333.0
2013-03-11 10:00:00	MSFT	Stock	27.846	27.87	27.78	27.81	2622396.0
2013-03-11 10:30:00	MSFT	Stock	27.8	27.82	27.67	27.71	2323088.0
2013-03-11 11:00:00	MSFT	Stock	27.715	27.82	27.71	27.8	1738771.0
2013-03-11 11:30:00	MSFT	Stock	27.805	27.84	27.79	27.82	1269499.0
2013-03-11 12:00:00	MSFT	Stock	27.83	27.87	27.82	27.86	1344217.0
2013-03-11 12:30:00	MSFT	Stock	27.87	27.87	27.76	27.78	1970300.0
2013-03-11 13:00:00	MSFT	Stock	27.779	27.91	27.77	27.87	2016275.0
2013-03-11 13:30:00	MSFT	Stock	27.876	27.9	27.85	27.85	1518240.0
2013-03-11 14:00:00	MSFT	Stock	27.86	27.86	27.82	27.83	1562137.0
2013-03-11 14:30:00	MSFT	Stock	27.82	27.83	27.77	27.785	2004480.0
2013-03-11 15:00:00	MSFT	Stock	27.79	27.81	27.77	27.78	2657847.0
2013-03-11 15:30:00	MSFT	Stock	27.785	27.88	27.76	27.88	5617633.0
2013-03-11 16:00:00	MSFT	Stock	27.87	28.04	27.783	27.88	2900344.0
2013-03-11 16:30:00	MSFT	Stock	27.86	27.88	27.806	27.87	1362610.0
2013-03-11 17:00:00	MSFT	Stock	27.87	27.87	27.87	27.87	7386.0
2013-03-11 17:30:00	MSFT	Stock	27.86	27.86	27.86	27.86	3403.0
2013-03-11 18:00:00	MSFT	Stock	27.85	27.85	27.85	27.85	300.0
2013-03-11 18:30:00	MSFT	Stock	27.87	27.87	27.86	27.86	3100.0

> showing 50 of 76,958 rows — these rows as CSV

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