PREVIEW / stock_30min / 2012-09-04

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-09-04.parquet
  size:    1.4 MB
  rows:    74,665
  symbols: 3,468

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-09-04 04:00:00	AAPL	Stock	23.8607	23.8839	23.8571	23.875	134512.0
2012-09-04 04:30:00	AAPL	Stock	23.8661	23.8661	23.8661	23.8661	14000.0
2012-09-04 05:30:00	AAPL	Stock	23.8839	23.8839	23.8839	23.8839	16800.0
2012-09-04 06:00:00	AAPL	Stock	23.8839	23.8839	23.8839	23.8839	5180.0
2012-09-04 06:30:00	AAPL	Stock	23.86	23.86	23.86	23.86	2800.0
2012-09-04 07:00:00	AAPL	Stock	23.8568	23.8568	23.8036	23.8357	174160.0
2012-09-04 07:30:00	AAPL	Stock	23.8357	23.8671	23.8357	23.8571	424984.0
2012-09-04 08:00:00	AAPL	Stock	23.8482	23.9286	23.6964	23.7679	1150996.0
2012-09-04 08:30:00	AAPL	Stock	23.7686	23.7957	23.7586	23.7704	396088.0
2012-09-04 09:00:00	AAPL	Stock	23.7643	23.7857	23.7582	23.7768	974736.0
2012-09-04 09:30:00	AAPL	Stock	23.7771	23.9582	23.7682	23.9518	54486796.0
2012-09-04 10:00:00	AAPL	Stock	23.9486	23.9932	23.8811	23.8939	35787724.0
2012-09-04 10:30:00	AAPL	Stock	23.8929	23.9014	23.7321	23.7429	34368236.0
2012-09-04 11:00:00	AAPL	Stock	23.7429	23.8479	23.7414	23.8393	21625968.0
2012-09-04 11:30:00	AAPL	Stock	23.8393	23.885	23.7971	23.8645	16819460.0
2012-09-04 12:00:00	AAPL	Stock	23.8661	23.8964	23.8171	23.8731	20490792.0
2012-09-04 12:30:00	AAPL	Stock	23.8668	23.9279	23.8507	23.9196	15190168.0
2012-09-04 13:00:00	AAPL	Stock	23.9236	23.9679	23.9214	23.9386	17483788.0
2012-09-04 13:30:00	AAPL	Stock	23.9371	23.9479	23.9146	23.9359	9596300.0
2012-09-04 14:00:00	AAPL	Stock	23.935	24.0336	23.9214	24.0268	23369920.0
2012-09-04 14:30:00	AAPL	Stock	24.03	24.1	24.0264	24.0746	33314624.0
2012-09-04 15:00:00	AAPL	Stock	24.0746	24.1121	24.0661	24.1011	28120456.0
2012-09-04 15:30:00	AAPL	Stock	24.0989	24.1107	24.0446	24.0943	40457928.0
2012-09-04 16:00:00	AAPL	Stock	24.0932	24.1268	23.8433	23.8433	8461712.0
2012-09-04 16:30:00	AAPL	Stock	24.1071	24.1071	23.7961	24.0982	204148.0
2012-09-04 17:00:00	AAPL	Stock	24.0982	24.1082	24.0918	24.1071	152124.0
2012-09-04 17:30:00	AAPL	Stock	24.1014	24.1179	24.0996	24.1132	151648.0
2012-09-04 18:00:00	AAPL	Stock	24.1175	24.1186	24.1089	24.1143	147812.0
2012-09-04 18:30:00	AAPL	Stock	24.1139	24.1139	24.11	24.11	21000.0
2012-09-04 19:00:00	AAPL	Stock	24.11	24.1111	24.1071	24.1111	94696.0
2012-09-04 19:30:00	AAPL	Stock	24.1075	24.1075	24.0989	24.1068	217252.0
2012-09-04 04:00:00	MSFT	Stock	30.81	30.81	30.78	30.78	200.0
2012-09-04 05:00:00	MSFT	Stock	31.0	31.0	31.0	31.0	100.0
2012-09-04 05:30:00	MSFT	Stock	31.02	31.02	31.02	31.02	500.0
2012-09-04 07:00:00	MSFT	Stock	30.89	30.89	30.89	30.89	100.0
2012-09-04 07:30:00	MSFT	Stock	30.85	30.85	30.85	30.85	190.0
2012-09-04 08:00:00	MSFT	Stock	30.89	30.95	30.85	30.86	12201.0
2012-09-04 08:30:00	MSFT	Stock	30.83	30.85	30.82	30.82	10350.0
2012-09-04 09:00:00	MSFT	Stock	30.82	30.82	29.88	30.44	646307.0
2012-09-04 09:30:00	MSFT	Stock	30.45	30.66	30.41	30.571	6538961.0
2012-09-04 10:00:00	MSFT	Stock	30.57	30.63	30.33	30.33	3984446.0
2012-09-04 10:30:00	MSFT	Stock	30.335	30.335	30.17	30.2	4079491.0
2012-09-04 11:00:00	MSFT	Stock	30.2	30.22	30.15	30.19	2458475.0
2012-09-04 11:30:00	MSFT	Stock	30.2	30.34	30.19	30.335	2492302.0
2012-09-04 12:00:00	MSFT	Stock	30.34	30.34	30.23	30.245	2342028.0
2012-09-04 12:30:00	MSFT	Stock	30.25	30.31	30.24	30.29	3653437.0
2012-09-04 13:00:00	MSFT	Stock	30.28	30.31	30.25	30.29	1864189.0
2012-09-04 13:30:00	MSFT	Stock	30.29	30.3	30.2	30.24	1530931.0
2012-09-04 14:00:00	MSFT	Stock	30.235	30.3	30.2	30.29	2269488.0
2012-09-04 14:30:00	MSFT	Stock	30.3	30.42	30.29	30.39	3387209.0

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

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