PREVIEW / stock_30min / 2012-04-16

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-04-16.parquet
  size:    1.4 MB
  rows:    75,762
  symbols: 3,527

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-04-16 04:00:00	AAPL	Stock	21.5671	21.5982	21.5536	21.5536	53200.0
2012-04-16 04:30:00	AAPL	Stock	21.5893	21.5893	21.5893	21.5893	11200.0
2012-04-16 05:00:00	AAPL	Stock	21.6036	21.6036	21.5982	21.5982	11200.0
2012-04-16 05:30:00	AAPL	Stock	21.6068	21.6214	21.6068	21.6214	16800.0
2012-04-16 06:00:00	AAPL	Stock	21.6929	21.7125	21.6929	21.6986	30968.0
2012-04-16 06:30:00	AAPL	Stock	21.7036	21.7036	21.6761	21.6804	94304.0
2012-04-16 07:00:00	AAPL	Stock	21.6786	21.7321	21.675	21.7046	657020.0
2012-04-16 07:30:00	AAPL	Stock	21.7036	21.7039	21.6561	21.6782	310800.0
2012-04-16 08:00:00	AAPL	Stock	21.6771	21.7507	21.6554	21.7307	2030280.0
2012-04-16 08:30:00	AAPL	Stock	21.7289	21.8389	21.7289	21.7786	4828516.0
2012-04-16 09:00:00	AAPL	Stock	21.7786	21.8	21.7686	21.78	2245068.0
2012-04-16 09:30:00	AAPL	Stock	21.7879	21.7957	20.7964	20.9946	234928960.0
2012-04-16 10:00:00	AAPL	Stock	20.9929	21.1893	20.9132	21.0596	133204120.0
2012-04-16 10:30:00	AAPL	Stock	21.0571	21.3168	21.0418	21.1971	84689584.0
2012-04-16 11:00:00	AAPL	Stock	21.1954	21.2276	21.0893	21.1446	46004112.0
2012-04-16 11:30:00	AAPL	Stock	21.1414	21.15	20.9396	21.0125	61959660.0
2012-04-16 12:00:00	AAPL	Stock	21.0071	21.0892	20.9429	21.0008	41042316.0
2012-04-16 12:30:00	AAPL	Stock	20.9995	21.0136	20.8929	20.9918	46298308.0
2012-04-16 13:00:00	AAPL	Stock	20.9975	21.0064	20.8171	20.85	47817896.0
2012-04-16 13:30:00	AAPL	Stock	20.8496	20.9821	20.8346	20.9225	48095040.0
2012-04-16 14:00:00	AAPL	Stock	20.9222	20.9393	20.8489	20.8764	34515404.0
2012-04-16 14:30:00	AAPL	Stock	20.8786	21.0375	20.8532	20.9107	51227708.0
2012-04-16 15:00:00	AAPL	Stock	20.9087	20.9211	20.7725	20.8343	62516104.0
2012-04-16 15:30:00	AAPL	Stock	20.8293	20.8643	20.6518	20.7375	110115096.0
2012-04-16 16:00:00	AAPL	Stock	20.7246	21.0448	20.7168	20.7786	20309660.0
2012-04-16 16:30:00	AAPL	Stock	20.7771	21.6154	20.7189	20.75	1481144.0
2012-04-16 17:00:00	AAPL	Stock	20.7468	20.7657	20.7346	20.7557	485296.0
2012-04-16 17:30:00	AAPL	Stock	20.7589	20.7664	20.7546	20.7639	198324.0
2012-04-16 18:00:00	AAPL	Stock	20.7589	20.7643	20.7429	20.7493	336196.0
2012-04-16 18:30:00	AAPL	Stock	20.7493	20.75	20.7232	20.7246	137620.0
2012-04-16 19:00:00	AAPL	Stock	20.725	20.725	20.7143	20.7143	246764.0
2012-04-16 19:30:00	AAPL	Stock	20.7107	20.7143	20.6832	20.6875	393288.0
2012-04-16 07:30:00	MSFT	Stock	30.9	30.9	30.9	30.9	500.0
2012-04-16 08:00:00	MSFT	Stock	31.02	31.02	30.9	30.95	3950.0
2012-04-16 08:30:00	MSFT	Stock	30.95	30.95	30.9	30.9	5710.0
2012-04-16 09:00:00	MSFT	Stock	30.9	31.0	30.9	30.98	10456.0
2012-04-16 09:30:00	MSFT	Stock	30.99	31.13	30.86	31.0	3640708.0
2012-04-16 10:00:00	MSFT	Stock	30.99	31.0	30.77	30.85	3770445.0
2012-04-16 10:30:00	MSFT	Stock	30.84	30.97	30.8	30.95	2606380.0
2012-04-16 11:00:00	MSFT	Stock	30.945	30.97	30.9	30.94	1805070.0
2012-04-16 11:30:00	MSFT	Stock	30.93	30.94	30.85	30.86	1349336.0
2012-04-16 12:00:00	MSFT	Stock	30.87	30.957	30.86	30.915	1261436.0
2012-04-16 12:30:00	MSFT	Stock	30.917	31.04	30.89	31.04	1689644.0
2012-04-16 13:00:00	MSFT	Stock	31.04	31.07	30.99	31.016	1408030.0
2012-04-16 13:30:00	MSFT	Stock	31.02	31.16	31.01	31.12	2224402.0
2012-04-16 14:00:00	MSFT	Stock	31.125	31.15	31.08	31.135	1287359.0
2012-04-16 14:30:00	MSFT	Stock	31.13	31.19	31.08	31.089	2512515.0
2012-04-16 15:00:00	MSFT	Stock	31.08	31.09	31.02	31.07	1824208.0
2012-04-16 15:30:00	MSFT	Stock	31.075	31.16	31.05	31.09	5834852.0
2012-04-16 16:00:00	MSFT	Stock	31.085	31.13	30.87	31.1	5783598.0

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

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