PREVIEW / stock_30min / 2012-06-19

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-06-19.parquet
  size:    1.4 MB
  rows:    77,419
  symbols: 3,538

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-06-19 04:00:00	AAPL	Stock	20.8575	20.8575	20.8571	20.8571	30800.0
2012-06-19 04:30:00	AAPL	Stock	20.875	20.875	20.875	20.875	7700.0
2012-06-19 05:00:00	AAPL	Stock	20.85	20.875	20.85	20.875	11200.0
2012-06-19 05:30:00	AAPL	Stock	20.8839	20.9286	20.8839	20.9286	40600.0
2012-06-19 06:00:00	AAPL	Stock	20.9286	20.9286	20.9107	20.9107	7700.0
2012-06-19 07:00:00	AAPL	Stock	20.9193	20.98	20.8864	20.9482	623140.0
2012-06-19 07:30:00	AAPL	Stock	20.9532	20.9643	20.8682	20.8821	951944.0
2012-06-19 08:00:00	AAPL	Stock	20.8929	20.9639	20.8521	20.8861	2510228.0
2012-06-19 08:30:00	AAPL	Stock	20.885	20.8929	20.8036	20.85	1762488.0
2012-06-19 09:00:00	AAPL	Stock	20.8393	20.8746	20.8264	20.8307	2121952.0
2012-06-19 09:30:00	AAPL	Stock	20.8357	21.0532	20.825	20.9543	79913484.0
2012-06-19 10:00:00	AAPL	Stock	20.9581	20.9764	20.8811	20.9164	38706920.0
2012-06-19 10:30:00	AAPL	Stock	20.9171	20.9554	20.8636	20.9354	30475732.0
2012-06-19 11:00:00	AAPL	Stock	20.9334	20.9707	20.8929	20.9646	17952508.0
2012-06-19 11:30:00	AAPL	Stock	20.9675	21.0257	20.9407	20.9893	22168860.0
2012-06-19 12:00:00	AAPL	Stock	20.9883	21.0107	20.9682	20.995	9734788.0
2012-06-19 12:30:00	AAPL	Stock	20.9971	21.0107	20.975	20.9936	8193024.0
2012-06-19 13:00:00	AAPL	Stock	20.99	21.0107	20.9739	21.0029	8951460.0
2012-06-19 13:30:00	AAPL	Stock	21.0036	21.0714	20.9957	21.0296	28150976.0
2012-06-19 14:00:00	AAPL	Stock	21.0325	21.0589	20.9586	20.9786	17925824.0
2012-06-19 14:30:00	AAPL	Stock	20.9861	20.9978	20.9219	20.9978	28624960.0
2012-06-19 15:00:00	AAPL	Stock	20.9971	21.0425	20.9557	20.9715	22460060.0
2012-06-19 15:30:00	AAPL	Stock	20.9725	20.9946	20.9489	20.9764	30490068.0
2012-06-19 16:00:00	AAPL	Stock	20.9789	20.9869	20.9647	20.9679	6742652.0
2012-06-19 16:30:00	AAPL	Stock	20.9689	20.9789	20.9643	20.9668	759080.0
2012-06-19 17:00:00	AAPL	Stock	20.9796	20.9796	20.9586	20.9657	138992.0
2012-06-19 17:30:00	AAPL	Stock	20.9621	20.9643	20.9596	20.9643	75936.0
2012-06-19 18:00:00	AAPL	Stock	20.9625	20.9679	20.9607	20.9675	66024.0
2012-06-19 18:30:00	AAPL	Stock	20.9679	20.9714	20.9679	20.9714	51800.0
2012-06-19 19:00:00	AAPL	Stock	20.9721	20.9721	20.9607	20.9607	84392.0
2012-06-19 19:30:00	AAPL	Stock	20.9589	20.9621	20.9468	20.9554	166376.0
2012-06-19 04:30:00	MSFT	Stock	30.0	30.0	30.0	30.0	1400.0
2012-06-19 06:00:00	MSFT	Stock	30.03	30.03	30.03	30.03	200.0
2012-06-19 07:00:00	MSFT	Stock	30.03	30.12	30.03	30.1	17207.0
2012-06-19 07:30:00	MSFT	Stock	30.07	30.14	30.07	30.1	22829.0
2012-06-19 08:00:00	MSFT	Stock	30.13	30.13	29.9	29.95	110229.0
2012-06-19 08:30:00	MSFT	Stock	29.95	30.05	29.95	30.02	41069.0
2012-06-19 09:00:00	MSFT	Stock	30.0	30.27	30.0	30.17	360092.0
2012-06-19 09:30:00	MSFT	Stock	30.19	30.8	30.05	30.768	14776624.0
2012-06-19 10:00:00	MSFT	Stock	30.765	30.99	30.74	30.925	8685718.0
2012-06-19 10:30:00	MSFT	Stock	30.93	31.06	30.88	31.04	8403830.0
2012-06-19 11:00:00	MSFT	Stock	31.04	31.11	30.92	30.98	6201611.0
2012-06-19 11:30:00	MSFT	Stock	30.98	31.0	30.93	30.98	2896453.0
2012-06-19 12:00:00	MSFT	Stock	30.975	31.03	30.85	30.87	3896046.0
2012-06-19 12:30:00	MSFT	Stock	30.87	30.95	30.85	30.945	2254118.0
2012-06-19 13:00:00	MSFT	Stock	30.94	30.95	30.9	30.94	2398545.0
2012-06-19 13:30:00	MSFT	Stock	30.93	31.01	30.89	30.93	3480686.0
2012-06-19 14:00:00	MSFT	Stock	30.92	30.94	30.72	30.75	3530211.0
2012-06-19 14:30:00	MSFT	Stock	30.745	30.78	30.68	30.74	3390426.0
2012-06-19 15:00:00	MSFT	Stock	30.74	30.81	30.65	30.67	3356851.0

> showing 50 of 77,419 rows — these rows as CSV

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