PREVIEW / stock_30min / 2014-03-12

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-03-12.parquet
  size:    1.6 MB
  rows:    81,676
  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
2014-03-12 04:00:00	AAPL	Stock	19.1446	19.1446	19.1446	19.1446	2800.0
2014-03-12 06:00:00	AAPL	Stock	19.1082	19.1082	19.1043	19.1043	8400.0
2014-03-12 06:30:00	AAPL	Stock	19.0893	19.0893	19.0614	19.0614	22400.0
2014-03-12 07:00:00	AAPL	Stock	19.0893	19.1293	19.0893	19.1143	72800.0
2014-03-12 07:30:00	AAPL	Stock	19.1179	19.12	19.1071	19.1071	86800.0
2014-03-12 08:00:00	AAPL	Stock	19.0896	19.125	19.0893	19.1071	121744.0
2014-03-12 08:30:00	AAPL	Stock	19.1057	19.1107	19.0646	19.0646	234500.0
2014-03-12 09:00:00	AAPL	Stock	19.0714	19.0996	19.0704	19.0886	1038352.0
2014-03-12 09:30:00	AAPL	Stock	19.0904	19.1389	19.0	19.017	28528080.0
2014-03-12 10:00:00	AAPL	Stock	19.0196	19.0711	19.0025	19.0204	15879304.0
2014-03-12 10:30:00	AAPL	Stock	19.0186	19.1311	19.0096	19.1311	18054708.0
2014-03-12 11:00:00	AAPL	Stock	19.1311	19.1911	19.1089	19.1736	17661588.0
2014-03-12 11:30:00	AAPL	Stock	19.1729	19.1818	19.1314	19.1346	12488168.0
2014-03-12 12:00:00	AAPL	Stock	19.1346	19.1446	19.1057	19.1346	7080528.0
2014-03-12 12:30:00	AAPL	Stock	19.1329	19.1679	19.1125	19.1593	6208076.0
2014-03-12 13:00:00	AAPL	Stock	19.1639	19.165	19.1243	19.1339	6379044.0
2014-03-12 13:30:00	AAPL	Stock	19.1332	19.1636	19.1275	19.135	6338108.0
2014-03-12 14:00:00	AAPL	Stock	19.1364	19.1457	19.0896	19.1196	7389984.0
2014-03-12 14:30:00	AAPL	Stock	19.1254	19.1257	19.0904	19.0904	5254284.0
2014-03-12 15:00:00	AAPL	Stock	19.09	19.1368	19.085	19.1071	7573692.0
2014-03-12 15:30:00	AAPL	Stock	19.1082	19.1668	19.0896	19.1643	19606160.0
2014-03-12 16:00:00	AAPL	Stock	19.1643	19.1732	19.1093	19.1646	5409208.0
2014-03-12 16:30:00	AAPL	Stock	19.1618	19.1693	19.1618	19.1693	11312.0
2014-03-12 17:00:00	AAPL	Stock	19.1646	19.1729	19.1646	19.1729	76496.0
2014-03-12 17:30:00	AAPL	Stock	19.1636	19.1732	19.1636	19.1646	1148644.0
2014-03-12 18:00:00	AAPL	Stock	19.1732	19.175	19.1732	19.1732	37240.0
2014-03-12 18:30:00	AAPL	Stock	19.1725	19.1786	19.1679	19.1786	173348.0
2014-03-12 19:00:00	AAPL	Stock	19.1786	19.1786	19.1786	19.1786	5600.0
2014-03-12 19:30:00	AAPL	Stock	19.1786	19.1857	19.1782	19.1857	71260.0
2014-03-12 07:00:00	MSFT	Stock	37.8	37.8	37.8	37.8	300.0
2014-03-12 07:30:00	MSFT	Stock	37.81	37.81	37.81	37.81	715.0
2014-03-12 08:30:00	MSFT	Stock	37.8	37.82	37.8	37.82	1100.0
2014-03-12 09:00:00	MSFT	Stock	37.84	37.87	37.44	37.86	16551.0
2014-03-12 09:30:00	MSFT	Stock	37.8	38.0	37.79	37.9	3473535.0
2014-03-12 10:00:00	MSFT	Stock	37.9	38.15	37.87	38.1	1881353.0
2014-03-12 10:30:00	MSFT	Stock	38.105	38.21	38.06	38.17	1791450.0
2014-03-12 11:00:00	MSFT	Stock	38.17	38.34	38.164	38.33	1619907.0
2014-03-12 11:30:00	MSFT	Stock	38.33	38.35	38.21	38.215	1676300.0
2014-03-12 12:00:00	MSFT	Stock	38.21	38.25	38.12	38.123	1393801.0
2014-03-12 12:30:00	MSFT	Stock	38.125	38.31	38.09	38.31	1343030.0
2014-03-12 13:00:00	MSFT	Stock	38.31	38.31	38.14	38.17	766084.0
2014-03-12 13:30:00	MSFT	Stock	38.16	38.34	38.16	38.323	5474990.0
2014-03-12 14:00:00	MSFT	Stock	38.32	38.43	38.3	38.383	1745858.0
2014-03-12 14:30:00	MSFT	Stock	38.38	38.4	38.31	38.31	1189218.0
2014-03-12 15:00:00	MSFT	Stock	38.315	38.34	38.22	38.26	1584156.0
2014-03-12 15:30:00	MSFT	Stock	38.25	38.315	38.2	38.26	3147949.0
2014-03-12 16:00:00	MSFT	Stock	38.26	38.32	37.96	38.27	1678301.0
2014-03-12 16:30:00	MSFT	Stock	38.21	38.21	38.21	38.21	395.0
2014-03-12 17:00:00	MSFT	Stock	38.27	38.28	38.27	38.28	20253.0
2014-03-12 18:00:00	MSFT	Stock	38.29	38.29	38.29	38.29	150.0

> showing 50 of 81,676 rows — these rows as CSV

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