PREVIEW / stock_30min / 2012-05-03

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-05-03.parquet
  size:    1.5 MB
  rows:    78,140
  symbols: 3,541

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-05-03 04:00:00	AAPL	Stock	20.9546	20.9821	20.9546	20.9821	36400.0
2012-05-03 04:30:00	AAPL	Stock	20.9643	20.9643	20.9643	20.9643	21700.0
2012-05-03 05:00:00	AAPL	Stock	20.9639	20.9639	20.9639	20.9639	14000.0
2012-05-03 05:30:00	AAPL	Stock	20.9464	20.9464	20.9464	20.9464	13580.0
2012-05-03 06:30:00	AAPL	Stock	20.9468	20.9468	20.9464	20.9464	11200.0
2012-05-03 07:00:00	AAPL	Stock	20.9643	21.0189	20.9461	21.0186	119504.0
2012-05-03 07:30:00	AAPL	Stock	21.0354	21.0354	20.9825	20.9825	184968.0
2012-05-03 08:00:00	AAPL	Stock	20.9861	21.0321	20.9282	20.9643	1404928.0
2012-05-03 08:30:00	AAPL	Stock	20.9839	21.0536	20.9714	21.0243	2998912.0
2012-05-03 09:00:00	AAPL	Stock	21.0196	21.1	21.0196	21.1	2575524.0
2012-05-03 09:30:00	AAPL	Stock	21.0893	21.1214	20.9911	21.02	62569640.0
2012-05-03 10:00:00	AAPL	Stock	21.02	21.0257	20.9243	20.9686	38275692.0
2012-05-03 10:30:00	AAPL	Stock	20.9686	21.0357	20.9464	21.0357	28009408.0
2012-05-03 11:00:00	AAPL	Stock	21.0336	21.0357	20.9539	20.9543	16664816.0
2012-05-03 11:30:00	AAPL	Stock	20.9543	20.9796	20.8686	20.8789	28760676.0
2012-05-03 12:00:00	AAPL	Stock	20.8764	20.8881	20.8086	20.8474	25987388.0
2012-05-03 12:30:00	AAPL	Stock	20.8482	20.9282	20.8336	20.8743	19393192.0
2012-05-03 13:00:00	AAPL	Stock	20.8743	20.8904	20.8314	20.8746	12324368.0
2012-05-03 13:30:00	AAPL	Stock	20.8746	20.8746	20.7596	20.7596	27988128.0
2012-05-03 14:00:00	AAPL	Stock	20.7607	20.8036	20.74	20.7764	25865952.0
2012-05-03 14:30:00	AAPL	Stock	20.7764	20.8036	20.725	20.765	16908556.0
2012-05-03 15:00:00	AAPL	Stock	20.7693	20.8371	20.7289	20.8042	22034460.0
2012-05-03 15:30:00	AAPL	Stock	20.7993	20.8093	20.7364	20.7765	32577692.0
2012-05-03 16:00:00	AAPL	Stock	20.7793	20.9818	20.7543	20.7571	18117876.0
2012-05-03 16:30:00	AAPL	Stock	20.7614	20.8042	20.7468	20.7471	648200.0
2012-05-03 17:00:00	AAPL	Stock	20.7793	20.7793	20.7325	20.7536	436016.0
2012-05-03 17:30:00	AAPL	Stock	20.7561	20.7793	20.7393	20.7446	119952.0
2012-05-03 18:00:00	AAPL	Stock	20.7429	20.7461	20.7343	20.7454	122444.0
2012-05-03 18:30:00	AAPL	Stock	20.7482	20.7589	20.7325	20.7325	95088.0
2012-05-03 19:00:00	AAPL	Stock	20.7414	20.7461	20.7329	20.7429	74844.0
2012-05-03 19:30:00	AAPL	Stock	20.7404	20.7429	20.7254	20.7254	245336.0
2012-05-03 08:00:00	MSFT	Stock	31.83	31.9	31.83	31.88	3175.0
2012-05-03 08:30:00	MSFT	Stock	31.9	31.9	31.85	31.85	6900.0
2012-05-03 09:00:00	MSFT	Stock	31.85	31.86	31.84	31.85	5528.0
2012-05-03 09:30:00	MSFT	Stock	31.88	31.88	31.7	31.77	2718542.0
2012-05-03 10:00:00	MSFT	Stock	31.76	31.78	31.689	31.779	2749699.0
2012-05-03 10:30:00	MSFT	Stock	31.775	31.9	31.77	31.85	2077396.0
2012-05-03 11:00:00	MSFT	Stock	31.855	31.87	31.81	31.84	1437439.0
2012-05-03 11:30:00	MSFT	Stock	31.835	31.86	31.66	31.74	2393964.0
2012-05-03 12:00:00	MSFT	Stock	31.735	31.82	31.67	31.805	1966818.0
2012-05-03 12:30:00	MSFT	Stock	31.805	31.83	31.75	31.75	1045018.0
2012-05-03 13:00:00	MSFT	Stock	31.75	31.78	31.7	31.775	766797.0
2012-05-03 13:30:00	MSFT	Stock	31.77	31.775	31.62	31.669	2146550.0
2012-05-03 14:00:00	MSFT	Stock	31.66	31.72	31.64	31.695	1417892.0
2012-05-03 14:30:00	MSFT	Stock	31.7	31.74	31.63	31.667	1651640.0
2012-05-03 15:00:00	MSFT	Stock	31.66	31.74	31.61	31.701	2427250.0
2012-05-03 15:30:00	MSFT	Stock	31.7	31.78	31.69	31.76	6289360.0
2012-05-03 16:00:00	MSFT	Stock	31.75	31.78	31.66	31.66	1905666.0
2012-05-03 16:30:00	MSFT	Stock	31.69	31.76	31.69	31.69	124964.0
2012-05-03 17:00:00	MSFT	Stock	31.76	31.76	31.67	31.76	58000.0

> showing 50 of 78,140 rows — these rows as CSV

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