PREVIEW / stock_30min / 2012-01-04

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-01-04.parquet
  size:    1.4 MB
  rows:    74,824
  symbols: 3,520

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-01-04 04:00:00	AAPL	Stock	14.6436	14.6436	14.6436	14.6436	2800.0
2012-01-04 05:30:00	AAPL	Stock	14.6511	14.6511	14.6429	14.6429	16800.0
2012-01-04 06:00:00	AAPL	Stock	14.6429	14.6429	14.6271	14.6271	30800.0
2012-01-04 06:30:00	AAPL	Stock	14.6271	14.6271	14.6179	14.6214	22400.0
2012-01-04 07:00:00	AAPL	Stock	14.6254	14.6696	14.625	14.6607	175000.0
2012-01-04 07:30:00	AAPL	Stock	14.6571	14.6607	14.6518	14.6536	81620.0
2012-01-04 08:00:00	AAPL	Stock	14.6696	14.6768	14.5911	14.6246	947184.0
2012-01-04 08:30:00	AAPL	Stock	14.6093	14.6679	14.6089	14.6429	1068228.0
2012-01-04 09:00:00	AAPL	Stock	14.6429	14.6496	14.6357	14.6471	380884.0
2012-01-04 09:30:00	AAPL	Stock	14.6429	14.6964	14.6171	14.6732	35707532.0
2012-01-04 10:00:00	AAPL	Stock	14.6689	14.6786	14.6311	14.6518	18283104.0
2012-01-04 10:30:00	AAPL	Stock	14.6514	14.6764	14.6214	14.6736	19162528.0
2012-01-04 11:00:00	AAPL	Stock	14.6737	14.7639	14.6689	14.7404	27067964.0
2012-01-04 11:30:00	AAPL	Stock	14.7411	14.7679	14.7393	14.7536	15038352.0
2012-01-04 12:00:00	AAPL	Stock	14.7529	14.8021	14.7489	14.7889	17374028.0
2012-01-04 12:30:00	AAPL	Stock	14.7893	14.81	14.7804	14.8018	11642680.0
2012-01-04 13:00:00	AAPL	Stock	14.8032	14.8039	14.7518	14.7629	14071232.0
2012-01-04 13:30:00	AAPL	Stock	14.7634	14.7964	14.7625	14.7907	10252676.0
2012-01-04 14:00:00	AAPL	Stock	14.7907	14.7923	14.75	14.7772	12346096.0
2012-01-04 14:30:00	AAPL	Stock	14.7784	14.7943	14.7732	14.7777	8418424.0
2012-01-04 15:00:00	AAPL	Stock	14.7768	14.7821	14.7375	14.7725	15049328.0
2012-01-04 15:30:00	AAPL	Stock	14.7725	14.7975	14.7593	14.7657	40242216.0
2012-01-04 16:00:00	AAPL	Stock	14.7674	14.7911	14.7238	14.7696	7819336.0
2012-01-04 16:30:00	AAPL	Stock	14.7679	14.7782	14.7679	14.77	139048.0
2012-01-04 17:00:00	AAPL	Stock	14.7746	14.775	14.7689	14.775	74536.0
2012-01-04 17:30:00	AAPL	Stock	14.7657	14.7864	14.7657	14.7864	1040312.0
2012-01-04 18:00:00	AAPL	Stock	14.7857	14.7882	14.7657	14.7857	123676.0
2012-01-04 18:30:00	AAPL	Stock	14.7861	14.7893	14.7861	14.7861	38948.0
2012-01-04 19:00:00	AAPL	Stock	14.7914	14.7961	14.7914	14.7954	99204.0
2012-01-04 19:30:00	AAPL	Stock	14.7957	14.8036	14.7932	14.8036	86996.0
2012-01-04 05:00:00	MSFT	Stock	26.8	26.8	26.8	26.8	1000.0
2012-01-04 06:30:00	MSFT	Stock	26.73	26.73	26.73	26.73	200.0
2012-01-04 07:30:00	MSFT	Stock	26.75	26.75	26.75	26.75	200.0
2012-01-04 08:00:00	MSFT	Stock	26.8	26.8	26.75	26.75	7890.0
2012-01-04 08:30:00	MSFT	Stock	26.78	26.82	26.76	26.82	4265.0
2012-01-04 09:00:00	MSFT	Stock	26.78	26.84	26.78	26.81	26145.0
2012-01-04 09:30:00	MSFT	Stock	26.81	27.1	26.78	27.06	11122640.0
2012-01-04 10:00:00	MSFT	Stock	27.069	27.07	26.96	27.0	5059824.0
2012-01-04 10:30:00	MSFT	Stock	26.991	27.14	26.94	27.07	6825260.0
2012-01-04 11:00:00	MSFT	Stock	27.071	27.2	27.06	27.195	4089364.0
2012-01-04 11:30:00	MSFT	Stock	27.195	27.25	27.13	27.21	5304141.0
2012-01-04 12:00:00	MSFT	Stock	27.202	27.23	27.15	27.19	2855087.0
2012-01-04 12:30:00	MSFT	Stock	27.2	27.25	27.15	27.25	2450726.0
2012-01-04 13:00:00	MSFT	Stock	27.245	27.38	27.24	27.345	6444520.0
2012-01-04 13:30:00	MSFT	Stock	27.346	27.38	27.31	27.37	3716035.0
2012-01-04 14:00:00	MSFT	Stock	27.36	27.41	27.3	27.41	6220624.0
2012-01-04 14:30:00	MSFT	Stock	27.405	27.47	27.36	27.425	6426665.0
2012-01-04 15:00:00	MSFT	Stock	27.425	27.44	27.37	27.385	4155531.0
2012-01-04 15:30:00	MSFT	Stock	27.39	27.41	27.34	27.39	9430998.0
2012-01-04 16:00:00	MSFT	Stock	27.39	27.43	26.83	27.37	3163869.0

> showing 50 of 74,824 rows — these rows as CSV

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