PREVIEW / stock_30min / 2012-10-23

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-10-23.parquet
  size:    1.4 MB
  rows:    75,792
  symbols: 3,482

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-10-23 04:00:00	AAPL	Stock	22.5714	22.6071	22.5432	22.6071	135492.0
2012-10-23 04:30:00	AAPL	Stock	22.5786	22.5786	22.5786	22.5786	2800.0
2012-10-23 05:00:00	AAPL	Stock	22.5607	22.5607	22.5607	22.5607	14980.0
2012-10-23 05:30:00	AAPL	Stock	22.6071	22.6071	22.5679	22.5679	35784.0
2012-10-23 06:00:00	AAPL	Stock	22.5607	22.5786	22.5004	22.5004	45920.0
2012-10-23 06:30:00	AAPL	Stock	22.5321	22.5357	22.5004	22.5036	13104.0
2012-10-23 07:00:00	AAPL	Stock	22.5357	22.5714	22.5	22.5714	317240.0
2012-10-23 07:30:00	AAPL	Stock	22.5714	22.5714	22.5004	22.5296	540232.0
2012-10-23 08:00:00	AAPL	Stock	22.5179	22.5714	22.45	22.5179	2236808.0
2012-10-23 08:30:00	AAPL	Stock	22.5	22.5175	22.4457	22.4875	1469440.0
2012-10-23 09:00:00	AAPL	Stock	22.4889	22.5464	22.4714	22.5368	2036104.0
2012-10-23 09:30:00	AAPL	Stock	22.5343	22.5489	22.2686	22.3257	78021692.0
2012-10-23 10:00:00	AAPL	Stock	22.3255	22.4921	22.3163	22.3971	37495276.0
2012-10-23 10:30:00	AAPL	Stock	22.4047	22.4047	22.2821	22.3832	29261232.0
2012-10-23 11:00:00	AAPL	Stock	22.3832	22.3854	22.2829	22.3368	22670200.0
2012-10-23 11:30:00	AAPL	Stock	22.3336	22.3529	22.2014	22.3486	27066144.0
2012-10-23 12:00:00	AAPL	Stock	22.35	22.3861	22.2757	22.3521	17041388.0
2012-10-23 12:30:00	AAPL	Stock	22.3525	22.4918	22.3508	22.4411	24950940.0
2012-10-23 13:00:00	AAPL	Stock	22.4321	22.6339	22.4169	22.5507	52433388.0
2012-10-23 13:30:00	AAPL	Stock	22.5578	22.6393	22.3364	22.4549	57379812.0
2012-10-23 14:00:00	AAPL	Stock	22.4543	22.5357	21.9968	22.0679	123526480.0
2012-10-23 14:30:00	AAPL	Stock	22.0739	22.375	22.0164	22.2086	73072552.0
2012-10-23 15:00:00	AAPL	Stock	22.2114	22.3179	22.0789	22.0871	45364424.0
2012-10-23 15:30:00	AAPL	Stock	22.0864	22.1138	21.8464	21.9079	90270376.0
2012-10-23 16:00:00	AAPL	Stock	21.9088	22.5081	21.8929	21.9186	12644240.0
2012-10-23 16:30:00	AAPL	Stock	21.9275	22.0883	21.9057	21.9057	820876.0
2012-10-23 17:00:00	AAPL	Stock	21.9414	21.9921	21.9414	21.9839	401464.0
2012-10-23 17:30:00	AAPL	Stock	21.9804	21.9857	21.9679	21.9736	199248.0
2012-10-23 18:00:00	AAPL	Stock	21.9679	21.9714	21.9571	21.9629	265776.0
2012-10-23 18:30:00	AAPL	Stock	21.9582	21.9671	21.9464	21.9643	135548.0
2012-10-23 19:00:00	AAPL	Stock	21.9643	21.9761	21.9625	21.9732	113316.0
2012-10-23 19:30:00	AAPL	Stock	21.975	22.0057	21.975	21.9929	403228.0
2012-10-23 04:00:00	MSFT	Stock	28.04	28.04	28.04	28.04	100.0
2012-10-23 06:00:00	MSFT	Stock	27.78	27.78	27.77	27.77	200.0
2012-10-23 07:00:00	MSFT	Stock	27.8	27.85	27.8	27.85	1500.0
2012-10-23 07:30:00	MSFT	Stock	27.81	27.81	27.8	27.8	4580.0
2012-10-23 08:00:00	MSFT	Stock	27.83	27.85	27.75	27.8	37951.0
2012-10-23 08:30:00	MSFT	Stock	27.79	27.8	27.76	27.8	78812.0
2012-10-23 09:00:00	MSFT	Stock	27.8	27.8	27.76	27.76	49058.0
2012-10-23 09:30:00	MSFT	Stock	27.76	28.08	27.76	28.04	7143684.0
2012-10-23 10:00:00	MSFT	Stock	28.05	28.16	27.91	27.965	7153381.0
2012-10-23 10:30:00	MSFT	Stock	27.965	28.12	27.86	28.09	7520985.0
2012-10-23 11:00:00	MSFT	Stock	28.09	28.14	28.01	28.115	4761808.0
2012-10-23 11:30:00	MSFT	Stock	28.11	28.118	27.995	28.02	3931095.0
2012-10-23 12:00:00	MSFT	Stock	28.03	28.06	27.95	27.99	2700343.0
2012-10-23 12:30:00	MSFT	Stock	28.0	28.09	27.99	28.025	3329374.0
2012-10-23 13:00:00	MSFT	Stock	28.03	28.19	28.02	28.086	2965938.0
2012-10-23 13:30:00	MSFT	Stock	28.085	28.13	28.04	28.09	2409493.0
2012-10-23 14:00:00	MSFT	Stock	28.095	28.11	28.0	28.06	3096148.0
2012-10-23 14:30:00	MSFT	Stock	28.06	28.18	28.04	28.11	2973365.0

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

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