PREVIEW / stock_30min / 2011-05-25

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-05-25.parquet
  size:    1.4 MB
  rows:    76,167
  symbols: 3,536

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-25 04:00:00	AAPL	Stock	11.8164	11.8164	11.8164	11.8164	2800.0
2011-05-25 04:30:00	AAPL	Stock	11.8343	11.8368	11.8343	11.8368	5600.0
2011-05-25 05:00:00	AAPL	Stock	11.8571	11.8632	11.8571	11.8632	8400.0
2011-05-25 05:30:00	AAPL	Stock	11.8579	11.8579	11.8579	11.8579	2800.0
2011-05-25 06:00:00	AAPL	Stock	11.8579	11.8579	11.8571	11.8571	11200.0
2011-05-25 06:30:00	AAPL	Stock	11.8818	11.8857	11.8689	11.8821	58520.0
2011-05-25 07:00:00	AAPL	Stock	11.8689	11.8779	11.8571	11.8779	25200.0
2011-05-25 07:30:00	AAPL	Stock	11.8775	11.8821	11.8646	11.875	85008.0
2011-05-25 08:00:00	AAPL	Stock	11.8754	11.88	11.8661	11.8768	139412.0
2011-05-25 08:30:00	AAPL	Stock	11.875	11.9036	11.8714	11.8982	721392.0
2011-05-25 09:00:00	AAPL	Stock	11.9011	11.9118	11.8839	11.9104	1673112.0
2011-05-25 09:30:00	AAPL	Stock	11.9107	11.9816	11.8875	11.9625	49502068.0
2011-05-25 10:00:00	AAPL	Stock	11.9643	11.9746	11.925	11.9736	28703836.0
2011-05-25 10:30:00	AAPL	Stock	11.9736	12.0	11.9571	11.9632	29100456.0
2011-05-25 11:00:00	AAPL	Stock	11.9614	11.9904	11.9546	11.975	18077136.0
2011-05-25 11:30:00	AAPL	Stock	11.9725	12.02	11.9707	12.0029	20763792.0
2011-05-25 12:00:00	AAPL	Stock	12.0029	12.0154	11.9932	12.0093	9262820.0
2011-05-25 12:30:00	AAPL	Stock	12.0079	12.0186	12.0	12.0185	7548660.0
2011-05-25 13:00:00	AAPL	Stock	12.0175	12.0211	11.9868	11.9979	10355912.0
2011-05-25 13:30:00	AAPL	Stock	11.9984	12.0136	11.9861	12.0014	9927064.0
2011-05-25 14:00:00	AAPL	Stock	12.0025	12.046	11.9964	12.0454	13234480.0
2011-05-25 14:30:00	AAPL	Stock	12.0457	12.0711	12.0262	12.0689	17644228.0
2011-05-25 15:00:00	AAPL	Stock	12.0671	12.0914	12.0568	12.0789	25588976.0
2011-05-25 15:30:00	AAPL	Stock	12.0779	12.0789	12.0196	12.0196	33964196.0
2011-05-25 16:00:00	AAPL	Stock	12.02	12.0557	11.9995	12.0179	7482356.0
2011-05-25 16:30:00	AAPL	Stock	12.0154	12.0784	11.9451	12.0246	359156.0
2011-05-25 17:00:00	AAPL	Stock	12.0061	12.0271	12.0061	12.0143	135016.0
2011-05-25 17:30:00	AAPL	Stock	12.02	12.0271	12.02	12.02	161392.0
2011-05-25 18:00:00	AAPL	Stock	12.02	12.035	12.02	12.0346	102872.0
2011-05-25 18:30:00	AAPL	Stock	12.0346	12.0371	12.0321	12.0371	59248.0
2011-05-25 19:00:00	AAPL	Stock	12.0357	12.04	12.0343	12.0371	81480.0
2011-05-25 19:30:00	AAPL	Stock	12.0375	12.0375	12.0357	12.0375	61488.0
2011-05-25 04:00:00	MSFT	Stock	24.07	24.07	24.0	24.0	1282.0
2011-05-25 06:00:00	MSFT	Stock	24.09	24.09	24.09	24.09	500.0
2011-05-25 08:00:00	MSFT	Stock	24.12	24.17	24.12	24.17	2400.0
2011-05-25 08:30:00	MSFT	Stock	24.13	24.13	24.11	24.12	1400.0
2011-05-25 09:00:00	MSFT	Stock	24.11	24.17	24.09	24.15	12465.0
2011-05-25 09:30:00	MSFT	Stock	24.15	24.3	24.15	24.22	4194735.0
2011-05-25 10:00:00	MSFT	Stock	24.215	24.26	24.2	24.25	2923108.0
2011-05-25 10:30:00	MSFT	Stock	24.25	24.31	24.21	24.217	2626572.0
2011-05-25 11:00:00	MSFT	Stock	24.215	24.26	24.21	24.241	1980471.0
2011-05-25 11:30:00	MSFT	Stock	24.25	24.3	24.24	24.25	1621574.0
2011-05-25 12:00:00	MSFT	Stock	24.245	24.29	24.24	24.26	2213995.0
2011-05-25 12:30:00	MSFT	Stock	24.265	24.27	24.22	24.235	1894936.0
2011-05-25 13:00:00	MSFT	Stock	24.235	24.25	24.21	24.23	1773715.0
2011-05-25 13:30:00	MSFT	Stock	24.227	24.24	24.21	24.21	1180102.0
2011-05-25 14:00:00	MSFT	Stock	24.21	24.25	24.17	24.241	2300431.0
2011-05-25 14:30:00	MSFT	Stock	24.25	24.25	24.22	24.24	1114436.0
2011-05-25 15:00:00	MSFT	Stock	24.235	24.31	24.23	24.27	2617554.0
2011-05-25 15:30:00	MSFT	Stock	24.27	24.28	24.18	24.2	4915986.0

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

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