PREVIEW / stock_30min / 2012-06-25

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-06-25.parquet
  size:    1.4 MB
  rows:    75,063
  symbols: 3,517

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
2012-06-25 04:00:00	AAPL	Stock	20.7893	20.7893	20.6607	20.6607	27580.0
2012-06-25 04:30:00	AAPL	Stock	20.6964	20.6964	20.6964	20.6964	2800.0
2012-06-25 05:00:00	AAPL	Stock	20.6611	20.6611	20.6611	20.6611	5600.0
2012-06-25 05:30:00	AAPL	Stock	20.6611	20.6611	20.6611	20.6611	7840.0
2012-06-25 07:00:00	AAPL	Stock	20.6729	20.6786	20.6518	20.6607	46200.0
2012-06-25 07:30:00	AAPL	Stock	20.6536	20.6786	20.6536	20.6768	47600.0
2012-06-25 08:00:00	AAPL	Stock	20.6764	20.6764	20.6171	20.6425	749112.0
2012-06-25 08:30:00	AAPL	Stock	20.6429	20.6607	20.6339	20.6589	320936.0
2012-06-25 09:00:00	AAPL	Stock	20.6557	20.6693	20.6179	20.6179	645848.0
2012-06-25 09:30:00	AAPL	Stock	20.6196	20.7071	20.5714	20.6114	34817328.0
2012-06-25 10:00:00	AAPL	Stock	20.6087	20.6339	20.5046	20.5318	32059496.0
2012-06-25 10:30:00	AAPL	Stock	20.5296	20.5625	20.4911	20.5401	21724976.0
2012-06-25 11:00:00	AAPL	Stock	20.5414	20.5486	20.4432	20.4464	22195908.0
2012-06-25 11:30:00	AAPL	Stock	20.4518	20.4543	20.3864	20.4293	23478784.0
2012-06-25 12:00:00	AAPL	Stock	20.4293	20.45	20.4061	20.4321	18111464.0
2012-06-25 12:30:00	AAPL	Stock	20.4339	20.4579	20.4164	20.4486	14417928.0
2012-06-25 13:00:00	AAPL	Stock	20.45	20.4732	20.3982	20.4571	13373808.0
2012-06-25 13:30:00	AAPL	Stock	20.4543	20.5214	20.4418	20.4743	14519008.0
2012-06-25 14:00:00	AAPL	Stock	20.4736	20.5089	20.4196	20.4229	13134184.0
2012-06-25 14:30:00	AAPL	Stock	20.4193	20.4418	20.3718	20.3868	22526392.0
2012-06-25 15:00:00	AAPL	Stock	20.3868	20.4629	20.3704	20.4381	24301508.0
2012-06-25 15:30:00	AAPL	Stock	20.4375	20.4604	20.3818	20.3839	33155976.0
2012-06-25 16:00:00	AAPL	Stock	20.3845	20.5072	20.3821	20.3829	10159996.0
2012-06-25 16:30:00	AAPL	Stock	20.3871	20.436	20.3829	20.3829	582680.0
2012-06-25 17:00:00	AAPL	Stock	20.3929	20.4297	20.3845	20.3911	125440.0
2012-06-25 17:30:00	AAPL	Stock	20.3904	20.395	20.3893	20.3929	133812.0
2012-06-25 18:00:00	AAPL	Stock	20.3914	20.3929	20.3864	20.3864	65100.0
2012-06-25 18:30:00	AAPL	Stock	20.3861	20.3896	20.3839	20.3875	51380.0
2012-06-25 19:00:00	AAPL	Stock	20.3871	20.4018	20.3871	20.4018	188972.0
2012-06-25 19:30:00	AAPL	Stock	20.3964	20.4	20.3929	20.3929	43960.0
2012-06-25 06:00:00	MSFT	Stock	30.32	30.32	30.32	30.32	400.0
2012-06-25 07:30:00	MSFT	Stock	30.32	30.43	30.31	30.43	1100.0
2012-06-25 08:00:00	MSFT	Stock	30.39	30.46	30.33	30.46	9551.0
2012-06-25 08:30:00	MSFT	Stock	30.45	30.45	30.31	30.4	14732.0
2012-06-25 09:00:00	MSFT	Stock	30.4	30.4	30.3	30.33	34419.0
2012-06-25 09:30:00	MSFT	Stock	30.3	30.32	30.035	30.12	4517002.0
2012-06-25 10:00:00	MSFT	Stock	30.125	30.18	29.86	29.88	4226459.0
2012-06-25 10:30:00	MSFT	Stock	29.88	29.92	29.83	29.886	3264012.0
2012-06-25 11:00:00	MSFT	Stock	29.88	29.935	29.84	29.85	2074161.0
2012-06-25 11:30:00	MSFT	Stock	29.85	29.86	29.7	29.75	2869603.0
2012-06-25 12:00:00	MSFT	Stock	29.75	29.86	29.73	29.825	1288649.0
2012-06-25 12:30:00	MSFT	Stock	29.83	29.86	29.8	29.821	917475.0
2012-06-25 13:00:00	MSFT	Stock	29.82	29.83	29.76	29.82	1111097.0
2012-06-25 13:30:00	MSFT	Stock	29.829	29.88	29.76	29.782	1478554.0
2012-06-25 14:00:00	MSFT	Stock	29.789	29.8	29.71	29.71	1990311.0
2012-06-25 14:30:00	MSFT	Stock	29.71	29.72	29.62	29.69	2890757.0
2012-06-25 15:00:00	MSFT	Stock	29.692	29.859	29.69	29.849	3533326.0
2012-06-25 15:30:00	MSFT	Stock	29.85	29.89	29.77	29.84	6715297.0
2012-06-25 16:00:00	MSFT	Stock	29.84	30.06	29.642	29.84	4365180.0
2012-06-25 16:30:00	MSFT	Stock	29.85	29.851	29.84	29.84	105945.0

> showing 50 of 75,063 rows — these rows as CSV

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