PREVIEW / stock_30min / 2013-07-03

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-07-03.parquet
  size:    948 KB
  rows:    45,210
  symbols: 3,403

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
2013-07-03 04:00:00	AAPL	Stock	14.9107	14.9107	14.8286	14.8393	22400.0
2013-07-03 04:30:00	AAPL	Stock	14.8407	14.8407	14.8407	14.8407	2800.0
2013-07-03 05:00:00	AAPL	Stock	14.8839	14.8839	14.8839	14.8839	2800.0
2013-07-03 06:30:00	AAPL	Stock	14.8564	14.8571	14.8564	14.8571	16800.0
2013-07-03 07:00:00	AAPL	Stock	14.8571	14.8654	14.8561	14.8568	97860.0
2013-07-03 07:30:00	AAPL	Stock	14.8721	14.8839	14.8679	14.8825	48804.0
2013-07-03 08:00:00	AAPL	Stock	14.8854	14.95	14.8393	14.9286	1491728.0
2013-07-03 08:30:00	AAPL	Stock	14.9289	15.0286	14.9289	15.0143	2406824.0
2013-07-03 09:00:00	AAPL	Stock	15.0129	15.0636	15.0057	15.0264	3023972.0
2013-07-03 09:30:00	AAPL	Stock	15.0321	15.1064	14.9093	14.9629	77822304.0
2013-07-03 10:00:00	AAPL	Stock	14.9639	15.0168	14.9089	14.9721	36656508.0
2013-07-03 10:30:00	AAPL	Stock	14.9775	15.0068	14.9575	14.9767	17252788.0
2013-07-03 11:00:00	AAPL	Stock	14.978	15.0117	14.9468	14.9954	15389948.0
2013-07-03 11:30:00	AAPL	Stock	14.9957	15.0804	14.9732	15.0761	27549200.0
2013-07-03 12:00:00	AAPL	Stock	15.0729	15.0993	15.0582	15.0784	22384068.0
2013-07-03 12:30:00	AAPL	Stock	15.0782	15.0782	15.0	15.0271	31228764.0
2013-07-03 13:00:00	AAPL	Stock	15.0271	15.04	14.9758	15.01	3479672.0
2013-07-03 13:30:00	AAPL	Stock	15.0339	15.0482	15.0286	15.0482	293188.0
2013-07-03 14:00:00	AAPL	Stock	15.0286	15.05	15.0286	15.0411	169764.0
2013-07-03 14:30:00	AAPL	Stock	15.0357	15.0429	15.0325	15.0364	33600.0
2013-07-03 15:00:00	AAPL	Stock	15.0464	15.0464	15.0307	15.0332	75096.0
2013-07-03 15:30:00	AAPL	Stock	15.0304	15.0439	15.0304	15.0439	19600.0
2013-07-03 16:00:00	AAPL	Stock	15.0536	15.0536	15.0536	15.0536	3696.0
2013-07-03 16:30:00	AAPL	Stock	15.0679	15.0679	15.0361	15.0361	17052.0
2013-07-03 04:30:00	MSFT	Stock	33.89	33.89	33.89	33.89	190.0
2013-07-03 05:30:00	MSFT	Stock	33.65	33.65	33.64	33.64	774.0
2013-07-03 06:30:00	MSFT	Stock	33.62	33.66	33.62	33.66	813.0
2013-07-03 07:00:00	MSFT	Stock	33.66	33.66	33.66	33.66	698.0
2013-07-03 07:30:00	MSFT	Stock	33.68	33.68	33.66	33.66	669.0
2013-07-03 08:00:00	MSFT	Stock	33.76	33.85	33.67	33.85	6390.0
2013-07-03 08:30:00	MSFT	Stock	33.8	33.89	33.8	33.85	1917.0
2013-07-03 09:00:00	MSFT	Stock	33.85	33.96	33.54	33.63	70098.0
2013-07-03 09:30:00	MSFT	Stock	33.63	33.95	33.6	33.875	2905640.0
2013-07-03 10:00:00	MSFT	Stock	33.877	34.045	33.77	34.01	2268125.0
2013-07-03 10:30:00	MSFT	Stock	34.02	34.09	33.94	34.015	1978232.0
2013-07-03 11:00:00	MSFT	Stock	34.02	34.13	33.96	34.075	1463445.0
2013-07-03 11:30:00	MSFT	Stock	34.075	34.2	34.02	34.2	1709811.0
2013-07-03 12:00:00	MSFT	Stock	34.2	34.37	34.18	34.294	1857707.0
2013-07-03 12:30:00	MSFT	Stock	34.3	34.3	34.0	34.0	2576522.0
2013-07-03 13:00:00	MSFT	Stock	34.0	34.18	34.0	34.01	700279.0
2013-07-03 13:30:00	MSFT	Stock	34.01	34.05	34.0	34.0	16491.0
2013-07-03 14:00:00	MSFT	Stock	33.98	34.01	33.95	34.01	55090.0
2013-07-03 15:00:00	MSFT	Stock	34.01	34.01	34.01	34.01	245.0
2013-07-03 15:30:00	MSFT	Stock	34.05	34.05	34.05	34.05	100.0
2013-07-03 16:00:00	MSFT	Stock	34.01	34.01	34.01	34.01	600.0
2013-07-03 16:30:00	MSFT	Stock	34.13	34.13	34.13	34.13	400.0
2013-07-03 09:00:00	NVDA	Stock	0.349	0.349	0.349	0.349	28000.0
2013-07-03 09:30:00	NVDA	Stock	0.3493	0.3558	0.3493	0.3553	33446120.0
2013-07-03 10:00:00	NVDA	Stock	0.3553	0.3575	0.3545	0.3565	24790320.0
2013-07-03 10:30:00	NVDA	Stock	0.3565	0.3568	0.3548	0.356	14189200.0

> showing 50 of 45,210 rows — these rows as CSV

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