PREVIEW / stock_30min / 2010-05-17

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-05-17.parquet
  size:    1.4 MB
  rows:    74,862
  symbols: 3,475

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
2010-05-17 04:30:00	AAPL	Stock	9.0354	9.0354	9.0354	9.0354	7000.0
2010-05-17 05:00:00	AAPL	Stock	9.0668	9.0668	9.0396	9.0396	11200.0
2010-05-17 05:30:00	AAPL	Stock	9.0675	9.0675	9.0675	9.0675	2800.0
2010-05-17 06:30:00	AAPL	Stock	9.0893	9.0893	9.0893	9.0893	5600.0
2010-05-17 07:00:00	AAPL	Stock	9.0818	9.125	9.0768	9.125	95928.0
2010-05-17 07:30:00	AAPL	Stock	9.1254	9.1254	9.1096	9.1196	126952.0
2010-05-17 08:00:00	AAPL	Stock	9.1111	9.1236	9.0486	9.0625	2326016.0
2010-05-17 08:30:00	AAPL	Stock	9.0648	9.0693	9.0525	9.0629	992992.0
2010-05-17 09:00:00	AAPL	Stock	9.0629	9.1246	9.0607	9.0982	2032464.0
2010-05-17 09:30:00	AAPL	Stock	9.0964	9.1493	9.0521	9.0796	106126188.0
2010-05-17 10:00:00	AAPL	Stock	9.0796	9.1189	9.0589	9.1131	51503676.0
2010-05-17 10:30:00	AAPL	Stock	9.1146	9.1379	9.0736	9.0739	41190548.0
2010-05-17 11:00:00	AAPL	Stock	9.0739	9.0879	8.9503	8.9725	64308804.0
2010-05-17 11:30:00	AAPL	Stock	8.9736	8.9961	8.9332	8.9371	49571200.0
2010-05-17 12:00:00	AAPL	Stock	8.9375	8.945	8.8468	8.9286	92837472.0
2010-05-17 12:30:00	AAPL	Stock	8.9286	8.9593	8.8875	8.9007	42949592.0
2010-05-17 13:00:00	AAPL	Stock	8.9021	8.9593	8.8943	8.9449	31572408.0
2010-05-17 13:30:00	AAPL	Stock	8.9454	8.9682	8.8968	8.9489	32435816.0
2010-05-17 14:00:00	AAPL	Stock	8.9471	8.9846	8.9339	8.9464	36640100.0
2010-05-17 14:30:00	AAPL	Stock	8.9471	9.0175	8.9257	9.0132	48876548.0
2010-05-17 15:00:00	AAPL	Stock	9.0118	9.0379	8.9464	8.9861	54980688.0
2010-05-17 15:30:00	AAPL	Stock	8.9846	9.0821	8.9836	9.0768	89938912.0
2010-05-17 16:00:00	AAPL	Stock	9.0782	9.0811	8.9665	9.0746	7883316.0
2010-05-17 16:30:00	AAPL	Stock	9.075	9.0814	8.9885	9.0807	669928.0
2010-05-17 17:00:00	AAPL	Stock	8.9644	9.0804	8.9644	9.075	190764.0
2010-05-17 17:30:00	AAPL	Stock	9.0739	9.0875	9.0739	9.0875	383432.0
2010-05-17 18:00:00	AAPL	Stock	9.0871	9.0879	9.075	9.075	224168.0
2010-05-17 18:30:00	AAPL	Stock	9.0782	9.0804	9.0754	9.0782	196840.0
2010-05-17 19:00:00	AAPL	Stock	9.0818	9.0818	9.0761	9.0796	107688.0
2010-05-17 19:30:00	AAPL	Stock	9.0796	9.0836	9.075	9.0818	263564.0
2010-05-17 07:00:00	MSFT	Stock	28.97	28.97	28.97	28.97	1245.0
2010-05-17 08:00:00	MSFT	Stock	28.87	28.98	28.87	28.89	18700.0
2010-05-17 08:30:00	MSFT	Stock	28.82	29.15	28.82	28.97	15208.0
2010-05-17 09:00:00	MSFT	Stock	29.03	29.22	28.99	29.16	23671.0
2010-05-17 09:30:00	MSFT	Stock	29.12	29.23	28.9	28.95	4826020.0
2010-05-17 10:00:00	MSFT	Stock	28.955	29.03	28.85	29.0	4009040.0
2010-05-17 10:30:00	MSFT	Stock	29.0	29.04	28.83	28.84	2605681.0
2010-05-17 11:00:00	MSFT	Stock	28.83	28.86	28.69	28.79	2922275.0
2010-05-17 11:30:00	MSFT	Stock	28.79	28.85	28.68	28.69	1871242.0
2010-05-17 12:00:00	MSFT	Stock	28.685	28.685	28.45	28.6	4197992.0
2010-05-17 12:30:00	MSFT	Stock	28.6	28.72	28.6	28.65	2376016.0
2010-05-17 13:00:00	MSFT	Stock	28.64	28.77	28.62	28.72	1978765.0
2010-05-17 13:30:00	MSFT	Stock	28.715	28.86	28.7	28.854	2752210.0
2010-05-17 14:00:00	MSFT	Stock	28.85	28.91	28.76	28.8	2251947.0
2010-05-17 14:30:00	MSFT	Stock	28.8	28.952	28.79	28.88	2576250.0
2010-05-17 15:00:00	MSFT	Stock	28.89	28.98	28.69	28.785	3694189.0
2010-05-17 15:30:00	MSFT	Stock	28.78	29.0	28.78	28.93	7065864.0
2010-05-17 16:00:00	MSFT	Stock	28.92	28.946	28.763	28.843	2686971.0
2010-05-17 16:30:00	MSFT	Stock	28.94	28.96	28.776	28.9	17377.0
2010-05-17 17:00:00	MSFT	Stock	28.779	28.779	28.779	28.779	300.0

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

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