PREVIEW / stock_30min / 2011-01-31

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-01-31.parquet
  size:    1.4 MB
  rows:    76,207
  symbols: 3,539

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-01-31 04:00:00	AAPL	Stock	11.9654	11.9654	11.9654	11.9654	2800.0
2011-01-31 04:30:00	AAPL	Stock	11.9929	11.9929	11.9929	11.9929	16520.0
2011-01-31 05:00:00	AAPL	Stock	11.9893	11.9971	11.9893	11.9971	8400.0
2011-01-31 05:30:00	AAPL	Stock	11.9836	11.9836	11.9836	11.9836	5600.0
2011-01-31 06:00:00	AAPL	Stock	12.0082	12.0289	12.0082	12.0289	22960.0
2011-01-31 06:30:00	AAPL	Stock	12.0139	12.0139	12.0096	12.0096	8400.0
2011-01-31 07:00:00	AAPL	Stock	12.0214	12.0339	12.0	12.0243	137368.0
2011-01-31 07:30:00	AAPL	Stock	12.0111	12.0571	12.0111	12.0525	313600.0
2011-01-31 08:00:00	AAPL	Stock	12.0386	12.0679	12.0021	12.0607	1212652.0
2011-01-31 08:30:00	AAPL	Stock	12.0607	12.0732	12.0536	12.0607	815892.0
2011-01-31 09:00:00	AAPL	Stock	12.0554	12.0636	11.9936	11.9936	1056244.0
2011-01-31 09:30:00	AAPL	Stock	11.9932	12.0589	11.9586	11.9789	67355764.0
2011-01-31 10:00:00	AAPL	Stock	11.9786	12.0257	11.9393	12.0107	36526952.0
2011-01-31 10:30:00	AAPL	Stock	12.0111	12.075	12.0029	12.0525	29611316.0
2011-01-31 11:00:00	AAPL	Stock	12.0543	12.0964	12.0464	12.0875	21270704.0
2011-01-31 11:30:00	AAPL	Stock	12.0875	12.1036	12.0725	12.0925	18579988.0
2011-01-31 12:00:00	AAPL	Stock	12.0924	12.1443	12.09	12.1418	28182252.0
2011-01-31 12:30:00	AAPL	Stock	12.1413	12.1429	12.1032	12.1068	16080484.0
2011-01-31 13:00:00	AAPL	Stock	12.1071	12.1246	12.0971	12.1071	12457284.0
2011-01-31 13:30:00	AAPL	Stock	12.1086	12.1118	12.0786	12.1021	14843024.0
2011-01-31 14:00:00	AAPL	Stock	12.1025	12.1125	12.0857	12.0889	11477816.0
2011-01-31 14:30:00	AAPL	Stock	12.0879	12.0914	12.0321	12.0604	24341884.0
2011-01-31 15:00:00	AAPL	Stock	12.0589	12.1054	12.0475	12.0864	19169640.0
2011-01-31 15:30:00	AAPL	Stock	12.0864	12.1179	12.0739	12.1179	32561648.0
2011-01-31 16:00:00	AAPL	Stock	12.1186	12.1214	12.062	12.1139	25849348.0
2011-01-31 16:30:00	AAPL	Stock	12.1143	12.1187	12.0116	12.1071	589204.0
2011-01-31 17:00:00	AAPL	Stock	12.1075	12.1186	12.1004	12.1186	149520.0
2011-01-31 17:30:00	AAPL	Stock	12.1	12.11	12.1	12.1018	67592.0
2011-01-31 18:00:00	AAPL	Stock	12.1018	12.1186	12.1018	12.1186	42140.0
2011-01-31 18:30:00	AAPL	Stock	12.1071	12.1071	12.1021	12.1071	23800.0
2011-01-31 19:00:00	AAPL	Stock	12.1071	12.1125	12.1071	12.1125	103460.0
2011-01-31 19:30:00	AAPL	Stock	12.1125	12.1279	12.1125	12.1279	170716.0
2011-01-31 04:00:00	MSFT	Stock	27.7	27.76	27.61	27.76	6300.0
2011-01-31 04:30:00	MSFT	Stock	27.76	27.8	27.61	27.61	18865.0
2011-01-31 05:00:00	MSFT	Stock	27.79	27.79	27.71	27.71	200.0
2011-01-31 06:30:00	MSFT	Stock	27.79	27.79	27.79	27.79	100.0
2011-01-31 07:00:00	MSFT	Stock	27.79	27.79	27.78	27.78	5600.0
2011-01-31 07:30:00	MSFT	Stock	27.76	27.79	27.76	27.79	2350.0
2011-01-31 08:00:00	MSFT	Stock	27.76	27.82	27.71	27.81	17087.0
2011-01-31 08:30:00	MSFT	Stock	27.81	27.9	27.751	27.8	40780.0
2011-01-31 09:00:00	MSFT	Stock	27.79	27.86	27.78	27.8	25424.0
2011-01-31 09:30:00	MSFT	Stock	27.8	27.9	27.46	27.5	10740288.0
2011-01-31 10:00:00	MSFT	Stock	27.492	27.69	27.46	27.628	7885028.0
2011-01-31 10:30:00	MSFT	Stock	27.625	27.76	27.62	27.675	3879621.0
2011-01-31 11:00:00	MSFT	Stock	27.68	27.69	27.47	27.48	4808677.0
2011-01-31 11:30:00	MSFT	Stock	27.48	27.52	27.42	27.492	4062725.0
2011-01-31 12:00:00	MSFT	Stock	27.49	27.7	27.49	27.64	3764122.0
2011-01-31 12:30:00	MSFT	Stock	27.64	27.64	27.52	27.6	1992852.0
2011-01-31 13:00:00	MSFT	Stock	27.61	27.66	27.6	27.635	1970962.0
2011-01-31 13:30:00	MSFT	Stock	27.632	27.65	27.59	27.59	1896043.0

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

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