PREVIEW / stock_30min / 2011-05-09

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-05-09.parquet
  size:    1.4 MB
  rows:    75,996
  symbols: 3,561

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-09 04:00:00	AAPL	Stock	12.4464	12.4575	12.4464	12.4575	9800.0
2011-05-09 05:30:00	AAPL	Stock	12.4214	12.4214	12.4214	12.4214	2800.0
2011-05-09 06:00:00	AAPL	Stock	12.455	12.455	12.4214	12.4214	8400.0
2011-05-09 06:30:00	AAPL	Stock	12.4214	12.4214	12.3929	12.3929	32900.0
2011-05-09 07:00:00	AAPL	Stock	12.3929	12.4214	12.3929	12.4164	72380.0
2011-05-09 07:30:00	AAPL	Stock	12.4286	12.4393	12.4179	12.4304	271236.0
2011-05-09 08:00:00	AAPL	Stock	12.4368	12.4454	12.4104	12.4229	703360.0
2011-05-09 08:30:00	AAPL	Stock	12.4143	12.4186	12.395	12.3982	285068.0
2011-05-09 09:00:00	AAPL	Stock	12.4032	12.4275	12.3964	12.4236	812504.0
2011-05-09 09:30:00	AAPL	Stock	12.4221	12.4714	12.3964	12.4114	40137608.0
2011-05-09 10:00:00	AAPL	Stock	12.4114	12.4375	12.376	12.4057	23865772.0
2011-05-09 10:30:00	AAPL	Stock	12.4068	12.4271	12.3886	12.4154	12123468.0
2011-05-09 11:00:00	AAPL	Stock	12.4161	12.425	12.4014	12.4102	9082080.0
2011-05-09 11:30:00	AAPL	Stock	12.4121	12.4389	12.4021	12.4318	11991924.0
2011-05-09 12:00:00	AAPL	Stock	12.4336	12.4521	12.4143	12.425	20173244.0
2011-05-09 12:30:00	AAPL	Stock	12.4229	12.43	12.4036	12.4042	11167996.0
2011-05-09 13:00:00	AAPL	Stock	12.4054	12.4332	12.4054	12.4207	7317268.0
2011-05-09 13:30:00	AAPL	Stock	12.4207	12.4439	12.4171	12.4296	7598836.0
2011-05-09 14:00:00	AAPL	Stock	12.4311	12.4329	12.4161	12.426	8325352.0
2011-05-09 14:30:00	AAPL	Stock	12.4254	12.4446	12.4254	12.435	12286232.0
2011-05-09 15:00:00	AAPL	Stock	12.4347	12.4382	12.4196	12.42	7828968.0
2011-05-09 15:30:00	AAPL	Stock	12.42	12.4293	12.4104	12.4111	22849624.0
2011-05-09 16:00:00	AAPL	Stock	12.4142	12.429	12.4071	12.4107	4990776.0
2011-05-09 16:30:00	AAPL	Stock	12.4107	12.4176	12.4071	12.4071	298424.0
2011-05-09 17:00:00	AAPL	Stock	12.4093	12.4093	12.4057	12.4093	101612.0
2011-05-09 17:30:00	AAPL	Stock	12.4121	12.4121	12.4093	12.4104	30436.0
2011-05-09 18:00:00	AAPL	Stock	12.4107	12.4143	12.4107	12.4121	103208.0
2011-05-09 18:30:00	AAPL	Stock	12.4118	12.4118	12.41	12.41	5600.0
2011-05-09 19:00:00	AAPL	Stock	12.4114	12.4121	12.4104	12.4121	24500.0
2011-05-09 19:30:00	AAPL	Stock	12.4093	12.4121	12.4082	12.4121	64512.0
2011-05-09 08:00:00	MSFT	Stock	25.98	25.99	25.93	25.93	4278.0
2011-05-09 08:30:00	MSFT	Stock	25.91	25.94	25.87	25.89	4030.0
2011-05-09 09:00:00	MSFT	Stock	25.86	25.9	25.82	25.82	19160.0
2011-05-09 09:30:00	MSFT	Stock	25.81	25.9	25.8	25.82	3393496.0
2011-05-09 10:00:00	MSFT	Stock	25.82	25.88	25.75	25.765	3803119.0
2011-05-09 10:30:00	MSFT	Stock	25.76	25.8	25.675	25.759	3446023.0
2011-05-09 11:00:00	MSFT	Stock	25.755	25.78	25.71	25.73	1861116.0
2011-05-09 11:30:00	MSFT	Stock	25.73	25.85	25.67	25.835	3226326.0
2011-05-09 12:00:00	MSFT	Stock	25.83	25.95	25.83	25.882	3811820.0
2011-05-09 12:30:00	MSFT	Stock	25.89	25.95	25.86	25.88	1714388.0
2011-05-09 13:00:00	MSFT	Stock	25.88	25.945	25.87	25.92	2612904.0
2011-05-09 13:30:00	MSFT	Stock	25.925	25.96	25.92	25.93	912328.0
2011-05-09 14:00:00	MSFT	Stock	25.93	25.94	25.89	25.899	1286896.0
2011-05-09 14:30:00	MSFT	Stock	25.9	25.95	25.83	25.85	2049603.0
2011-05-09 15:00:00	MSFT	Stock	25.86	25.89	25.845	25.86	1946695.0
2011-05-09 15:30:00	MSFT	Stock	25.855	25.88	25.8	25.82	4611443.0
2011-05-09 16:00:00	MSFT	Stock	25.82	25.87	25.691	25.83	3353560.0
2011-05-09 16:30:00	MSFT	Stock	25.83	25.855	25.81	25.81	9650.0
2011-05-09 17:00:00	MSFT	Stock	25.81	25.84	25.81	25.81	760.0
2011-05-09 17:30:00	MSFT	Stock	25.83	25.83	25.8	25.8	11023.0

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

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