PREVIEW / stock_30min / 2011-08-22

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-22.parquet
  size:    1.4 MB
  rows:    75,081
  symbols: 3,546

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
2011-08-22 04:00:00	AAPL	Stock	12.8179	12.8564	12.8179	12.8429	33600.0
2011-08-22 04:30:00	AAPL	Stock	12.8339	12.8571	12.8275	12.8571	25200.0
2011-08-22 05:00:00	AAPL	Stock	12.8571	12.8571	12.8571	12.8571	21980.0
2011-08-22 05:30:00	AAPL	Stock	12.8693	12.8693	12.8693	12.8693	2800.0
2011-08-22 06:00:00	AAPL	Stock	12.8571	12.8679	12.8571	12.8679	8400.0
2011-08-22 06:30:00	AAPL	Stock	12.8879	12.8879	12.8861	12.8861	5600.0
2011-08-22 07:00:00	AAPL	Stock	12.8904	12.9429	12.8575	12.9421	383572.0
2011-08-22 07:30:00	AAPL	Stock	12.9439	12.98	12.9314	12.9639	666960.0
2011-08-22 08:00:00	AAPL	Stock	12.9636	12.9779	12.8982	12.9064	2208528.0
2011-08-22 08:30:00	AAPL	Stock	12.9018	12.9596	12.8971	12.9464	2108204.0
2011-08-22 09:00:00	AAPL	Stock	12.9464	13.0282	12.9429	13.0189	3063648.0
2011-08-22 09:30:00	AAPL	Stock	13.0229	13.0314	12.8314	12.8396	84232652.0
2011-08-22 10:00:00	AAPL	Stock	12.8446	12.9032	12.7807	12.8874	56969388.0
2011-08-22 10:30:00	AAPL	Stock	12.8886	12.9186	12.825	12.8282	34127352.0
2011-08-22 11:00:00	AAPL	Stock	12.8254	12.8568	12.7786	12.8201	30726528.0
2011-08-22 11:30:00	AAPL	Stock	12.8157	12.8257	12.7082	12.7179	43464568.0
2011-08-22 12:00:00	AAPL	Stock	12.7182	12.8211	12.7111	12.7907	32899272.0
2011-08-22 12:30:00	AAPL	Stock	12.7908	12.8643	12.7521	12.8546	36890840.0
2011-08-22 13:00:00	AAPL	Stock	12.8536	12.8911	12.8257	12.8272	30250332.0
2011-08-22 13:30:00	AAPL	Stock	12.8288	12.85	12.7468	12.8011	28200956.0
2011-08-22 14:00:00	AAPL	Stock	12.8004	12.8586	12.7611	12.7832	24920980.0
2011-08-22 14:30:00	AAPL	Stock	12.7832	12.7948	12.7107	12.7143	24030104.0
2011-08-22 15:00:00	AAPL	Stock	12.7143	12.7936	12.7107	12.7761	29519672.0
2011-08-22 15:30:00	AAPL	Stock	12.7761	12.7957	12.6818	12.7289	50209096.0
2011-08-22 16:00:00	AAPL	Stock	12.7139	12.8205	12.7139	12.73	11053420.0
2011-08-22 16:30:00	AAPL	Stock	12.7364	12.8464	12.7364	12.8464	163800.0
2011-08-22 17:00:00	AAPL	Stock	12.7404	12.7443	12.7393	12.7414	42000.0
2011-08-22 17:30:00	AAPL	Stock	12.7368	12.7439	12.7368	12.7411	65128.0
2011-08-22 18:00:00	AAPL	Stock	12.7364	12.7364	12.73	12.7321	62664.0
2011-08-22 18:30:00	AAPL	Stock	12.7357	12.74	12.7229	12.7318	229768.0
2011-08-22 19:00:00	AAPL	Stock	12.7239	12.7239	12.7196	12.7214	34440.0
2011-08-22 19:30:00	AAPL	Stock	12.725	12.7321	12.7143	12.7321	380744.0
2011-08-22 06:30:00	MSFT	Stock	24.37	24.37	24.37	24.37	6000.0
2011-08-22 07:00:00	MSFT	Stock	24.34	24.38	24.32	24.36	3100.0
2011-08-22 07:30:00	MSFT	Stock	24.31	24.37	24.31	24.35	2710.0
2011-08-22 08:00:00	MSFT	Stock	24.33	24.37	24.3	24.34	21156.0
2011-08-22 08:30:00	MSFT	Stock	24.34	24.4	24.34	24.35	33800.0
2011-08-22 09:00:00	MSFT	Stock	24.35	24.44	24.31	24.43	83325.0
2011-08-22 09:30:00	MSFT	Stock	24.42	24.49	24.15	24.152	8623338.0
2011-08-22 10:00:00	MSFT	Stock	24.16	24.22	24.07	24.2	3740586.0
2011-08-22 10:30:00	MSFT	Stock	24.2	24.23	23.96	23.98	3626198.0
2011-08-22 11:00:00	MSFT	Stock	23.98	24.02	23.82	23.868	5039559.0
2011-08-22 11:30:00	MSFT	Stock	23.87	23.92	23.79	23.89	3070033.0
2011-08-22 12:00:00	MSFT	Stock	23.89	24.11	23.87	24.035	2834816.0
2011-08-22 12:30:00	MSFT	Stock	24.035	24.16	23.95	24.14	2635603.0
2011-08-22 13:00:00	MSFT	Stock	24.14	24.18	24.05	24.06	1866449.0
2011-08-22 13:30:00	MSFT	Stock	24.055	24.09	23.95	24.05	2126481.0
2011-08-22 14:00:00	MSFT	Stock	24.05	24.11	23.97	24.01	2999917.0
2011-08-22 14:30:00	MSFT	Stock	24.01	24.02	23.89	23.9	2662587.0
2011-08-22 15:00:00	MSFT	Stock	23.9	24.1	23.89	24.09	3634371.0

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

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