PREVIEW / stock_30min / 2011-05-26

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-05-26.parquet
  size:    1.4 MB
  rows:    73,688
  symbols: 3,534

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-26 04:30:00	AAPL	Stock	12.0357	12.0357	12.0357	12.0357	2800.0
2011-05-26 05:00:00	AAPL	Stock	12.0357	12.0357	12.0357	12.0357	5600.0
2011-05-26 05:30:00	AAPL	Stock	12.0357	12.0357	12.0357	12.0357	2800.0
2011-05-26 06:00:00	AAPL	Stock	12.0607	12.0607	12.0461	12.0461	5600.0
2011-05-26 07:00:00	AAPL	Stock	12.0532	12.0532	12.0393	12.0393	20720.0
2011-05-26 07:30:00	AAPL	Stock	12.0393	12.04	12.0357	12.0357	15120.0
2011-05-26 08:00:00	AAPL	Stock	12.0432	12.0571	12.0357	12.0479	421204.0
2011-05-26 08:30:00	AAPL	Stock	12.0479	12.0479	11.9911	12.0107	689612.0
2011-05-26 09:00:00	AAPL	Stock	12.0011	12.0143	11.9929	11.9929	217896.0
2011-05-26 09:30:00	AAPL	Stock	11.9929	12.0318	11.9596	11.9661	46251884.0
2011-05-26 10:00:00	AAPL	Stock	11.964	11.99	11.9575	11.9654	21896840.0
2011-05-26 10:30:00	AAPL	Stock	11.9643	11.9736	11.9507	11.9536	17558408.0
2011-05-26 11:00:00	AAPL	Stock	11.9546	11.9725	11.9441	11.9689	15128904.0
2011-05-26 11:30:00	AAPL	Stock	11.9689	11.9811	11.9518	11.9682	12298244.0
2011-05-26 12:00:00	AAPL	Stock	11.9686	12.0	11.9646	11.9993	12242552.0
2011-05-26 12:30:00	AAPL	Stock	12.0	12.01	11.9907	11.9982	13868176.0
2011-05-26 13:00:00	AAPL	Stock	12.0	12.0075	11.9779	12.0025	8463112.0
2011-05-26 13:30:00	AAPL	Stock	12.0004	12.0025	11.9732	11.9821	7106708.0
2011-05-26 14:00:00	AAPL	Stock	11.9821	12.0	11.9821	11.9954	7757680.0
2011-05-26 14:30:00	AAPL	Stock	11.9954	12.0004	11.9721	11.9879	11817680.0
2011-05-26 15:00:00	AAPL	Stock	11.9875	11.9946	11.965	11.9939	12817392.0
2011-05-26 15:30:00	AAPL	Stock	11.9936	12.0	11.9586	11.9639	24114216.0
2011-05-26 16:00:00	AAPL	Stock	11.9643	12.02	11.9643	11.9732	4636240.0
2011-05-26 16:30:00	AAPL	Stock	11.9714	11.9958	11.9604	11.9643	675640.0
2011-05-26 17:00:00	AAPL	Stock	11.9607	11.9629	11.9575	11.9582	68796.0
2011-05-26 17:30:00	AAPL	Stock	11.9607	11.9607	11.9607	11.9607	8736.0
2011-05-26 18:00:00	AAPL	Stock	11.9643	11.9643	11.9571	11.9589	70896.0
2011-05-26 18:30:00	AAPL	Stock	11.9611	11.9679	11.9611	11.9632	25760.0
2011-05-26 19:00:00	AAPL	Stock	11.9639	11.9643	11.9639	11.9643	28000.0
2011-05-26 19:30:00	AAPL	Stock	11.965	11.9721	11.9643	11.9643	61124.0
2011-05-26 07:00:00	MSFT	Stock	24.36	24.46	24.36	24.4	13800.0
2011-05-26 07:30:00	MSFT	Stock	24.4	24.43	24.4	24.41	8462.0
2011-05-26 08:00:00	MSFT	Stock	24.39	24.42	24.37	24.4	24490.0
2011-05-26 08:30:00	MSFT	Stock	24.37	24.37	24.27	24.32	36670.0
2011-05-26 09:00:00	MSFT	Stock	24.31	24.45	24.3	24.37	133626.0
2011-05-26 09:30:00	MSFT	Stock	24.36	24.75	24.32	24.59	13521988.0
2011-05-26 10:00:00	MSFT	Stock	24.585	24.72	24.58	24.661	7648044.0
2011-05-26 10:30:00	MSFT	Stock	24.67	24.67	24.53	24.606	5548232.0
2011-05-26 11:00:00	MSFT	Stock	24.61	24.81	24.6	24.805	7008227.0
2011-05-26 11:30:00	MSFT	Stock	24.81	24.86	24.73	24.73	5949932.0
2011-05-26 12:00:00	MSFT	Stock	24.73	24.76	24.69	24.755	3505884.0
2011-05-26 12:30:00	MSFT	Stock	24.755	24.84	24.75	24.785	3186064.0
2011-05-26 13:00:00	MSFT	Stock	24.785	24.84	24.77	24.84	3220951.0
2011-05-26 13:30:00	MSFT	Stock	24.83	24.83	24.75	24.82	2910997.0
2011-05-26 14:00:00	MSFT	Stock	24.82	24.87	24.8	24.839	3421873.0
2011-05-26 14:30:00	MSFT	Stock	24.84	24.88	24.79	24.819	2938590.0
2011-05-26 15:00:00	MSFT	Stock	24.82	24.83	24.74	24.76	3604637.0
2011-05-26 15:30:00	MSFT	Stock	24.76	24.78	24.66	24.67	9765509.0
2011-05-26 16:00:00	MSFT	Stock	24.67	24.804	24.66	24.67	2140010.0
2011-05-26 16:30:00	MSFT	Stock	24.71	24.772	24.7	24.7	15500.0

> showing 50 of 73,688 rows — these rows as CSV

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