PREVIEW / stock_30min / 2012-09-26

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-09-26.parquet
  size:    1.4 MB
  rows:    77,401
  symbols: 3,459

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-26 04:00:00	AAPL	Stock	24.1025	24.1025	24.0446	24.0446	69720.0
2012-09-26 04:30:00	AAPL	Stock	24.0075	24.0714	24.0075	24.0714	23100.0
2012-09-26 05:00:00	AAPL	Stock	24.0857	24.0893	24.0857	24.0893	19600.0
2012-09-26 05:30:00	AAPL	Stock	24.0893	24.0893	24.0893	24.0893	5600.0
2012-09-26 06:30:00	AAPL	Stock	24.0643	24.0643	24.0211	24.0211	40460.0
2012-09-26 07:00:00	AAPL	Stock	24.0357	24.0511	24.0	24.0004	150836.0
2012-09-26 07:30:00	AAPL	Stock	24.0014	24.0014	23.8982	23.9432	533680.0
2012-09-26 08:00:00	AAPL	Stock	23.9518	24.0661	23.9143	23.9639	1486828.0
2012-09-26 08:30:00	AAPL	Stock	23.9654	23.9782	23.9196	23.9464	1325828.0
2012-09-26 09:00:00	AAPL	Stock	23.9446	23.9643	23.8739	23.8789	2400804.0
2012-09-26 09:30:00	AAPL	Stock	23.8832	23.9246	23.625	23.767	134101380.0
2012-09-26 10:00:00	AAPL	Stock	23.7655	23.8839	23.6936	23.6993	51816716.0
2012-09-26 10:30:00	AAPL	Stock	23.6975	23.7461	23.6143	23.6429	51476740.0
2012-09-26 11:00:00	AAPL	Stock	23.6429	23.75	23.6429	23.71	31448676.0
2012-09-26 11:30:00	AAPL	Stock	23.7104	23.7432	23.6571	23.6939	24796996.0
2012-09-26 12:00:00	AAPL	Stock	23.6897	23.8336	23.6662	23.7604	38671528.0
2012-09-26 12:30:00	AAPL	Stock	23.7589	23.762	23.6739	23.7289	24482920.0
2012-09-26 13:00:00	AAPL	Stock	23.7289	23.8636	23.6893	23.8525	21505680.0
2012-09-26 13:30:00	AAPL	Stock	23.8589	23.8831	23.7661	23.7752	22643824.0
2012-09-26 14:00:00	AAPL	Stock	23.7779	24.0246	23.7737	23.9966	49235396.0
2012-09-26 14:30:00	AAPL	Stock	23.9893	24.0007	23.865	23.921	34287680.0
2012-09-26 15:00:00	AAPL	Stock	23.9164	23.9279	23.7832	23.8504	28973392.0
2012-09-26 15:30:00	AAPL	Stock	23.8525	23.8729	23.75	23.7511	38779160.0
2012-09-26 16:00:00	AAPL	Stock	23.75	23.8622	23.7332	23.7621	10120656.0
2012-09-26 16:30:00	AAPL	Stock	23.7643	23.8498	23.711	23.7746	692440.0
2012-09-26 17:00:00	AAPL	Stock	23.7732	23.7775	23.75	23.7707	654136.0
2012-09-26 17:30:00	AAPL	Stock	23.765	23.7775	23.765	23.7714	30128.0
2012-09-26 18:00:00	AAPL	Stock	23.7764	23.8036	23.7764	23.7957	94164.0
2012-09-26 18:30:00	AAPL	Stock	23.8025	23.8025	23.7875	23.7925	36960.0
2012-09-26 19:00:00	AAPL	Stock	23.7929	23.7929	23.7736	23.7829	81508.0
2012-09-26 19:30:00	AAPL	Stock	23.7721	23.8036	23.7646	23.8036	101948.0
2012-09-26 07:00:00	MSFT	Stock	30.31	30.38	30.3	30.38	3500.0
2012-09-26 07:30:00	MSFT	Stock	30.31	30.31	30.25	30.3	14300.0
2012-09-26 08:00:00	MSFT	Stock	30.3	30.33	30.28	30.28	15514.0
2012-09-26 08:30:00	MSFT	Stock	30.29	30.36	30.29	30.36	30851.0
2012-09-26 09:00:00	MSFT	Stock	30.34	30.36	30.23	30.28	62553.0
2012-09-26 09:30:00	MSFT	Stock	30.28	30.6	30.24	30.25	8979087.0
2012-09-26 10:00:00	MSFT	Stock	30.25	30.3	30.05	30.05	5184571.0
2012-09-26 10:30:00	MSFT	Stock	30.055	30.11	30.04	30.07	5085194.0
2012-09-26 11:00:00	MSFT	Stock	30.075	30.2	30.06	30.17	2924019.0
2012-09-26 11:30:00	MSFT	Stock	30.17	30.2	30.11	30.165	2113009.0
2012-09-26 12:00:00	MSFT	Stock	30.165	30.19	30.09	30.13	2574832.0
2012-09-26 12:30:00	MSFT	Stock	30.125	30.15	30.07	30.11	3421742.0
2012-09-26 13:00:00	MSFT	Stock	30.11	30.2	30.1	30.178	2131271.0
2012-09-26 13:30:00	MSFT	Stock	30.172	30.19	30.09	30.1	1624675.0
2012-09-26 14:00:00	MSFT	Stock	30.1	30.16	30.09	30.125	1687989.0
2012-09-26 14:30:00	MSFT	Stock	30.13	30.16	30.085	30.11	1850389.0
2012-09-26 15:00:00	MSFT	Stock	30.115	30.13	30.06	30.101	2742503.0
2012-09-26 15:30:00	MSFT	Stock	30.1	30.185	30.1	30.18	7435269.0
2012-09-26 16:00:00	MSFT	Stock	30.175	30.2	30.122	30.2	1643426.0

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

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